SQL Server 2000 SQL Server automatically creates an index on all primary and foreign keys. True False True False 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 COBOL Visual Basic NET TRANSACT SQL V COBOL Visual Basic NET ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With SQL Server, parameters and variables in T-SQL start with the "%" sign. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The strictest transaction isolation level provided by SQL Server is called: READ UNCOMMITTED REPEATABLE READ SERIALIZABLE READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE READ COMMITTED ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server 2000 stored procedures can: never be kept within the database be stored on the users' computer support BEFORE, INSTEAD OF and AFTER types be kept within the database and invoked by application programs never be kept within the database be stored on the users' computer support BEFORE, INSTEAD OF and AFTER types be kept within the database and invoked by application programs 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 READCOMMITTED SCROLL_LOCK OPTIMISTIC READ_ONLY READCOMMITTED SCROLL_LOCK OPTIMISTIC ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS