SQL Server 2000 MCQ

Test your knowledge with important SQL Server 2000 MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more SQL Server 2000 MCQs on Bissoy. Bissoy App

• With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
  ক

  True

  খ

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

  REPEATABLE READ

  খ

  SERIALIZABLE

  গ

  READ COMMITTED

  ঘ

  READ UNCOMMITTED
• Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
  ক

  Lock level

  খ

  Transaction isolation level

  গ

  Cursor concurrency setting

  ঘ

  Locking hints
• With which type of SQL Server recovery model are all database changes logged?
  ক

  Differential recovery

  খ

  Full recovery

  গ

  Simple recovery

  ঘ

  Bulk-logged recovery
• With which type of SQL Server recovery model, is no logging done?
  ক

  Differential recovery

  খ

  Full recovery

  গ

  Bulk-logged recovery

  ঘ

  Simple recovery
• 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
• Which of the three possible types of triggers does SQL Server support?
  ক

  INSTEAD OF only

  খ

  AFTER only

  গ

  BEFORE only

  ঘ

  INSTEAD OF and AFTER only
• 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
• 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
• 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