Concepts of Database Design (7e), Ch. 2

Question 1: Based on the Customer table below, which command lists all information from the table concerning customer 282?
CustomerNum CustomerName Street City State Zip
148 Al’s Appliance 28 Greenway Filmore FL 33336
282 Brookings 3827 Devon Grove FL 33321
Correct Answer: SELECT Customer WHERE CustomerNum=282 GIVING Answer

Question 2: A ____ query creates a new table using the query results.
Correct Answer: make-table

Question 3: Each column in a table should have a unique name, and entries in each column should all “match” this column name.
Correct Answer: True

Question 4: An unnormalized relation is a table that has more than one row.
Correct Answer: False

Question 5: If you are sorting records by more than one field, the more important field is called the ____.
Correct Answer: primary sort key

Question 6: The concept of grouping means that statistics will be calculated for individual records.
Correct Answer: False

Question 7: The ____ operator is used to concatenate every row in the first table with every row in the second table.
Correct Answer: product

Question 8: The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.
Correct Answer: primary

Question 9: Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query.
Correct Answer: aggregate

Question 10: A query is a question represented in a way that the DBMS can recognize and process.
Correct Answer: True

Question 11: Based on the statement below, which of the following is the primary key?
Rep (RepNum, LastName, FirstName, Street, City, State, Zip, Commission, Rate)
Correct Answer: RepNum

Question 12: The compound criteria (conditions) are created by using ____.
Correct Answer: AND, OR

Question 13: A relational database is a collection of relations.
Correct Answer: True

Question 14: Using the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in the product of these two tables is ____.
Correct Answer: 16

Question 15: You can restrict the output from a join to include only certain columns by using the ____ command.
Correct Answer: PROJECT

Question 16: The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included.
Correct Answer: PROJECT

Question 17: A relation is a(n) ____.
Correct Answer: table

Question 18: QBE is a visual approach to writing queries.
Correct Answer: True

Question 19: A query that changes data is a(n) ____ query.
Correct Answer: update

Question 20: A column whose value uniquely identifies a given row in the table is the secondary key.
Correct Answer: False

Question 21: In a relation, the order of the columns is important.
Correct Answer: False

Question 22: Which operation will allow you to extract data from more than one table?
Correct Answer: Join

Question 23: In an AND criterion, the overall criterion is true if either of the individual criteria is true.
Correct Answer: False

Question 24: When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____.
Correct Answer: write both the table name and the column name, separated by a period

Question 25: In a relation, the order of rows is important.
Correct Answer: False

Question 26: The ____ command within relational algebra takes a vertical subset of a table.
Correct Answer: PROJECT

Question 27: Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data.
Correct Answer: union

Question 28: The ____ operator is performed by the SUBTRACT command in relational algebra.
Correct Answer: difference

Question 29: The comparison operators are +, *, %, and /.
Correct Answer: False

Question 30: The product of two tables is also called the ____ product.
Correct Answer: Cartesian

Question 31: Access automatically adds double quotation marks around values in the design grid that are formatted as Text fields when you run the query or move the insertion point to another cell in the design grid.
Correct Answer: True

Question 32: Rows are also called ____.
Correct Answer: tuples

Question 33: The attributes of an entity become the fields or columns in a table.
Correct Answer: True

Question 34: A relational database handles entities, attributes, and relationships by storing each entity in its own table.
Correct Answer: True

Question 35: The comparison operators are also known as relational operators.
Correct Answer: True