FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Database Industry Careers

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

What happens when you run a select query in Access?

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.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

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

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

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

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 relational database handles entities, attributes, and relationships by storing each entity in its own row.

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

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

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