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.
E is wrong:
A synonym may have the same name as the underlying object, provided the underlying object is contained in another schema.
you are right.
===
Synonyms share the same namespace as views and tables and can therefore be
used interchangeably with them.
===
In my opinion correct answer is B and F
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.
The E and F are the answer.
You can have a public and private synonym called DEPT and have a table called DEPT in the same schema.
http://www.dba-oracle.com/concepts/synonyms.htm
So is C right answer?
Nope, C is NOT correct
because a column with a DEFAULT value can in fact store NULL values.
Only option F is correct from all the given options, rest are incorrect. Question needs modification..