PrepAway - Latest Free Exam Questions & Answers

Which statement about INSERT operations is true?

Which statement about INSERT operations is true?

PrepAway - Latest Free Exam Questions & Answers

A.
The INSERT statement is used to insert rows into a table, view, or table function.

B.
Inserted values must satisfy the conditions of any check constraints defined on the table.

C.
If an INSERT statement omits any column from the inserted row that is defined as NULL
or NOT NULL WITH DEFAULT, the statement will fail.

D.
If the underlying table of a view being referenced by an INSERT statement has one or
more unique indexes, each row inserted does not have to conform to the constraints
imposed by those indexes.


Leave a Reply