The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.
Responda
buffer cache
procedure cache
SQL cache
permanent storage
Questão 2
Questão
If there is no index, the DBMS will perform ____.
Responda
a loop scan
a range scan
a row ID table access scan
a full table scan
Questão 3
Questão
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.
Responda
database Statistics
data sparsity
primary key
query optimization
Questão 4
Questão
____ is the central activity during the parsing phase in query processing.
Responda
database Statistics
data sparsity
SQL query
query optimization
Questão 5
Questão
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.
Responda
ALL_ROWS
FIRST_ROWS
INDEX(name)
OPTIMIZATION_ROWS
Questão 6
Questão
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.
Responda
ALL_ROWS
FIRST_ROWS
INDEX(name)
OPTIMIZATION_ROWS
Questão 7
Questão
The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.
Responda
Data cache
SQL cache
Sort cache
Optimizer mode
Questão 8
Questão
The ____ stores the most recently executed SQL statements (after the SQL statements have been parsed by the optimizer).
Responda
Data cache
SQL cache
Sort cache
Optimizer mode
Questão 9
Questão
The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for in-dex-creation functions.
Responda
Data cache
SQL cache
Sort cache
Optimizer mode
Questão 10
Questão
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.
Responda
Data cache
SQL cache
Sort cache
Optimization mode
Quer criar seus próprios Quizzesgratuitos com a GoConqr? Saiba mais.
Semelhante
INCOMPLETO - Biologia e Geologia - Geologia 11º ano, parte IV - Ensino Secundário Português