SQL Quiz #8 - Inserting Data

Question 1 of 10

Which of the following are commands used in SQL Server to insert data?

INSERT VALUES
INSERT SELECT
INSERT EXEC
SELECT INTO

Question 2 of 10

Which of the following are ways for a column to get its value automatically in an INSERT statement?

Set an IDENTITY property on the column
Associate a DEFAULT constraint with the column
Allow NULL values in the column
All of the above

Question 3 of 10

What command should be executed before the INSERT statement if you want to insert an explicit value into an IDENTITY column?

SET IDENTITY_INSERT <table> OFF;
SET IDENTITY_INSERT <table> ON;
DBCC TRACEON (3205, -1);
DBCC TRACEON (3205, 260, -1);

Question 4 of 10

What is the correct order of the checks performed by SQL Server when a value for a column is not provided in an INSERT statement?

Check whether the column gets its value automatically (from an IDENTITY column or a default constraint)
Check if the column allows NULL values
If none of the above, generate an error

Question 5 of 10

Which of the following can be used to insert the values returned by a stored procedure?

INSERT VALUES
INSERT SELECT
INSERT EXEC
SELECT INTO

Question 6 of 10

INSERT EXEC works even when the source dynamic batch or stored procedure has more than one query, as long as all queries result sets are compatible with the target table definition.

TRUE
FALSE

Question 7 of 10

SELECT INTO commands are minimally logged, no matter what recovery model is set on the database.

TRUE
FALSE

Question 8 of 10

Which of the following statements creates the target table based on the definition of the source?

INSERT VALUES
INSERT SELECT
INSERT EXEC
SELECT INTO

Question 9 of 10

In which case out of the following are you normally not allowed to specify the target column in an INSERT statement?

If the column has a default constraint associated with it
If the column allows NULLs
If the column has an IDENTITY property
All of the above

Question 10 of 10

Which of the following are not copied from the source table when a SELECT INTO command is executed?

Indexes
Constraints
The IDENTITY property
Triggers

SQL Quiz #8 – Inserting Data

Quiz-summary

Information

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question