Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 70

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

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

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

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

PRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table level.

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

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

Correct Answer: D, F

A table can only have one PRIMARY KEY constraint but may have multiple FOREIGN KEY constraints. PRIMARY KEY and FOREIGN KEY constraints can be specified at both the column level and the table level. These rules ensure the structural integrity and relational nature of the database.

Discussion

RonerosOptions: DF

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

leongkaon

why A not correct?

Sidoogle

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

lucemqyOptions: 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

HassanMkhlalatiOptions: DF

D and F are true

Eltelwany

What does D mean?

J4vi

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.