Oracle Exam 1Z0-071 Topic 11 Question 88 Discussion

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

Question #: 88
Topic #: 11

[All 1Z0-071 Questions]

Which two statements are true about an Oracle database?

AA table can have multiple primary keys.

BA table can have multiple foreign keys.

CA NUMBER column without data has a zero value.

DA column definition can specify multiple data types.

EA VARCHAR2 column without data has a NULL value.

Show Suggested Answer

Suggested Answer: C, D

by Lonny at Mar 17, 2024, 08:35 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Buck

13 days ago

Haha, a table with multiple primary keys? What is this, a database for superheroes?

upvoted 0 times

...

Harrison

19 days ago

Oh man, I was sure that A and D were the right answers. Guess I need to review my database concepts again.

upvoted 0 times

Magdalene

12 hours ago

User 2: Actually, the correct answers are B and E.

upvoted 0 times

...

Emiko

3 days ago

User 1: I thought A and D were correct too.

upvoted 0 times

...

Helga

21 days ago

I think B and E are the correct statements. A table can have multiple foreign keys, and a VARCHAR2 column without data has a NULL value.

upvoted 0 times

...

Dahlia

24 days ago

I'm not sure about E. Can a VARCHAR2 column really have a NULL value?

upvoted 0 times

...

Flo

24 days ago

I agree with you, Flo. A table can have multiple foreign keys and a column definition can specify multiple data types.

upvoted 0 times

...

Tandra

30 days ago

I think B and D are true.

upvoted 0 times

...