IndiaBIX

Database - SQL Server 2000

Exercise : SQL Server 2000 - General Questions
1.
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery
Answer: Option
Explanation:
No answer description is available. Let's discuss.
2.
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
#
%
&
@
Answer: Option
Explanation:
No answer description is available. Let's discuss.
3.
What mode of authentication does SQL Server NOT provide?
Windows-only security
Both SQL Server and Windows-only security
Mixed security
SQL Server only security
Answer: Option
Explanation:
No answer description is available. Let's discuss.
4.
The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ.
SERIALIZABLE.
READ COMMITTED.
READ UNCOMMITTED.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
5.
SQL Server program code that is executed instead of an SQL command that needs to be 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.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers