1z1-071問題集、Oracle実際の試験問題

質問 1

Which two statements execute successfully? (Choose two.)

A.

B.

C.

D.

E.

正解: B,D

質問 2

Examine these statements and results:

How many rows are retrieved by the last query?

A. 42

B. 28

C. 14

D. 0

正解: C

質問 3

Which two statements are true regarding roles? (Choose two.)

A. A user can be granted only one role at any point of time.

B. A role can be granted to PUBLIC.

C. A role can be granted to itself.

D. The REVOKE command can be used to remove privileges but not roles from other users.

E. Roles are named groups of related privileges that can be granted to users or other roles.

正解: B,E

解説: (PassTest メンバーにのみ表示されます)

質問 4

Which two statements are true regarding constraints? (Choose two.)

A. All constraints can be defined at the column level and at the table level.

B. A column with the UNIQUE constraint can contain NULLS.

C. A constraint can be disabled even if the constraint column contains data.

D. A constraint is enforced only for INSERT operations.

E. A foreign key column cannot contain NULLS.

正解: B,C

質問 5

In your session, the NLS_DATE_FORMATis DD-MM-YYYY.
There are 86400 seconds in a day.
Examine this result:
DATE
-----------
02-JAN-2020
Which statement returns this?

A. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

B. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

C. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

D. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '86410' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

E. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

正解: C

質問 6

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

A. It fails because no SQL *Loader control file location is specified.

B. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

C. It fails because no SQL *Loader data file location is specified.

D. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

正解: B,D

解説: (PassTest メンバーにのみ表示されます)

質問 7

Which statement is true regarding the USING clause in table joins? (Choose two.)

A. It can be used to join tables that have columns with the same name and compatible data types.

B. It can be used to restrict the number of columns used in a NATURAL join.

C. It can be used to access data from tables through equijoins as well as nonequijoins.

D. It can be used to join a maximum of three tables.

正解: A,B

質問 8

Examine this statement:

What is returned upon execution?

A. an error

B. 1 row

C. 2 rows

D. 0 rows

正解: B

質問 9

Examine the description of the EMPLOYEES table:

Which statement will fail?

A.

B.

C.

D.

正解: C

質問 10

Examine the SQL statement used to create the TRANSACTION table.
SQL > CREATE TABLE transaction
(trn_id char(2) primary key,
Start_date date DEFAULT SYSDATE,
End_date date NOT NULL);
The value 'A1' does not exist for trn_id in this table.
Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

A. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))

B. INSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')

C. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))

D. INSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')

正解: D

質問 11

Examine this SQL statement:

Which two are true?

A. All existing rows in the ORDERS table are updated

B. The UPDATE statement executes successfully even if the subquery selects multiple rows

C. The subquery is executed before the UPDATE statement is executed

D. The subquery is not a correlated subquery

E. The subquery is executed for every updated row in the ORDERS table

正解: A,C

Oracle Database SQL - 1z1-071 模擬練習