Database Profiler MCQ

Test your knowledge with important Database Profiler MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Database Profiler MCQs at Bissoy

• __________ can be used to limit the size of the result document for a query operation.
  ক

  limit()

  খ

  aggregate()

  গ

  skip()

  ঘ

  none of the mentioned
• Which of the following represents number of times the operation acquired the lock in the specified mode?
  ক

  system.profile.locks.acquireCount

  খ

  system.profile.locks.acquireWaitCount

  গ

  system.profile.locks.Count

  ঘ

  none of the mentioned
• How many types of locking modes exist in MongoDB?
  ক

  1

  খ

  2

  গ

  3

  ঘ

  More than 3
• Which of the following keyword represents lock on the collection?
  ক

  Database

  খ

  Collection

  গ

  Metadata

  ঘ

  All of the mentioned
• The ___________ provides information for various lock types and lock modes held during the operation.
  ক

  admin.system.authlocks

  খ

  system.profile.locks

  গ

  admin.system.locks

  ঘ

  all of the mentioned
• Which of the following collection is capped?
  ক

  system.index

  খ

  system.replica

  গ

  system.profile

  ঘ

  all of the mentioned
• Which of the following information is captured by database profiler?
  ক

  Read operations

  খ

  Write operations

  গ

  Cursor Operations

  ঘ

  All of the mentioned