Exercise: Managing Databases With Sql Server 2000

Questions for: Managing Databases With Sql Server 2000

Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
A:
REPEATABLE READ
B:
SERIALIZABLE
C:
READ COMMITTED
D:
READ UNCOMMITTED
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
SQL Server program code that is executed after an SQL command has been processed is called a(n):
A:
INSTEAD OF trigger.
B:
BEFORE trigger.
C:
AFTER trigger.
D:
BEGIN trigger.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
A:
Lock level
B:
Transaction isolation level
C:
Cursor concurrency setting
D:
Locking hints
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
SQL Server automatically creates an index on:
A:
primary keys only.
B:
foreign key only.
C:
both primary and foreign keys.
D:
SQL Server never automatically creates an index.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
With which type of SQL Server recovery model are all database changes logged?
A:
Differential recovery
B:
Full recovery
C:
Simple recovery
D:
Bulk-logged recovery
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz