Query Plan Reuse MCQ

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

• _________ uniquely identifies a query plan for a batch that has executed and whose plan resides in the plan cache.
  ক

  pool_name

  খ

  plan_handle

  গ

  sql_handle

  ঘ

  none of the mentioned
• What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL? b) DBCC FREEPROCCACHE c) DBCC FREEPROCCACHE d) None of the mentioned
  ক

  DBCC FREEPROCCACHE

  খ

  ( { plan_handle | sql_handle | pool_name } )

  গ

  ( { plan_handle | sql_handle | pool_name } )

  ঘ

  ( { plan_handle | sql_handle | pool_name } )
• The conditions that invalidate a plan include which of the following?
  ক

  An explicit call to sp_compile

  খ

  Executing a stored procedure using the WITH COMPILE option

  গ

  Changes made to a table or view referenced by the query

  ঘ

  All of the mentioned
• The maximum size for all caches is a function of the ________ size.
  ক

  RAM

  খ

  Buffer pool

  গ

  Hard disk

  ঘ

  None of the mentioned
• Which of the following SQL Server SQL Statistics counter represents number of auto-parameterization attempts per second?
  ক

  Batch Requests/sec

  খ

  Failed Auto-Params/sec

  গ

  Forced parameterizations/sec

  ঘ

  Auto-Param Attempts/sec
• Use to bind an integer variable to the first parameter marker in an SQL statement.
  ক

  SQLParameter

  খ

  SQLBind

  গ

  SQLBindParameter

  ঘ

  All of the mentioned
• The use of parameters, including parameter markers in _______ applications, can increase the reuse of execution plans.
  ক

  OLE DB

  খ

  ADO

  গ

  ODBC

  ঘ

  All of the mentioned