SQL FOR DATABASE CONSTRUCTION QUIZ

SQL Server supports three recovery modes: simple, full and Bulk.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the three possible types of triggers does SQL Server support?

INSTEAD OF and AFTER only

BEFORE only

AFTER only

INSTEAD OF only

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server automatically creates an index on all primary and foreign keys.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

With this type of index, the data are stored in the bottom level of the index and in the same order as that index.

Clustered

Nonclustered

Primary

Secondary

TRUE ANSWER : ?
YOUR ANSWER : ?

A differential backup makes a copy of the entire database.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is a way to create and modify tables using SQL Server?

Write SQL code using either CREATE or ALTER SQL statements only

Use the graphical facilities of SQL Server Enterprise Manager only

Neither of the two methods above will work

Both of the two methods above will work

TRUE ANSWER : ?
YOUR ANSWER : ?

An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

READ COMMITTED is the default isolation level.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

With SQL Server pessimistic locking, no lock is obtained until the user updates the data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

Cursor concurrency setting

Lock level

Locking hints

Transaction isolation level

TRUE ANSWER : ?
YOUR ANSWER : ?

↑