1z0-071最も有効な質問と解答で勉強

Tech4Examでは、学習スタイルに合わせてPDF版・デスクトップテストエンジン・オンラインテストエンジンの3つの形態をご用意しています。自宅のパソコンでじっくり解くもよし、移動中に1z0-071の練習問題をスマートフォンで確認するもよし。Oracle Database SQLの対策を自分のペースで進められます。

Oracle 1z0-071 試験概要:

Oracle 1z0-071 試験シラバストピック:

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

Oracle Database SQL 認定 1z0-071 試験問題：

問題 #1

View the Exhibit and examine the structure in the EMPLOYEES tables.

Evaluate the following SQL statement:
SELECT employee_id, department_id
FROM employees
WHERE department_id= 50 ORDER BY department_id
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=90
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id=10;
What would be the outcome of the above SQL statement?

A. The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.
B. The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.
C. The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID.
D. The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.

問題 #2

You create a table named 123.
Which statement runs successfully?

A. SELECT * FROM '123';
B. SELECT * FROM "123";
C. SELECT * FROM \'123\';
D. SELECT * FROM TABLE(123);

問題 #3

Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure.

A. You cannot use SYSDATE in the condition of a CHECK constraint.
B. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the FOREIGN KEY.
C. You cannot use the BETWEEN clause in the condition of a CHECK constraint.
D. You cannot use the NEXTVAL sequence value as a DEFAULT value for a column.

問題 #4

In which three situations does a new transaction always start? (Choose three.)

A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
B. when issuing a DML statement after a DML statement failed in the same session
C. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
D. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
E. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
F. when issuing the first Data Manipulation Language (DML) statement after a COMMIT or ROLLBACK statement was issued in the same session

問題 #5

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
B. The Oracle join syntax only supports right outer joins.
C. The Oracle join syntax supports natural joins.
D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
E. The SQL:1999 compliant ANSI join syntax supports natural joins.
F. The Oracle join syntax supports creation of a Cartesian product of two tables.
G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.

解説：