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.

Explanation:


Leave a Reply