Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 41

Total: 50

CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE) 
 AS 
 SELECT prod_id, cust_id, time_id 
 FROM sales:

Which statement is true regarding the above command?

The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.

Go to Question:

Prev Question

Next Question