Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 
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 3

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 
A) OR 
B) aggregate 
C) AND 
D) BOTH

Question 4

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 
A) new-table 
B) make-table 
C) create-table 
D) merge-table

Question 5

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 
A) query 
B) product 
C) relationship 
D) tuple

Question 6

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. 
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 7

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 
A) Sum 
B) Total 
C) Count 
D) Max

Question 8

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 9

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

Accepted Answer

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

Question 10

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] 
A) Date - DueDate 
B) Today - [DueDate] 
C) Day() - [DueDate] 
D) Date() - [DueDate]

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

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)

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

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

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

What happens when you run a select query in Access?

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

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

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

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

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Trends

Filters

Exam 8: Database Industry Careers

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

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)

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

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

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

What happens when you run a select query in Access?

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

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

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

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

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Trends

Filters