Database - SQL Sever 2000
Database - SQL Sever 2000
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
2. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
- #
- %
- &
- @
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
4. The strictest transaction isolation level provided by SQL Server is called:
- REPEATABLE READ.
- SERIALIZABLE.
- READ COMMITTED.
- READ UNCOMMITTED.
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.
6. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
- READ_ONLY
- SCROLL_LOCK
- OPTIMISTIC
- READCOMMITTED
7. Which of the three possible types of triggers does SQL Server support?
- INSTEAD OF only
- AFTER only
- BEFORE only
- INSTEAD OF and AFTER only
8. Which of the following is a way to create and modify tables using SQL Server?
- Write SQL code using either CREATE or ALTER SQL statements only.
- Use the graphical facilities of SQL Server Enterprise Manager only.
- Both of the two methods above will work.
- Neither of the two methods above will work.
9. With which type of SQL Server recovery model, is no logging done?
- Differential recovery
- Full recovery
- Bulk-logged recovery
- Simple recovery
10. SQL Server 2000 stored procedures can:
- never be kept within the database.
- be kept within the database and invoked by application programs.
- be stored on the users' computer.
- support BEFORE, INSTEAD OF and AFTER types.