Which two statements are true regarding tables?

Which two statements are true regarding tables? (Choose two.)

Which two statements are true regarding tables? (Choose two.)

A.
A table name can be of any length.

B.
A table can have any number of columns.

C.
A column that has a DEFAULT value cannot store null values.

D.
A table and a view can have the same name in the same schema.

E.
A table and a synonym can have the same name in the same schema.

F.
The same table name can be used in different schemas in the same database.

Explanation:
Synonyms
Synonyms are database objects that enable you to call a table by another name. You can create
synonyms to give an alternative name to a table.



Leave a Reply 8

Your email address will not be published. Required fields are marked *


hwfurlan

hwfurlan

E is wrong:

A synonym may have the same name as the underlying object, provided the underlying object is contained in another schema.

xuzhiyuan

xuzhiyuan

you are right.
===
Synonyms share the same namespace as views and tables and can therefore be
used interchangeably with them.
===

neo3

neo3

In my opinion correct answer is B and F

Sergey

Sergey

B incorrect Per table 1000 columns maximum!
E also wrong They should correct question.
“public synonym” could have same name to the table, private synonym can’t.

kellar

kellar

So is C right answer?

Eamon

Eamon

Nope, C is NOT correct
because a column with a DEFAULT value can in fact store NULL values.

Sagar

Sagar

Only option F is correct from all the given options, rest are incorrect. Question needs modification..