Which statement is true regarding the above command?

View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES
tables.
The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the
CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
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?

View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.

The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.

Evaluate the following CREATE TABLE command:

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?

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 the new table.

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

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



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Khatai

Khatai

how i can find the sample tables for this test?

youyou

youyou

scott.emp using empno, ename, hiredate

nadia

nadia

WHAT ARE THE ANSWERS?

Steve

Steve

only not null and check constraints are moved to the new table