Email: support@essaywriterpros.com
Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

______________ 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

____________________ describes a process on the server side that will properly configure the DBMS environment to respond to clients’ requests in the fastest way possible, while making optimum use of existing resources.

[removed]a. User performance tuning 
[removed]b. Entity performance tuning 
[removed]c. DBMS performance tuning 
[removed]d. SQL performance tuning

How are database statistics obtained?

[removed]a. Automatically by the DBMS. 
[removed]b. Manually by the DBA. 
[removed]c. All of these choices are correct. 
[removed]d. None of these choices are correct.

Which of the following is NOT a phase the DBMS goes through when processing a query?

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

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