Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
Answer: D
No answer description available for this question.
Enter details here
By default, SQL Server will create one data file and one log file for each newly created database.
Answer: A
No answer description available for this question.
Enter details here
SQL Server supports a language called Transact-SQL (also called T-SQL).
Answer: A
No answer description available for this question.
Enter details here
SQL Server AFTER Triggers may be assigned views.
Answer: B
No answer description available for this question.
Enter details here
READ COMMITTED is the default isolation level.
Answer: A
No answer description available for this question.
Enter details here
Nonclustered indexes are faster than clustered indexes for retrieval.
Answer: B
No answer description available for this question.
Enter details here
SQL Server automatically creates an index on all primary and foreign keys.
Answer: A
No answer description available for this question.
Enter details here
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Answer: A
No answer description available for this question.
Enter details here
'dbo' stands for database object.
Answer: B
No answer description available for this question.
Enter details here
SQL Server supports two kinds of indexes: clustered and nonclustered.
Answer: A
No answer description available for this question.
Enter details here