Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

____________LETS_YOU_AFFINITIZE_A_RESOURCE_POOL_TO_ONE_OR_MORE_SCHEDULERS_OR_NUMA_NODES_FOR_GREATER_ISOLATION_OF_CPU_RESOURCES.?$

A. MAX_IOPS_PER_VOLUME
B. AFFINITY
C. MAX_CPU_PERCENT
D. MAX_MEMORY_PERCENT
Answer» C. MAX_CPU_PERCENT
Discussion
2.

Which_of_the_following_formula_is_used_for_calculating_the_effective_MAX%_?$

A. 100 – sum(MIN %)
B. min(X,Y)
C. max(X,Y)
D. Effective MAX % – MIN %
Answer» C. max(X,Y)
Discussion
3.

____________ is a hard cap limit on the CPU bandwidth for all requests in the resource pool?

A. MIN_CPU_PERCENT
B. CAP_CPU_PERCENT
C. MAX_CPU_PERCENT
D. MAX_MEMORY_PERCENT
Answer» C. MAX_CPU_PERCENT
Discussion
4.

Which of the following query disables the resource governor ?

A. ALTER RESOURCE GOVERNOR ENABLE CONFIGURE;
B. ALTER GOVERNOR DISABLE;
C. ALTER RESOURCE GOVERNOR DISABLE;
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
5.

Which of the following query enables the Resource Governor ?

A. ALTER RESOURCE GOVERNOR CONFIGURE;
B. ALTER RESOURCE RECONFIGURE;
C. ALTER RESOURCE GOVERNOR RECONFIGURE;
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
6.

Enabling the Resource Governor requires _________ permission.

A. CONTROL SERVER
B. CONTROL
C. SERVER
D. SELECT
Answer» B. CONTROL
Discussion
7.

You cannot use the ____________ statement to enable Resource Governor when in a user transaction.

A. ALTER RESOURCE GOVERNOR
B. ALTER GOVERNOR
C. ALTER RESOURCE
D. All of the mentioned
Answer» B. ALTER GOVERNOR
Discussion
8.

Resource Governor is a feature that enables you to specify limits on the amount of :

A. CPU
B. Physical IO
C. Memory
D. None of the mentioned
Answer» E.
Discussion