Oracle Exam 1Z0-071 Topic 5 Question 100 Discussion

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

Question #: 100
Topic #: 5

Which two are true about using constraints?

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

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

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

DPRIMARY KEY and FOREIGNY constraints can be specified at the column and at the table level

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

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

Show Suggested Answer

Suggested Answer: D, E

by Daniela at Aug 28, 2024, 09:28 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cristina

3 months ago

I wonder if the exam question includes a constraint to prevent me from answering all the questions with random guesses. That would be a real constraint!

upvoted 0 times

Thaddeus

2 months ago

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

upvoted 0 times

...

Dierdre

2 months ago

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

upvoted 0 times

...

Krissy

2 months ago

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

upvoted 0 times

...

Willis

3 months ago

I believe D is correct because constraints can be specified at different levels.

upvoted 0 times

...

Sabra

3 months ago

For sure F is true. NOT NULL can be specified at both the column and table level. That's a basic constraint everyone should know.

upvoted 0 times

Cordelia

3 months ago

That's right, it's important to understand the different levels of constraints.

upvoted 0 times

...

Jutta

3 months ago

Yes, F is correct. NOT NULL can be specified at both levels.

upvoted 0 times

...

Justine

3 months ago

I'm not sure about E, but I think D is also true.

upvoted 0 times

...

Leonardo

3 months ago

I'm pretty sure B is false. A table can't have multiple primary key and multiple foreign key constraints. That just doesn't make sense.

upvoted 0 times

Rachael

3 months ago

Yes, B is definitely false. Tables can't have multiple primary key and foreign key constraints.

upvoted 0 times

...

Rachael

3 months ago

You're right, B is false. A table can only have one primary key and one foreign key constraint.

upvoted 0 times

...

Janet

3 months ago

E is definitely true. A table can have only one primary key, but it can have multiple foreign key constraints.

upvoted 0 times

Regenia

2 months ago

That's good to know. Constraints play an important role in maintaining data integrity.

upvoted 0 times

...

Bettina

3 months ago

D is also true. Primary key and foreign key constraints can be specified at the column and at the table level.

upvoted 0 times

...

Corrina

3 months ago

E is correct. A table can have only one primary key but multiple foreign key constraints.

upvoted 0 times

...

Candida

3 months ago

I agree with Stefanie. A and E make sense to me.

upvoted 0 times

...

Stefanie

4 months ago

I think A and E are true.

upvoted 0 times

...

Leatha

4 months ago

I think A and D are true. A foreign key column and the referenced primary key column must have the same names, and constraints can be specified at both the column and table level.

upvoted 0 times