Oracle Exam 1Z0-071 Topic 15 Question 6 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 6
Topic #: 15

Examine these statements:

Which two are true?

ABoth foreign key constraint definition must be removed from the CREATE statements, and be added with ALTER TABLE statements once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

BThe MGR column In the DEPT table will not be able to contain null values.

CThe DEPTNO column in the EMP table will be able to contain null values.

DThe DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT statement. and the added with an D. ALTER statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

EThe create TABLE EMP statement must precede the create table DEPT statement for all three statements to execute successfully.

FAll three statements execute successfully in the order shown.

Show Suggested Answer

Suggested Answer: C, D

by James at May 03, 2022, 06:21 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!