Discussion
Home ‣ Database ‣ SQL Server 2000 Comments
- Question
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.
- Correct Answer
- both primary and foreign keys.
- 1. 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
- 2. 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
- 3. The strictest transaction isolation level provided by SQL Server is called:
Options- A. REPEATABLE READ.
- B. SERIALIZABLE.
- C. READ COMMITTED.
- D. READ UNCOMMITTED. Discuss
- 4. 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
- 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
- 6. Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Options- A. Lock level
- B. Transaction isolation level
- C. Cursor concurrency setting
- D. Locking hints Discuss
- 7. What mode of authentication does SQL Server NOT provide?
Options- A. Windows-only security
- B. Both SQL Server and Windows-only security
- C. Mixed security
- D. SQL Server only security Discuss
- 8. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
Options- A. #
- B. %
- C. &
- D. @ Discuss
- 9. SQL Server 2000 stored procedures can:
Options- A. never be kept within the database.
- B. be kept within the database and invoked by application programs.
- C. be stored on the users' computer.
- D. support BEFORE, INSTEAD OF and AFTER types. Discuss
- 10. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Options- A. INSTEAD OF trigger.
- B. BEFORE trigger.
- C. AFTER trigger.
- D. BEGIN trigger. Discuss
SQL Server 2000 problems
Search Results
Correct Answer: Simple recovery
Correct Answer: INSTEAD OF and AFTER only
Correct Answer: SERIALIZABLE.
Correct Answer: Full recovery
Correct Answer: Clustered
Correct Answer: Lock level
Correct Answer: SQL Server only security
Correct Answer: @
Correct Answer: be kept within the database and invoked by application programs.
Correct Answer: INSTEAD OF trigger.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.