CSE :: Database System 2 - CS
- With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
- 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:
- With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
- 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?
- With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
- With which type of SQL Server recovery model are all database changes logged?
- SQL Server automatically creates an index on:
- Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
- SQL Server program code that is executed after an SQL command has been processed is called a(n):
- Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Whatsapp
Facebook
