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