OCP-1Z0-051-Question Analysis-27th question

27. 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.

Answer: EF

A: error. The maximum table name length is 30.

B: error. The maximum number of fields is 1000.

Can be tested

SQL> create table tt (id int); the table has been created. SQL> edit has been written to file afiedt. buf 1 declare 2 v_string varchar2 (100); 3 begin 4 for I in 1 .. 1000 loop 5 v_string: = 'alter table tt add col' | I | 'int'; 6 execute immediate v_string; 7 end loop; 8 * end; SQL>/declare * row 1st error: ORA-01792: the maximum number of columns in a table or view is 1000ORA-06512: In line 6

C: error. The default value can be NULL.
D: In the same schema, the table and view can have duplicate names. The table and view cannot have duplicate names.
E: In the same schema, the table and its synonyms can be duplicated, correct

F: The table names can be the same in different schemas. Correct