Question 1 of 25
Hints left: 3
Q1
Nonclustered indexes are faster than clustered indexes for retrieval.
Q2
Which of the following statements is not true about XML Schemas:
Q3
SERIALIZABLE is the strictest isolation level.
Q4
By default, SQL Server will create one data file and one log file for each newly created database.
Q5
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
Q6
SQL Server supports two kinds of indexes: clustered and nonclustered.
Q7
SQL Server indexes are special data structures used to improve performance.
Q8
'dbo' stands for database object.
Q10
A differential backup makes a copy of the entire database.
Q11
The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.
Q12
What is not true about SOAP?
Q13
The most popular way to materialize XML documents is to use:
Q14
To eliminate definition duplication, XML Schemas define:
Q15
Better security occurs if Windows-only authentication is selected.
Q16
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.
Q17
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
Q18
READ COMMITTED is the default isolation level.
Q19
The XSLT processor copies the elements of the stylesheet until it finds a command in the format:
Q20
SQL Server AFTER Triggers may be assigned views.
Q21
SQL Server supports three recovery modes: simple, full and Bulk.
Q22
XML Schemas consist of:
Q23
SQL Server supports a language called Transact-SQL (also called T-SQL).
Q24
What standard, protocol or language was generalized to become a standard protocol for sending messages of any type, using any protocol?
Q25
The expression FOR XML RAW tells SQL Server to: