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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
the correct answer for me is B and F
try creating a public synonym
A F is correct.
table, view and synonym can’t have the same name because they are in the same namespace:
– Tables, views, private synonyms, sequences, PL/SQL procedures, PL/SQL functions, PL/SQL packages, materialized views Constraints
A is incorrect because the maximum length for table name is 30
Option D is incorrect if you try to execute it you will get error:
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 – “name is already used by an existing object”
I tried creating synonym with the same name as a table and I got an error.
Error starting at line : 47 in command –
CREATE SYNONYM names FOR test.names
Error report –
SQL Error: ORA-01471: cannot create a synonym with same name as object
01471. 00000 – “cannot create a synonym with same name as object”
E is wrong
try creating a public synonym
E, F is correct.
E is wrong!
is this correct?