Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

the SQL query command

A(n) _______________ uses 0s and 1s to represent the existence of a value or condition.

[removed]a. B-tree index 
[removed]b. bitmap index 
[removed]c. hash index 
[removed]d. reverse index

What database statistics measurements are typical of tables?

[removed]a. Row length 
[removed]b. Number of rows and number of columns 
[removed]c. Number of disk blocks used 
[removed]d. All of these choices are correct.

______________ refers to the number of different values a column could possibly have.

[removed]a. Data measurement 
[removed]b. Data clarity 
[removed]c. Data access 
[removed]d. Data sparsity

The term __________________ refers to a number of measurements gathered by the DBMS to describe a snapshot of the database objects’ characteristics.

[removed]a. entity statistics 
[removed]b. query statistics 
[removed]c. database statistics 
[removed]d. user statistics

Which of the following is NOT one of the general guidelines for creating and using indexes?

[removed]a. Declare indexes in join columns other than PK or FK 
[removed]b. Use indexes in small tables or tables with low sparsity 
[removed]c. Declare primary and foreign keys 
[removed]d. All of these choices are guidelines.

Which of the following phase is where the DBMS runs the SQL query using the chosen plan?

[removed]a. Fetching 
[removed]b. Compiling 
[removed]c. Execution 
[removed]d. Parsing

_____________ database systems are optimized to store large portions (if not all) of the database in primary (RAM) storage rather than secondary (disk) storage.

[removed]a. In-sync 
[removed]b. In-memory 
[removed]c. All of these choices are correct. 
[removed]d. None of these choices are correct.

In simple terms, the DBMS processes queries in ________ phase(s).

[removed]a. four 
[removed]b. one 
[removed]c. two 
[removed]d. three

Which of the following phase is where the DBMS analyzes the SQL query and chooses the most efficient access/execution plan?

[removed]a. Fetching 
[removed]b. Parsing 
[removed]c. Execution 
[removed]d. Compiling

RAID level _______________ is when the data and the parity are striped across separate drives, providing good read performance and fault tolerance via parity data.

[removed]a. 1 
[removed]b. 5 
[removed]c. 0 
[removed]d. 3

Optimizer ______ are special instructions for the optimizer that are embedded inside the SQL command text.

[removed]a. hints 
[removed]b. costs 
[removed]c. facts 
[removed]d. rules