SQL Server 2000 problems
- 1. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Options- A. REPEATABLE READ
- B. SERIALIZABLE
- C. READ COMMITTED
- D. READ UNCOMMITTED Discuss
Correct Answer: REPEATABLE READ
- 2. 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?
Options- A. Complete backup
- B. Transaction Log
- C. Differential backup
- D. None of the above is correct. Discuss
Correct Answer: Differential backup
- 3. Which of the following is a way to create and modify tables using SQL Server?
Options- A. Write SQL code using either CREATE or ALTER SQL statements only.
- B. Use the graphical facilities of SQL Server Enterprise Manager only.
- C. Both of the two methods above will work.
- D. Neither of the two methods above will work. Discuss
Correct Answer: Both of the two methods above will work.
- 4. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Options- A. Nonclustered
- B. Clustered
- C. Primary
- D. Secondary Discuss
Correct Answer: Nonclustered
- 5. With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Options- A. Nonclustered
- B. Clustered
- C. Primary
- D. Secondary Discuss
Correct Answer: Clustered
- 6. With which type of SQL Server recovery model are all database changes logged?
Options- A. Differential recovery
- B. Full recovery
- C. Simple recovery
- D. Bulk-logged recovery Discuss
Correct Answer: Full recovery
- 7. The strictest transaction isolation level provided by SQL Server is called:
Options- A. REPEATABLE READ.
- B. SERIALIZABLE.
- C. READ COMMITTED.
- D. READ UNCOMMITTED. Discuss
Correct Answer: SERIALIZABLE.
- 8. Which of the three possible types of triggers does SQL Server support?
Options- A. INSTEAD OF only
- B. AFTER only
- C. BEFORE only
- D. INSTEAD OF and AFTER only Discuss
Correct Answer: INSTEAD OF and AFTER only
- 9. With which type of SQL Server recovery model, is no logging done?
Options- A. Differential recovery
- B. Full recovery
- C. Bulk-logged recovery
- D. Simple recovery Discuss
Correct Answer: Simple recovery
- 10. SQL Server automatically creates an index on:
Options- A. primary keys only.
- B. foreign key only.
- C. both primary and foreign keys.
- D. SQL Server never automatically creates an index. Discuss
Correct Answer: both primary and foreign keys.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.