C192 / Query Processing

Description

College C192 Databases Quiz on C192 / Query Processing, created by Craig Willey on 30/06/2020.
Craig Willey
Quiz by Craig Willey, updated more than 1 year ago
Craig Willey
Created by Craig Willey over 4 years ago
5
0

Resource summary

Question 1

Question
The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.
Answer
  • buffer cache
  • procedure cache
  • SQL cache
  • permanent storage

Question 2

Question
If there is no index, the DBMS will perform ____.
Answer
  • a loop scan
  • a range scan
  • a row ID table access scan
  • a full table scan

Question 3

Question
One measure that determines the need for an index is the ____ of the column you want to index. ____ refers to the number of different values a column could possibly have.
Answer
  • database Statistics
  • data sparsity
  • primary key
  • query optimization

Question 4

Question
____ is the central activity during the parsing phase in query processing.
Answer
  • database Statistics
  • data sparsity
  • SQL query
  • query optimization

Question 5

Question
For Optimizer Hints, ____ instructs the optimizer to minimize the overall execution time, that is, to minimize the time it takes to return all rows in the query result set. This hint is generally used for batch mode processes.
Answer
  • ALL_ROWS
  • FIRST_ROWS
  • INDEX(name)
  • OPTIMIZATION_ROWS

Question 6

Question
For Optimizer Hints, ____ instructs the optimizer to minimize the time it takes to process the first set of rows, that is, to minimize the time it takes to return only the first set of rows in the query result set. This hint is generally used for interactive mode processes.
Answer
  • ALL_ROWS
  • FIRST_ROWS
  • INDEX(name)
  • OPTIMIZATION_ROWS

Question 7

Question
The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.
Answer
  • Data cache
  • SQL cache
  • Sort cache
  • Optimizer mode

Question 8

Question
The ____ stores the most recently executed SQL statements (after the SQL statements have been parsed by the optimizer).
Answer
  • Data cache
  • SQL cache
  • Sort cache
  • Optimizer mode

Question 9

Question
The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for in-dex-creation functions.
Answer
  • Data cache
  • SQL cache
  • Sort cache
  • Optimizer mode

Question 10

Question
Most DBMSs operate in one of two optimization modes: cost-based or rule-based. Others automatically de-termine the ____ based on whether database statistics are available.
Answer
  • Data cache
  • SQL cache
  • Sort cache
  • Optimization mode
Show full summary Hide full summary

Similar

Macbeth Scene Summaries
Ebony1023
Timeline of World War One
amayagn
Physics P1
WrightW
AS Biology Biochemistry and Cell Structure
sian_c_evans
AQA - English Language Unit 1
Alice Love
PE AQA GCSE REVISION FLASHCARDS
ellie.baumber
Microsoft Exam 70-410: Volume1- Test 1
Alex Quito
1. Anatomy & Physiology of the Ear
t.whittingham
Chemistry GCSE Review - States of Matter, Particles, Atoms, Elements, Compounds and Mixtures
Morgan Overton
German Family Vocab
LewisK
US Health Care
Arohi Vyas