SQL Server 2000 In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup? Complete backup Transaction Log None of these Differential backup Complete backup Transaction Log None of these Differential backup ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 READ COMMITTED is the default isolation level. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Which of the three possible types of triggers does SQL Server support? AFTER only INSTEAD OF and AFTER only BEFORE only INSTEAD OF only AFTER only INSTEAD OF and AFTER only BEFORE only INSTEAD OF only ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data. OPTIMISTIC SCROLL_LOCK READ_ONLY PESSIMISTIC OPTIMISTIC SCROLL_LOCK READ_ONLY PESSIMISTIC ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS