PrepAway - Latest Free Exam Questions & Answers

Which two of the following will NOT occur when the statement is executed?

Given the following CREATE TABLE statement:
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?

PrepAway - Latest Free Exam Questions & Answers

A.
TABLE2 will have the same column names and column data types as TABLE1

B.
TABLE2 will have the same column defaults as TABLE1

C.
TABLE2 will have the samenullability characteristics as TABLE1

D.
TABLE2 will have the same indexes as TABLE1.

E.
TABLE2 will have the same referential constraints as TABLE1

One Comment on “Which two of the following will NOT occur when the statement is executed?


Leave a Reply