SQL Server supports two kinds of indexes: clustered and nonclustered. True False TRUE ANSWER : ? YOUR ANSWER : ?
What mode of authentication does SQL Server NOT provide? Both SQL Server and Windows-only security SQL Server only security Mixed security Windows-only security TRUE ANSWER : ? YOUR ANSWER : ?
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data. READ_ONLY PESSIMISTIC OPTIMISTIC SCROLL_LOCK TRUE ANSWER : ? YOUR ANSWER : ?
SQL Server supports a language called Transact-SQL (also called T-SQL). True False TRUE ANSWER : ? YOUR ANSWER : ?
With which type of SQL Server recovery model, is no logging done? Simple recovery Differential recovery Bulk-logged recovery Full recovery TRUE ANSWER : ? YOUR ANSWER : ?
With this type of index, the data are stored in the bottom level of the index and in the same order as that index. Secondary Clustered Nonclustered Primary TRUE ANSWER : ? YOUR ANSWER : ?
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures? % # & @ TRUE ANSWER : ? YOUR ANSWER : ?
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words. False True TRUE ANSWER : ? YOUR ANSWER : ?
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers. True False TRUE ANSWER : ? YOUR ANSWER : ?
SQL Server program code that is executed after an SQL command has been processed is called a(n): INSTEAD OF trigger AFTER trigger BEGIN trigger BEFORE trigger TRUE ANSWER : ? YOUR ANSWER : ?