EXAMIANS
Nonclustered indexes are faster than clustered indexes for retrieval.
YOUR ANSWER : ?
YOUR ANSWER : ?
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
YOUR ANSWER : ?
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 : ?
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
YOUR ANSWER : ?
SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
YOUR ANSWER : ?
An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
YOUR ANSWER : ?
'dbo' stands for database object.
YOUR ANSWER : ?
SQL Server supports a language called Transact-SQL (also called T-SQL).
YOUR ANSWER : ?
With SQL Server, parameters and variables in T-SQL start with the "%" sign.
YOUR ANSWER : ?
In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
YOUR ANSWER : ?