Database - SQL Sever 2000
Database - SQL Sever 2000
11. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
- READ_ONLY
- SCROLL_LOCK
- OPTIMISTIC
- PESSIMISTIC
12. 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:
- COBOL.
- VB.NET.
- TRANSACT SQL.
- Visual Basic.
13. With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
- Nonclustered
- Clustered
- Primary
- Secondary
14. 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
- Differential backup
- None of the above is correct.
15. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
- Nonclustered
- Clustered
- Primary
- Secondary
16. With which type of SQL Server recovery model are all database changes logged?
- Differential recovery
- Full recovery
- Simple recovery
- Bulk-logged recovery
17. SQL Server automatically creates an index on:
- primary keys only.
- foreign key only.
- both primary and foreign keys.
- SQL Server never automatically creates an index.
18. Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
- Lock level
- Transaction isolation level
- Cursor concurrency setting
- Locking hints
19. SQL Server program code that is executed after an SQL command has been processed is called a(n):
- INSTEAD OF trigger.
- BEFORE trigger.
- AFTER trigger.
- BEGIN trigger.
20. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
- REPEATABLE READ
- SERIALIZABLE
- READ COMMITTED
- READ UNCOMMITTED