Database Management Chapter 2
If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View? a.(Consulting) b.#Consulting# c."Consulting" d.[Consulting]
"Consulting"
For a one-to-many relationship in the Access Relationships window, how can you tell which table is the "many" table? a.The "many" table always appears to the left of the "one" table. b.The one symbol identifies the "many" table. c.An infinity symbol identifies the "many" table. d.The "many" table always appears below the "one" table.
An infinity symbol identifies the "many" table.
If you use an aggregate function in a query to determine the average values in a Bonus field, what default field name does Access use for the column with the calculations? a.BonusAvg b.AvgOfBonus c.Bonus d.Average Bonus
AvgOfBonus
The Access query design grid contains the ProductID, ProductName, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query? a.Clear the checkmark from the Rating field's Show check box. b.Delete the Rating field from the query design grid. c.Change the query to an update query. d.Add a second copy of the Rating field to the query design grid
Clear the checkmark from the Rating field's Show check box.
In Access Query Design View, how do you add the Total row to the query design grid? a.Click the Group by arrow in the Criteria row, and then click Total. b.Drag the Total field to the query design grid. c.Click the Grouping button on the Query Tools Design tab. d.Click the Totals button on theQuery Tools Design tab.
Click the Totals button on theQuery Tools Design tab.
Which of the following Access functions can you use to return the number of records in a group of records? a.Total b.Count c.Number d.Group
Count
In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate? a.Day() - [DueDate] b.Date - DueDate c.Date() - [DueDate] d.Today - [DueDate]
Date() - [DueDate]
Which of the following is a technique for increasing the speed of Access queries? a.Type field names directly into the query design grid. b.Use Query Design View to join tables. c.Include fields considered optional for the query. d.Delete field lists that are not needed for the query.
Delete field lists that are not needed for the query.
Which of the following fields would be the best candidate for a primary key field in a table of employee data? a.LastName b.BirthDate c.Email d.EmployeeID
EmployeeID
Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field? a.Salary / 12 = [MonthlySalary] b.MonthlySalary: [Salary] / 12 c.MonthlySalary: "Salary" / 12 d.MonthlySalary = [Salary / 12]
MonthlySalary: [Salary] / 12
In relational algebra, what command is used to identify certain columns? a.DELETE b.SELECT c.PROGRAM d.PROJECT
PROJECT
Based on the following table, which relational algebra command creates a new table named CustState containing the fields CustomerNum and State?Customer (CustomerNum, CustomerName, Street, City, State, PostalCode) a.JOIN Customer WITH (CustomerNum, State) GIVING CustState b.MAKE-TABLE CustState FROM Customer WITH (CustomerNum, State) c.SELECT Customer OVER (CustomerNum, State) GIVING CustState d.PROJECT Customer OVER (CustomerNum, State) GIVING CustState
PROJECT Customer OVER (CustomerNum, State) GIVING CustState
In Access, if you want a query to list the ProductID, Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid? a.ProductID, Category, Description b.Description, Category, ProductID c.Description, ProductID, Category d.ProductID, Description, Category
ProductID, Category, Description
In relational algebra, which command retrieves rows from a table based on specified criteria? a.CREATE b.UNION c.JOIN d.SELECT
SELECT
Based on the following notation, which relational algebra command would list all information from the table concerning the customer with numeric CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode) a.SELECT Customer WHERE CustomerNum=260 GIVING Answer b.SELECT Customer 260 RESULTS Answer c.SELECT Customer GIVING Answer WHERE CustomerNum='260' d.SELECT Customer WHERE CustomerNum='260' RESULTS Answer
SELECT Customer WHERE CustomerNum=260 GIVING Answer
In an Access query, how can you list records in A-Z order by last name? a.Set a descending sort order in the LastName field. b.Set an ascending sort order on the LastName field. c.Remove the checkmark from the Show box in the LastName field. d.Group the LastName field.
Set an ascending sort order on the LastName field.
Which aggregate function do you use to total the values in a numeric field in a group of records? a.Sum b.Count c.Total d.Max
Sum
Which of the following is NOT true about a relation, otherwise known as a two-dimensional table? a.All values in a column should be values of the same attribute. b.The order of rows is not important. c.Two or more columns can share the same name. d.The entries in the table should be single-valued
Two or more columns can share the same name.
What type of Access query creates a new table using the query results? a.make-table b.create-table c.new-table d.merge-table
make-table
In Access, if you want to be able to enter different criteria each time you run a query, create a(n) _____ query. a.update b.aggregate c.parameter d.run-time
parameter
In Access, what uniquely identifies a row in a table? a.field b.column c.attribute d.primary key
primary key
If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes? a.secondary sort key b.minor sort key c.maximum sort key d.primary sort key
primary sort key
A _____ is a question about the data structured in a way that the DBMS can recognize and process. a.relationship b.tuple c.query d.product
query
The field you use to sort records is called the _____. a.sort key b.foreign key c.parent key d.sort argument
sort key
Which database term refers to a row in a table? a.field b.relation c.group d.tuple
tuple
What type of Access query changes data? a.update b.addition c.select d.projection
update
If you use ____________________ criteria,each criterion must be true for a record to be selected. a.aggregate b.AND c.OR d.BOTH
AND
You can create compound criteria (conditions) in a query by using which of the following two keywords? a.NOT, ONLY b.AND, OR c.AND, NOR d.OR, NOT
AND, OR
What happens when you run a select query in Access? a.Access creates a unique copy of the data. b.Access locks the underlying tables so they cannot be changed. c.Access creates a table with the specified fields and records. d.Accessselects current data from underlying tables.
Accessselects current data from underlying tables.
How are aggregate functions different from other types of functions? a.Aggregate functions make calculations on groups of records. b.Aggregate functions work only with numeric data. c.Aggregate functions do not work with date values. d.Aggregate functions return yes/no or true/false values
Aggregate functions make calculations on groups of records.
What type of query could you run to remove records with a product ID of 702 from the Products table? a.update query b.parameter query c.difference query d.delete query
delete query
What do you call the field used to join two tables on the "many" side of a one-to-many relationship? a.foreign key field b.calculated field c.primary key field d.secondary sort field
foreign key field
In the Access QBE, where do you specify criteria for a query? a.in Datasheet view of the query b.in the Criteria row of the query design grid c.in the upper pane of Query Design View d.in the Navigation Pane
in the Criteria row of the query design grid
Which of the following criteria selects all records containing a value greater than 250? a.<>250 b.>250 c.="250" d.250
>250
In general, what should be in place before you select fields from more than one table in Access Query Design View? a.The join line between the tables should be deleted. b.The tables should not contain fields with the same field name. c.The tables should be related in a proper one-to-many relationships. d.The tables should be merged into one table.
The tables should be related in a proper one-to-many relationships.
If you are creating a computed field that adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression? a."UnitPrice" b.[UnitPrice] c.Unit Price d.(UnitPrice)
[UnitPrice]
What type of functions are Count, Sum, Avg, Max, and Min? a.accumulation b.primary c.aggregate d.allowed
aggregate
A ____________________in a record is the result of a calculation using data from the rest of the record. a.computed field b.foreign key field c.composite field d.grouping field
computed field
When you can determine the value of a field using information from existing fields in a record in a query, you should create a(n) _____. a.argument b.grouping field c.computed field d.compound condition
computed field
In Access a(n) _____ query permanently removes all the records from the selected table(s) that satisfy the criteria entered in the query. a.make-table b.parameter c.delete d.update
delete
