logo

CuriousTab

CuriousTab

SQL Server 2000 problems


  • 1. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

  • Options
  • A. REPEATABLE READ
  • B. SERIALIZABLE
  • C. READ COMMITTED
  • D. READ UNCOMMITTED
  • Discuss
  • 2. In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?

  • Options
  • A. Complete backup
  • B. Transaction Log
  • C. Differential backup
  • D. None of the above is correct.
  • Discuss
  • 3. Which of the following is a way to create and modify tables using SQL Server?

  • Options
  • 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.
  • Discuss
  • 4. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.

  • Options
  • A. Nonclustered
  • B. Clustered
  • C. Primary
  • D. Secondary
  • Discuss
  • 5. With this type of index, the data are stored in the bottom level of the index and in the same order as that index.

  • Options
  • A. Nonclustered
  • B. Clustered
  • C. Primary
  • D. Secondary
  • Discuss
  • 6. With which type of SQL Server recovery model are all database changes logged?

  • Options
  • A. Differential recovery
  • B. Full recovery
  • C. Simple recovery
  • D. Bulk-logged recovery
  • Discuss
  • 7. The strictest transaction isolation level provided by SQL Server is called:

  • Options
  • A. REPEATABLE READ.
  • B. SERIALIZABLE.
  • C. READ COMMITTED.
  • D. READ UNCOMMITTED.
  • Discuss
  • 8. Which of the three possible types of triggers does SQL Server support?

  • Options
  • A. INSTEAD OF only
  • B. AFTER only
  • C. BEFORE only
  • D. INSTEAD OF and AFTER only
  • Discuss
  • 9. With which type of SQL Server recovery model, is no logging done?

  • Options
  • A. Differential recovery
  • B. Full recovery
  • C. Bulk-logged recovery
  • D. Simple recovery
  • Discuss
  • 10. SQL Server automatically creates an index on:

  • Options
  • A. primary keys only.
  • B. foreign key only.
  • C. both primary and foreign keys.
  • D. SQL Server never automatically creates an index.
  • Discuss

First 2 3