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

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.

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

Which of the following is NOT one of the steps you would follow when formulating a query?

[removed]a. Determine how to join the tables 
[removed]b. Identify the source tables 
[removed]c. Determine the order in which to display the output 
[removed]d. Determine the query output

What query optimization factors should you keep in mind if you intend to write conditional expressions in SQL code?

[removed]a. Equality comparisons are faster than inequality comparisons 
[removed]b. Numeric field comparisons are faster than character, date, and NULL comparisons 
[removed]c. Whenever possible, transform conditional expressions to use literals 
[removed]d. All of these choices are correct.

What type of SQL statement updates the data dictionary tables or system catalog?

[removed]a. DDL 
[removed]b. DML 
[removed]c. DBL 
[removed]d. None of these choices are correct.