Oracle Exam 1Z0-082 Topic 1 Question 45 Discussion

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

Question #: 45
Topic #: 1

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

AA table can have only one primary key but multiple foreign keys

BA table can have only one primary key and one foreign key

CThe foreign key columns and parent table primary key columns must have the same names

DIt is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

EIt is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

FOnly the primary key can be defined at the column and table level

GPrimary key and foreign key constraints can be defined at both the column and table level

Show Suggested Answer

Suggested Answer: A, C, E, G

by Katina at May 04, 2022, 09:28 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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