Question 1

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

Accepted Answer

A query is a request for data or information from a database table or combination of tables. This data may be generated as results returned by Structured Query Language (SQL) or as pictorials, graphs, or complex results, depending on the query.

Question 2

The attributes of an entity become the fields or columns in a table.

Accepted Answer

In database design, the attributes of an entity (which represent the properties or characteristics of that entity) are modeled as the fields or columns within a table.

Question 3

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?

Accepted Answer

To use a field to set a criterion for a query without displaying it in the query results, you should clear the checkmark from the field's "Show" checkbox in the query design grid. This action keeps the field in the grid for criteria purposes but omits it from the final output.

Question 4

Which of the following is NOT true about a relation, otherwise known as a two-dimensional table?

Accepted Answer

In a relation or a two-dimensional table, each column must have a unique name to ensure that each attribute is distinctly identifiable. Sharing the same name between two or more columns would violate this principle.

Question 5

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

Accepted Answer

Both the Run button and the View button in Microsoft Access can be used to display the results of a select query. The Run button executes the query and shows the results in a datasheet view, while the View button allows you to toggle between Design View and Datasheet View, the latter displaying the query results.

Question 6

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?

Accepted Answer

The correct arrangement is ProductID, Category, Description. This allows you to list the required fields and sort by Description within each Category, as sorting in Access queries follows the left-to-right order of fields in the design grid.

Question 7

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

Accepted Answer

A computed field is created in a query when you need to calculate a value using information from existing fields in a record. This allows for dynamic calculation of new data points based on existing data within the database.

Question 8

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?

Accepted Answer

In expressions, especially within databases like Microsoft Access, field names are often enclosed in square brackets to handle spaces, special characters, or reserved words, making [UnitPrice] the correct syntax for referring to a field named UnitPrice.

Question 9

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?

Accepted Answer

In Access, when specifying criteria for text fields in the query design grid, the text should be enclosed in double quotes. Therefore, "Consulting" is the correct format.

Question 10

In Access, what uniquely identifies a row in a table?

Accepted Answer

A primary key is a unique identifier for a row in a database table, ensuring that no two rows have the same primary key value.

Question 11

To select data from more than one table at the same time, you need to perform a make-table query.

Accepted Answer

To select data from more than one table at the same time, you can use a JOIN operation in SQL, not necessarily a make-table query.

Question 12

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

Accepted Answer

The SUM function is used to total the values in a numeric field across a group of records, providing the aggregate sum of those values.

Question 13

In Access a(n) _____ query permanently removes all the records from the selected table(s) that satisfy the criteria entered in the query.

Accepted Answer

A delete query in Access is designed to remove all records from one or more tables that match the specified criteria, permanently deleting them from the database.

Question 14

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

Accepted Answer

A relational database stores each entity in its own table, with rows representing individual records and columns representing attributes. Relationships are managed through keys and foreign keys.

Question 15

In Access, if you want to be able to enter different criteria each time you run a query, create a(n) _____ query.

Accepted Answer

A parameter query in Access allows the user to enter different criteria each time the query is run, making it dynamic and flexible for various search conditions.

Question 16

What happens when you run a select query in Access?

Accepted Answer

Access selects current data from underlying tables when a select query is run, ensuring that the most up-to-date information is retrieved without creating a new table or locking the tables against updates.

Question 17

Which database term refers to a row in a table?

Accepted Answer

A tuple in database terminology refers to a single row in a table, representing a single record.

Question 18

The field you use to sort records is called the _____.

Accepted Answer

The term "sort key" refers to the specific field used to determine the order in which records are sorted in a database or data set.

Question 19

Microsoft Access uses Query Design View as a QBE.

Accepted Answer

Query Design View in Microsoft Access is an example of a Query By Example (QBE) interface, allowing users to create queries visually by specifying criteria in a grid or layout.

Question 20

In relational algebra, which command retrieves rows from a table based on specified criteria?

Accepted Answer

The SELECT command in relational algebra is used to retrieve rows from a table based on specified criteria.

Quiz 8: Database Industry Careers