Question 1

What type of Access query creates a new table using the query results?

Accepted Answer

A)  new-table
B)  make-table
C)  create-table
D)  merge-table

Question 2

If you use ____________________ criteria, each criterion must be true for a record to be selected.

Accepted Answer

A)  OR
B)  aggregate
C)  AND
D)  BOTH

Question 3

A _____ is a question about the data structured in a way that the DBMS can recognize and process.

Accepted Answer

A)  query
B)  product
C)  relationship
D)  tuple

Question 4

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)

Accepted Answer

A)  SELECT Customer 260 RESULTS Answer
B)  SELECT Customer WHERE CustomerNum=260 GIVING Answer
C)  SELECT Customer GIVING Answer WHERE CustomerNum='260'
D)  SELECT Customer WHERE CustomerNum='260' RESULTS Answer

Question 5

In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?

Accepted Answer

A)  Date - DueDate
B)  Today - [DueDate]
C)  Day()  - [DueDate]
D)  Date()  - [DueDate]

Question 6

Which aggregate function do you use to total the values in a numeric field in a group of records?

Accepted Answer

A)  Sum
B)  Total
C)  Count
D)  Max

Question 7

What happens when you run a select query in Access?

Accepted Answer

A)  Access creates a unique copy of the data.
B)  Access selects current data from underlying tables.
C)  Access creates a table with the specified fields and records.
D)  Access locks the underlying tables so they cannot be changed.

Question 8

A relational database handles entities, attributes, and relationships by storing each entity in its own row.

Accepted Answer

A) True 
 B)False

Question 9

In Access, you can display the results of a select query using the Run button or the View button.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following criteria selects all records containing a value greater than 250?

Accepted Answer

A)  ="250"
B)  250
C)  250
D)  >250

Exam 8: Database Industry Careers

If you use ____________________ criteria, each criterion must be true for a record to be selected.

Correct Answer
verified

What type of Access query creates a new table using the query results?

Correct Answer
verified

Which aggregate function do you use to total the values in a numeric field in a group of records?

Correct Answer
verified

In Access, you can display the results of a select query using the Run button or the View button.

Correct Answer
verified

A _____ is a question about the data structured in a way that the DBMS can recognize and process.

Correct Answer
verified

What happens when you run a select query in Access?

Correct Answer
verified

Which of the following criteria selects all records containing a value greater than 250?

Correct Answer
verified

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)

Correct Answer
verified

In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?

Correct Answer
verified

A relational database handles entities, attributes, and relationships by storing each entity in its own row.

Correct Answer
verified

Exam 8: Database Industry Careers

If you use ____________________ criteria, each criterion must be true for a record to be selected.

Correct AnswerverifiedShow Answer

What type of Access query creates a new table using the query results?

Correct AnswerverifiedShow Answer

Which aggregate function do you use to total the values in a numeric field in a group of records?

Correct AnswerverifiedShow Answer

In Access, you can display the results of a select query using the Run button or the View button.

Correct AnswerverifiedShow Answer

A _____ is a question about the data structured in a way that the DBMS can recognize and process.

Correct AnswerverifiedShow Answer

What happens when you run a select query in Access?

Correct AnswerverifiedShow Answer

Which of the following criteria selects all records containing a value greater than 250?

Correct AnswerverifiedShow Answer

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)

Correct AnswerverifiedShow Answer

In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?

Correct AnswerverifiedShow Answer

A relational database handles entities, attributes, and relationships by storing each entity in its own row.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified