IndiaBIX

Database - SQL Server 2000

Exercise : SQL Server 2000 - General Questions
16.
With which type of SQL Server recovery model are all database changes logged?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery
Answer: Option
Explanation:
No answer description is available. Let's discuss.
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.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
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
Answer: Option
Explanation:
No answer description is available. Let's discuss.
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.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
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
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers