Oracle Exam 1Z0-071 Topic 5 Question 100 Discussion

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

Question #: 100
Topic #: 5

Which two are true about using constraints?

AA FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parenttable must have the same names.

BA table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

CA table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

DPRIMARY KEY and FOREIGNY constraints can be specified at the column and at the table level

EA table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

FNOT NULL can be specified at the column and at the table level.

Show Suggested Answer

Suggested Answer: D, E

by Daniela at Aug 28, 2024, 09:28 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Janet

5 days ago

E is definitely true. A table can have only one primary key, but it can have multiple foreign key constraints.

upvoted 0 times

...

Candida

7 days ago

I agree with Stefanie. A and E make sense to me.

upvoted 0 times

...

Stefanie

10 days ago

I think A and E are true.

upvoted 0 times

...

Leatha

13 days ago

I think A and D are true. A foreign key column and the referenced primary key column must have the same names, and constraints can be specified at both the column and table level.

upvoted 0 times

...