SQL Server 2000 SQL Server 2000 stored procedures can: be stored on the users' computer never be kept within the database be kept within the database and invoked by application programs support BEFORE, INSTEAD OF and AFTER types be stored on the users' computer never be kept within the database be kept within the database and invoked by application programs support BEFORE, INSTEAD OF and AFTER types ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server indexes are special data structures used to improve performance. 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 AFTER trigger BEGIN trigger INSTEAD OF trigger BEFORE trigger AFTER trigger BEGIN trigger INSTEAD OF trigger ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Which type of SQL Server cursor concurrency places an update lock on a row when the row is read? READ_ONLY SCROLL_LOCK OPTIMISTIC READCOMMITTED READ_ONLY SCROLL_LOCK OPTIMISTIC READCOMMITTED ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called: TRANSACT SQL V NET COBOL Visual Basic TRANSACT SQL V NET COBOL Visual Basic ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data. Clustered Secondary Nonclustered Primary Clustered Secondary Nonclustered Primary ANSWER DOWNLOAD EXAMIANS APP