SQL Server 2000 problems
- 1. 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
Correct Answer: Lock level
- 2. 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
Correct Answer: SQL Server only security
- 3. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
Options- A. #
- B. %
- C. &
- D. @ Discuss
Correct Answer: @
- 4. 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
Correct Answer: be kept within the database and invoked by application programs.
- 5. 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
Correct Answer: INSTEAD OF trigger.
- 6. 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:
Options- A. COBOL.
- B. VB.NET.
- C. TRANSACT SQL.
- D. Visual Basic. Discuss
Correct Answer: TRANSACT SQL.
- 7. SQL Server program code that is executed after an SQL command has been processed is called a(n):
Options- A. INSTEAD OF trigger.
- B. BEFORE trigger.
- C. AFTER trigger.
- D. BEGIN trigger. Discuss
Correct Answer: AFTER trigger.
- 8. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. READCOMMITTED Discuss
Correct Answer: READCOMMITTED
- 9. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Options- A. Differential recovery
- B. Full recovery
- C. Simple recovery
- D. Bulk-logged recovery Discuss
Correct Answer: Bulk-logged recovery
- 10. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. PESSIMISTIC Discuss
Correct Answer: OPTIMISTIC
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.