SQL Server 2000 Which type of SQL Server cursor concurrency places an update lock on a row when the row is read? READCOMMITTED OPTIMISTIC READ_ONLY SCROLL_LOCK READCOMMITTED OPTIMISTIC READ_ONLY SCROLL_LOCK ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures? % & @ # % & @ # ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server program code that is executed after an SQL command has been processed is called a(n): AFTER trigger BEFORE trigger BEGIN trigger INSTEAD OF trigger AFTER trigger BEFORE trigger BEGIN trigger INSTEAD OF trigger ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server supports two kinds of indexes: clustered and nonclustered. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n): BEFORE trigger INSTEAD OF trigger AFTER trigger BEGIN trigger BEFORE trigger INSTEAD OF trigger AFTER trigger BEGIN trigger ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server AFTER Triggers may be assigned views. False True False True ANSWER DOWNLOAD EXAMIANS APP