Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-071 Topic 11 Question 97 Discussion

Actual exam question for Oracle's 1Z0-071 exam
Question #: 97
Topic #: 11
[All 1Z0-071 Questions]

Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

Show Suggested Answer Hide Answer
Suggested Answer: E

Contribute your Thoughts:

Valentine
1 months ago
I thought the primary key was the key to my heart, not the database. Guess I need to brush up on my SQL skills.
upvoted 0 times
...
Odette
1 months ago
Wow, this is a tough one. I'm just going to randomly guess and hope for the best!
upvoted 0 times
...
Veronica
1 months ago
This is a classic database question. I'm going with B, C, and E as the correct answers.
upvoted 0 times
Titus
4 days ago
E is correct because child rows with foreign keys can be automatically deleted when the parent row is deleted.
upvoted 0 times
...
Juan
6 days ago
C is true because primary and foreign key constraints can be defined at both the column and table level.
upvoted 0 times
...
Clarinda
15 days ago
I think B is correct because child rows with foreign keys can stay in the child table after the parent row is deleted.
upvoted 0 times
...
...
Brandee
2 months ago
E is definitely true, but I'm not confident about the others. The question seems a bit tricky.
upvoted 0 times
Davida
3 days ago
You're right, and B is also true, child rows with foreign keys can remain in the child table even if the parent row is deleted.
upvoted 0 times
...
Ricarda
5 days ago
I'm not sure about A, but I think G is false, a table can have multiple foreign keys.
upvoted 0 times
...
Kristin
21 days ago
I agree, and I believe F is true as well, the foreign key columns and parent table primary key columns must have the same names.
upvoted 0 times
...
Krissy
1 months ago
I think C is also true, primary and foreign key constraints can be defined at both the column and table level.
upvoted 0 times
...
...
Ena
2 months ago
I agree with both of you, statement E is also true because child rows with foreign keys can be deleted automatically.
upvoted 0 times
...
Gracie
2 months ago
I disagree, I believe statement B is true because child rows with foreign keys can stay even if parent row is deleted.
upvoted 0 times
...
Odette
2 months ago
I think statement A is true because a table can have multiple foreign keys.
upvoted 0 times
...
Lacresha
2 months ago
I think A and C are true, but I'm not sure about the rest of the options.
upvoted 0 times
Nobuko
1 months ago
C) Primary key and foreign key constraints can be defined at both the column and table level.
upvoted 0 times
...
Nobuko
2 months ago
A) A table can have only one primary key but multiple foreign keys.
upvoted 0 times
...
...
Elenore
2 months ago
I agree with both of you, statement E is also true because child rows with foreign keys can be deleted automatically.
upvoted 0 times
...
Eric
2 months ago
I disagree, I believe statement B is true because child rows with foreign keys can stay even if parent row is deleted.
upvoted 0 times
...
Colton
3 months ago
I think statement A is true because a table can have multiple foreign keys.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77