
Answer-first summary for fast verification
Answer: STATEMENT_TIMEOUT_IN_SECONDS, STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
The question asks for object-level parameters that limit query processing and concurrency slowdowns. STATEMENT_TIMEOUT_IN_SECONDS (C) directly limits query processing by aborting long-running queries that monopolize resources. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS (D) addresses concurrency slowdowns by canceling queries that wait too long in the queue, preventing resource blocking. The community discussion confirms CD as the correct answer with 100% consensus, noting these parameters prevent resource monopolization and deadlocks. Other options are less suitable: MULTI_STATEMENT_COUNT (A) controls multi-statement transactions but doesn't directly limit slowdowns; ENABLE_QUERY_ACCELERATION (B) and QUERY_ACCELERATION_MAX_SCALE_FACTOR (E) optimize performance but do not inherently limit processing or concurrency issues.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which object-level parameters can be used to limit query processing and concurrency slowdowns? (Choose two.)
A
MULTI_STATEMENT_COUNT
B
ENABLE_QUERY_ACCELERATION
C
STATEMENT_TIMEOUT_IN_SECONDS
D
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
E
QUERY_ACCELERATION_MAX_SCALE_FACTOR