Oracle
1Z0-071 · Question #346
1Z0-071 Question #346: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #346. The question stem and answer options stay visible for context.
Question
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
Options
- AIt is possible for child rows that have a foreign key to remain in the child table at the time the
- BOnly the primary key can be defined at the column and table level
- CThe foreign key columns and parent table primary key columns must have the same names
- DA table can have only one primary key and one foreign key
- EA table can have only one primary key but multiple foreign keys
- FPrimary key and foreign key constraints can be defined at both the column and table level
- GIt is possible for child rows that have a foreign key to be deleted automatically from the child table
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.