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

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

he 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