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

Economics definitions: F582
busybee112
06 PROJECT TIME MANAGEMENT
miguelabascal
Girls' and Boys' Education - A Mind Map
Cecelia Price
Girls' and Boys'Education - A Mind Map Nikki and Mikayla
nikkifulps
Algebraic Fractions
Olivia McKenzie
Health and Safety Quiz
lynseyrogers23
Mind Map 1_1
n.marment
Personality disorders
Anna Walker
Roles of Education
Isobel Wagner
Adding, Subtracting, Multiplying, and Dividing Integers Study Cards (7th Grade)
irenepapers
Clinical Pathoanatomy MCQs (Q 151-250)
Ore iyanda