Exercise: Managing Databases With Sql Server 2000

Questions for: Managing Databases With Sql Server 2000

SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
A:
INSTEAD OF trigger.
B:
BEFORE trigger.
C:
AFTER trigger.
D:
BEGIN trigger.
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The strictest transaction isolation level provided by SQL Server is called:
A:
REPEATABLE READ.
B:
SERIALIZABLE.
C:
READ COMMITTED.
D:
READ UNCOMMITTED.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What mode of authentication does SQL Server NOT provide?
A:
Windows-only security
B:
Both SQL Server and Windows-only security
C:
Mixed security
D:
SQL Server only security
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
A:
#
B:
%
C:
&
D:
@
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
A:
Differential recovery
B:
Full recovery
C:
Simple recovery
D:
Bulk-logged recovery
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz