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

Venita

1 months ago

I'd love to see a column definition that can specify multiple data types. That would be like a Swiss Army knife for data storage!

upvoted 0 times

Shantay

1 days ago

That would be really cool to have a column definition with multiple data types!

upvoted 0 times

...

Hannah

3 days ago

User 1: I think B) A table can have multiple foreign keys is true.

upvoted 0 times

...

Buck

2 months ago

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

upvoted 0 times

Carrol

1 months ago

User1

upvoted 0 times

...

Douglass

1 months ago

User2

upvoted 0 times

...

Harrison

2 months 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

Sanjuana

26 days ago

Magdalene: Yeah, I need to review my database concepts as well.

upvoted 0 times

...

Lindsey

27 days ago

User 3: Thanks for clarifying, I need to study more.

upvoted 0 times

...

Magdalene

2 months ago

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

upvoted 0 times

...

Emiko

2 months ago

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

upvoted 0 times

...

Helga

2 months 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

3 months ago

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

upvoted 0 times

...

Flo

3 months 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

3 months ago

I think B and D are true.

upvoted 0 times

...