Question 1

An exclamation point in the design menu of an Access query means to "run the query."

Accepted Answer

In Microsoft Access, an exclamation point icon in the design menu of a query is used to indicate the "Run" command, which executes the query.

Question 2

A database subschema is a plot that can often be discovered with forensic accounting.

Accepted Answer

True

Question 3

A DBMS is an efficient database table in third normal form.

Accepted Answer

A DBMS (Database Management System) is a software system designed to manage databases, not a database table or its normalization form.

Question 4

An example of an input mask for an Access data field is 999\-00\-0000;;??_.

Accepted Answer

An input mask like 999\-00\-0000;;??_.. in Access is used to manage how data is entered into a database field, ensuring it follows a specific format, such as that for a Social Security number.

Question 5

A DBMS is a type of hardware.

Accepted Answer

A DBMS (Database Management System) is a type of software that allows users to store, retrieve, and manage data in databases, not hardware.

Question 6

A DBMS is a type of software.

Accepted Answer

A DBMS (Database Management System) is software designed to store, retrieve, define, and manage data in a database.

Question 7

Database designers typically store employee Social Security numbers as "Long Integer" data types.

Accepted Answer

Database designers typically store employee Social Security numbers as "Long Integer" data types because they are unique identifiers that can be used to track employees over time.

Question 8

DML stands for "data management logic."

Accepted Answer

The answer of DML stands for "data management logic."...

Question 9

SQL is an example of a database query language.

Accepted Answer

The answer of SQL is an example of a database...

Question 10

Databases are the same thing as database management systems.

Accepted Answer

Databases are structured collections of data, while database management systems (DBMS) are software applications used to manage, manipulate, and interact with databases.

Question 11

An example of a data type for a database record field is "short text."

Accepted Answer

The answer of An example of a data type for...

Question 12

Select queries are, by definition, multi-table queries.

Accepted Answer

The answer of Select queries are, by definition, multi-table queries....

Question 13

DDL is an acronym for "data definition language."

Accepted Answer

DDL stands for Data Definition Language, which is used in database management systems to define the structure of the database, including creating, altering, and deleting tables and schemas.

Question 14

If there are multiple search criteria on the criteria row of a query, this is the equivalent of an AND requirement.

Accepted Answer

The answer of If there are multiple search criteria on...

Question 15

A database schema is a plan of the entire database.

Accepted Answer

The answer of A database schema is a plan of...

Question 16

One way to create an OR condition in a query is to place the search criteria on different lines of the query.

Accepted Answer

The answer of One way to create an OR condition...

Question 17

When purchasing a new database management system, managers should focus on the system's technological capabilities rather than its compatibility with current systems.

Accepted Answer

Compatibility with current systems is important, but it should not be the primary focus when purchasing a new database management system. The system's technological capabilities, such as its scalability, performance, and security, are more important factors to consider.

Question 18

A plus sign to the left of a database record in Access means there are related records linked to it.

Accepted Answer

The plus sign indicates that the record can be expanded to show related records in a subdatasheet view, revealing the one-to-many relationship between the records.

Question 19

It is not possible to encode search criteria in more than one column of the criteria row in Access.

Accepted Answer

In Access, you can encode search criteria in multiple columns of the criteria row to refine your search, allowing for more complex queries.

Question 20

Database management systems allow their users to create "input masks" which help to prevent input errors.

Accepted Answer

Input masks in database management systems are used to guide users in entering data in a specific format, thereby reducing input errors by ensuring that data is entered correctly and consistently.

Quiz 15: Organizing and Manipulating the Data in Databases