Oracle.1Z0-051.175q(2)

OCP 11g 051题库

A. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

B. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to

C. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clau

D. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passe

Answer: B

QUESTION 2

View the Exhibit to examine the description for the SALES table.

Which views can have all DML operations performed on it? (Choose all that apply.)