How many copies of the database schema are typically used in the redesign process?

What rows will this select statement return ?

SELECT * FROM products WHERE ordernumber > = 1000

• [A] All rows in the products table whose order number is greater than or equal to 1000
• [B] All rows in the products table whose order number is less than or equal to 1000
• [C] The first 1000 rows of the product table
• [D] All rows in the products table whose order number is greater than 1000

Which one of the following is a direct benefit of databse normalization?

• [A] higher query processing efficiency
• [B] smaller number of tables
• [C] reduced I/O for most queries
• [D] reduced data redundancy

Which of the following is not the function of client?

• [A] Compile queries
• [B] Query optimization
• [C] Receive queries
• [D] Result formatting and presentation

In an ER model, ................ is described in the database by storing its data.

• [A] Entity
• [B] Attribute
• [C] Relation ship
• [D] Notation

Versatile report generator can provide ?

• [A] Columnar totals
• [B] Subtotal
• [C] Calculation
• [D] ALL