Optimization Strategies MCQ

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

• If the query planner selects a _________ the explain result includes an IXSCAN stage.
  ক

  Index

  খ

  Replica Set

  গ

  Document

  ঘ

  None of the mentioned
• In _____________ mode, MongoDB returns statistics describing the execution of the winning plan as well as statistics for the other candidate plans captured during plan selection.
  ক

  somePlansExecution

  খ

  allPlansExecution

  গ

  rejPlansExecution

  ঘ

  none of the mentioned
• Which of the following parameter specifies the verbosity mode for the explain output?
  ক

  verbosity

  খ

  verbose

  গ

  queryPlanner

  ঘ

  none of the mentioned
• If the query planner selects a collection scan, the explain result includes a _________ stage.
  ক

  COLLSCAN

  খ

  TABLESCAN

  গ

  ROWSCAN

  ঘ

  All of the mentioned
• For sharded collections, explain returns the __________ for each accessed shard.
  ক

  clientInfo

  খ

  serverInfo

  গ

  serverplan

  ঘ

  all of the mentioned
• _________ corresponds to the millis field returned by cursor.explain() in earlier versions of MongoDB.
  ক

  executionMillis

  খ

  executionTimeMillis

  গ

  timemillis

  ঘ

  all of the mentioned
• Which of the following provides information on the MongoDB instance?
  ক

  serverInfo

  খ

  queryPlanner

  গ

  executeStats

  ঘ

  none of the mentioned
• ____________ does not provide query execution information for the rejected plans.
  ক

  serverstats

  খ

  queryPlanner

  গ

  executionStats

  ঘ

  all of the mentioned
• By default, db.collection.explain() runs in ___________ verbosity mode.
  ক

  VerbosityMode

  খ

  queryPlanner

  গ

  executeStats

  ঘ

  none of the mentioned
• ____________ returns information on the query plan for aggregate function.
  ক

  Reporter

  খ

  db.collection.explain()

  গ

  db.collection.explainplan()

  ঘ

  None of the mentioned
• Which of the operator is used to access the query field of documents within system.profile?
  ক

  $select

  খ

  $retrieve

  গ

  $query

  ঘ

  None of the mentioned
• MongoDB reports its triggered page faults as the total number of page faults in ________ second.
  ক

  1

  খ

  100

  গ

  1000

  ঘ

  None of the mentioned
• You can inspect __________ to check the amount of mapped memory that mongod is using.
  ক

  mem.mapped

  খ

  memory.resident

  গ

  mem.resident

  ঘ

  all of the mentioned
• The memory usage statuses metrics of the _________ output can provide insight into MongoDB’s memory use.
  ক

  globalstats

  খ

  serverStatus

  গ

  locks.deadlockCount

  ঘ

  all of the mentioned
• With the _______ storage engine, MongoDB uses memory-mapped files to store data.
  ক

  MMAPv2

  খ

  MMAPv1

  গ

  WiredTiger

  ঘ

  All of the mentioned
• MongoDB’s _______ is a database profiling system that can help identify inefficient queries and operations.
  ক

  Reporter

  খ

  Executer

  গ

  Profiler

  ঘ

  None of the mentioned
• ______ field contains total number of current clients that connect to the database instance.
  ক

  available

  খ

  current

  গ

  always avail

  ঘ

  none of the mentioned
• serverStatus includes all fields by default, except _________
  ক

  rangeDeleter

  খ

  rangeDelete

  গ

  rangeDEL

  ঘ

  none of the mentioned
• The __________ data structure value provides more granular information concerning the number of operations queued because of a lock.
  ক

  currentQueue

  খ

  curQueue

  গ

  currentQu

  ঘ

  none of the mentioned
• If __________ is high relative to uptime, the database has existed in a lock state for a significant amount of time.
  ক

  globalLock.halfTime

  খ

  globalLock.totalTime

  গ

  globalLock.downTime

  ঘ

  all of the mentioned
• ________ provide the number of times the lock acquisitions encountered deadlocks.
  ক

  locks.deadlock

  খ

  lock.deadlockCount

  গ

  locks.deadlockCount

  ঘ

  all of the mentioned
• Which of the following setting defines what constitutes a “slow” operation?
  ক

  slowOpThresholdGs

  খ

  fastOpThresholdMs

  গ

  slowOpThresholdMs

  ঘ

  none of the mentioned