O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

C192 Query Processing

Brandon Gagon 10 perguntas

Fazer o quiz

Perguntas do quiz (10)

  1. 1The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.
    1. Abuffer cache
    2. Bprocedure cache
    3. CSQL cache
    4. Dpermanent storage
  2. 2If there is no index, the DBMS will perform ____.
    1. Aa loop scan
    2. Ba range scan
    3. Ca row ID table access scan
    4. Da full table scan
  3. 3One 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.
    1. Adatabase statistics
    2. Bdata sparsity
    3. Cprimary key
    4. Dquery optimzation
  4. 4_________ is the central activity during the parsing phase in query processing
    1. Adatabase statistics
    2. Bdata sparsity
    3. CSQL query
    4. Dquery optimization
  5. 5For 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.
    1. AALL_ROWS
    2. BFIRST_ROWS
    3. CINDEX (name)
    4. DOPTIMIZATION_ROWS
  6. 6For 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.
    1. AALL_ROWS
    2. BFIRST_ROWS
    3. CINDEX (name)
    4. DOPTIMIZATION_ROWS
  7. 7The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.
    1. AData cache
    2. BSQL cache
    3. CSort cache
    4. DOptimizer mode
  8. 8The ____ stores the most recently executed SQL statements (after the SQL statements have been parsed by the optimizer).
    1. AData cache
    2. BSQL cache
    3. CSort cache
    4. DOptimizer mode
  9. 9The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.
    1. AData cache
    2. BSQL cache
    3. CSort cache
    4. DOptimizer mode
  10. 10Most DBMSs operate in one of two optimization modes: cost-based or rule-based. Others automatically determine the ____ based on whether database statistics are available.
    1. AData cache
    2. BSQL cache
    3. CSort cache
    4. DOptimization mode

Informações

Descrição
Quiz sobre C192 Query Processing, criado por Brandon Gagon em 30-11-2020.
Idioma
English
Visualizações
0
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?