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

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) ________________________ is one in which all data integrity constraints are satisfied.

751794110561795110[removed]NULLCOMMIT****     A(n) _______________ optimizer uses a set of preset conditions and points to determine the best approach to execute a query. The conditions assign a “cost” to each SQL operation; the costs are then added to yield the cost of the execution plan.[removed]a. user-based [removed]b. query-based [removed]c. rule-based [removed]d. cost-basedWhat database statistics measurements are typical of environment resources?[removed]a. The logical and physical disk block size [removed]b. The location and size of data files [removed]c. The number of extends per data file [removed]d. All of these choices are correct.