1Z0-007最も有効な質問と解答で勉強

Oracle Introduction to Oracle9i: SQLは出題範囲が広く、独学だけでは論点の取りこぼしが起きがちな試験です。Tech4Examが用意する1Z0-007向けの110問の問題集は、本試験の傾向を踏まえて構成されており、苦手分野を的確に洗い出せます。

Oracle 1Z0-007 試験概要:

Oracle 1Z0-007 試験シラバストピック:

1Z0-007に挑戦する方へ – よくある質問まとめ

Oracle Introduction to Oracle9i: SQL 認定 1Z0-007 試験問題：

問題 #1

The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
CUSTOMER_ADDRESS VARCHAR2(150)
CUSTOMER_PHONE VARCHAR2(20)
You need to produce output that states "Dear Customer customer_name, ".
The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table.
Which statement produces this output?

A. SELECT dear customer, customer_name, FROM customers;
B. SELECT 'Dear Customer ' || customer_name || ',' || FROM customers;
C. SELECT "Dear Customer " || customer_name || "," FROM customers;
D. SELECT 'Dear Customer ' || customer_name || ',' FROM customers;
E. SELECT "Dear Customer", customer_name || ',' FROM customers;
F. SELECT 'Dear Customer ' || customer_name ',' FROM customers;

問題 #2

Which two are character manipulation functions? (Choose two.)

A. MOD
B. TRUNC
C. CASE
D. TRIM
E. TO_DATE
F. REPLACE

問題 #3

Examine the data from the ORDERS and CUSTOMERS tables.

Evaluate the SQL statement:
SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith');
What is the result when the query is executed?

A. Option E
B. Option B
C. Option D
D. Option C
E. Option A

問題 #4

Which one is a system privilege?

A. ALTER TABLE
B. EXECUTE
C. CREATE TABLE
D. DELETE
E. SELECT

問題 #5

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the
DEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)

A. The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
B. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
C. The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
D. You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
E. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
F. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

解説：