EXAMIANS
There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.
YOUR ANSWER : ?
YOUR ANSWER : ?
Better security occurs if Windows-only authentication is selected.
YOUR ANSWER : ?
READ COMMITTED is the default isolation level.
YOUR ANSWER : ?
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
YOUR ANSWER : ?
SQL Server supports two kinds of indexes: clustered and nonclustered.
YOUR ANSWER : ?
SQL Server supports three recovery modes: simple, full and Bulk.
YOUR ANSWER : ?
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
YOUR ANSWER : ?
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
YOUR ANSWER : ?
Nonclustered indexes are faster than clustered indexes for retrieval.
YOUR ANSWER : ?
'dbo' stands for database object.
YOUR ANSWER : ?