Which two statements are true about the creation of the SALES1 table?

Examine the structure of the sales table:

Evaluate the following create table statement:

Which two statements are true about the creation of the SALES1 table?

Examine the structure of the sales table:

Evaluate the following create table statement:

Which two statements are true about the creation of the SALES1 table?

A.
The SALES1 table is created with no rows but only a structure.

B.
The SALES1 table would have primary key and unique constraints on the specified
columns.

C.
The SALES1 table would not be created because of the invalid where clause.

D.
The SALES1 table would have not null and unique constraints on the specified columns.

E.
The SALES1 table would not be created because column-specified names in the select
and create table clauses do not match,



Leave a Reply 3

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


Oguns

Oguns

Question is “Which two statements”, solution is one.

Livia

Livia

The only constraint that it is copied is the Not Null. There is only one correct answer: A.

Surersh

Surersh

Agree with Livia