Oracle Database SQL: 1Z0-071

You execute these commands successfully:

Which two are true?

A. You can add a foreign key to the table.

B. When you terminate your session, the row will be deleted.

C. To drop the table in this session, you must first truncate it.

D. You can add a column to the table in this session.

E. Other sessions can view the committed row.

You execute the following commands:

SQL > DEFINE hiredate = '01-APR-2011'

SQL >SELECT employee_id, first_name, salary

FROM employees

WHERE hire_date > 'andhiredate'

AND manager_id > andmgr_id;

For Which substitution variables are you prompted for the input?

A. none, because no input required

B. both the substitution variables ''hiredate' and 'mgr_id'.

C. only hiredate'

D. only 'mgr_id'

Examine these SQL statements that are executed in the given order:

What will be the status of the foreign key EMP_MGR_FK?

A. It will be enabled and immediate.

B. It will be enabled and deferred.

C. It will remain disabled and can be re-enabled manually.

D. It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.