Exam 1z0-071 topic 1 question 70 discussion

Actual exam question from Oracle's 1z0-071

Question #: 70
Topic #: 1

[All 1z0-071 Questions]

Which two are true about using constraints? (Choose two.)

A. NOT NULL can be specified at the column and at the table level.
B. A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.
C. A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parent table must have the same names.
D. PRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table level.
E. A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.
F. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

Show Suggested Answer

Suggested Answer: DF 🗳️

by leongkaon at Dec. 10, 2022, 1:47 a.m.

Comments

Submit Cancel

lucemqy

7 months, 2 weeks ago

Selected Answer: DF

Not NULL constraints can only be set at column level not table level. Each table have only have one primary key constraint with multiple foreign key constraints

upvoted 1 times

...

HassanMkhlalati

7 months, 4 weeks ago

Selected Answer: DF

D and F are true

upvoted 1 times

...

Roneros

9 months, 3 weeks ago

Selected Answer: DF

https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj13590.html

upvoted 2 times

...

Eltelwany

1 year, 3 months ago

What does D mean?

upvoted 1 times

J4vi

1 year, 1 month ago

Is the way you specify the constraints syntactically. There are two ways... by column or by table (at the end of the statement). PK and FK can be defined in both.

upvoted 2 times

...

leongkaon

1 year, 6 months ago

why A not correct?

upvoted 2 times

Sidoogle

1 year, 5 months ago

Its exception that not null constrain is not allowed to be defined at table level.

upvoted 3 times

...