申込直後から学習を始めたい方のために、Fast2testの1Z0-007問題集は即時ダウンロードに対応しています。Oracle Introduction to Oracle9i: SQLの110問を購入後すぐに確認できるため、試験日が近い時期でも無駄なく準備できます。

1Z0-007試験対策に選べる3つの学習形式

• PDF版：印刷して持ち運べる形式で、専門家が作成した内容をすぐにダウンロードして確認できます。学習場所を選ばず、365日間の無料更新と無料PDFサンプルに対応しています。
• Desktop Test Engine：インストールして使用するソフトウェアで、実際の試験環境を再現した2つの練習モードを利用できます。オフライン学習に対応し、Windowsで動作します。
• Online Test Engine：ブラウザーからすぐにアクセスでき、学習履歴と成績を確認できます。Windows、Mac、Android、iOSで利用できます。

Fast2testの安心な購入・利用サポート

• McAfeeのセキュリティサービスにより、お客様の情報を安全に取り扱います。
• ご購入後365日間は無料で更新版をご利用いただけます。更新期間の終了後も、50%割引で継続更新が可能です。
• ご入金確認後はすぐにダウンロードでき、通常1分以内にメールでもお届けします。2時間経っても届かない場合は、カスタマーサポートへご連絡ください。
• インストール可能なパソコン台数に制限はありません。

Oracle Introduction to Oracle9i: SQLの試験情報

Oracle 1Z0-007 試験概要:

1Z0-007試験の出題範囲

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

1Z0-007試験の疑問を解消するFAQ

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

問題 #1

EMPLOYEES and DEPARTMENTS data:

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID
managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
Evaluate this UPDATE statement.
UPDATE employees
SET mgr_id =
(SELECT mgr_id
FROM employees
WHERE dept_id=
(SELECT department_id
FROM departments
WHERE department_name = 'Administration')),
Salary = (SELECT salary
FROM employees
WHERE emp_name = 'Smith')
WHERE job_id = 'IT_ADMIN';
What happens when the statement is executed?

A. The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.
B. The statement fails because there is no 'Administration' department in the DEPARTMENTS table.
C. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.
D. The statement fails because there is more than one row matching the employee name Smith.
E. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.
F. The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.

問題 #2

Examine the SQL statements that create ORDERS table:

For which columns would an index be automatically created when you execute the above
SQL statement? (Choose two)

A. STATUS
B. ORD_TOTAL
C. SER_NO
D. Composite index on ORDER_ID and ORDER_DATE
E. ORDER_ID
F. PROD_ID

問題 #3

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)

A. You can roll back the deletion of rows after the statement executes.
B. You can NOT roll back the deletion of rows after the statement executes.
C. It releases the storage space used by the table.
D. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
E. It does not release the storage space used by the table.
F. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

問題 #4

Which two statements about subqueries are true? (Choose two.)

A. A subquery can retrieve zero or more rows.
B. A subquery should retrieve only one row.
C. A subquery can be used only in SQL query statements.
D. Subqueries CANNOT be nested by more than two levels.
E. When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
F. A subquery CANNOT be used in an SQL query statement that uses group functions.

問題 #5

Scott issues the SQL statements:

If Sue needs to select from Scott's DEPT table, which command should she use?

A. SELECT *
FROM DBA.SCOTT.DEPT;
B. SELECT *
FROM DEPT;
C. SELECT *
FROM SCOTT.DEPT;
D. SELECT *
FROM ALL_USERS
WHERE USER_NAME = 'SCOTT'
AND TABLE NAME = 'DEPT';

解説：