Exercise: Managing Databases With Sql Server 2000

Questions for: Managing Databases With Sql Server 2000

SQL Server 2000 stored procedures can:
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.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
With which type of SQL Server recovery model, is no logging done?
A:
Differential recovery
B:
Full recovery
C:
Bulk-logged recovery
D:
Simple recovery
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is a way to create and modify tables using SQL Server?
A:
Write SQL code using either CREATE or ALTER SQL statements only.
B:
Use the graphical facilities of SQL Server Enterprise Manager only.
C:
Both of the two methods above will work.
D:
Neither of the two methods above will work.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the three possible types of triggers does SQL Server support?
A:
INSTEAD OF only
B:
AFTER only
C:
BEFORE only
D:
INSTEAD OF and AFTER only
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
A:
READ_ONLY
B:
SCROLL_LOCK
C:
OPTIMISTIC
D:
READCOMMITTED
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz