Oracle
1Z0-071 · Question #409
Which two are true about using constraints? (Choose two.)
The correct answer is A. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints. C. PRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table. See the full explanation below for the reasoning.
Question
Which two are true about using constraints? (Choose two.)
Options
- AA table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.
- BA table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.
- CPRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table
- DNOT NULL can be specified at the column and at the table level.
- EA FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parent
- FA table can have only one PRIMARY KEY and one FOREIGN KEY constraint.
How the community answered
(28 responses)- A71% (20)
- B7% (2)
- D14% (4)
- E4% (1)
- F4% (1)
Community Discussion
No community discussion yet for this question.