EXAMIANS
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
YOUR ANSWER : ?
YOUR ANSWER : ?
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?
YOUR ANSWER : ?
There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.
YOUR ANSWER : ?
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
YOUR ANSWER : ?
Which of the three possible types of triggers does SQL Server support?
YOUR ANSWER : ?
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
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.
YOUR ANSWER : ?
SQL Server supports a language called Transact-SQL (also called T-SQL).
YOUR ANSWER : ?
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
YOUR ANSWER : ?
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
YOUR ANSWER : ?