Exam 15: Organizing and Manipulating the Data in Databases

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

(True/False)

4.7/5

(31)

Question 21

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

(True/False)

4.8/5

(31)

Question 22

A database management system is:

(Multiple Choice)

4.8/5

(36)

Question 23

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

(True/False)

4.9/5

(28)

Question 24

It is not possible to create queries for more than on table at a time.

(True/False)

4.9/5

(43)

Question 25

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

(Multiple Choice)

4.7/5

(34)

Question 26

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

(True/False)

4.9/5

(39)

Question 27

Which one of these is not a good guideline to follow when creating tables in a relational database?

(Multiple Choice)

5.0/5

(29)

Question 28

This tool enables a DBMS to extract only a subset of records from a database:

(Multiple Choice)

4.7/5

(36)

Question 29

DML stands for "data management logic."

(True/False)

4.8/5

(39)

Question 30

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

(True/False)

4.8/5

(51)

Question 31

An advantage of using a drop-down box in an Access database is that:

(Multiple Choice)

4.9/5

(34)

Question 32

This is the Access tool that prohibits users from deleting parent records with child records (i.e., records related in a one-to-many relationship):

(Multiple Choice)

4.9/5

(37)

Question 33

An advantage of defining a default value for an Access data field is that it:

(Multiple Choice)

4.8/5

(29)

Question 34

A database developer can require Access to display records in an ascending sequence using this data field property:

(Multiple Choice)

4.8/5

(38)

Question 35

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

(True/False)

4.8/5

(35)

Question 36

Database management systems can be implemented on:

(Multiple Choice)

4.8/5

(42)

Question 37

Validation rules are useful to prevent data entry errors in databases.

(True/False)

4.8/5

(31)

Question 38

Which of these is most likely to represent an input mask for a telephone number in an Access database?

(Multiple Choice)

4.9/5

(44)

Question 39

If you wish to create a select query with alternate criteria using Microsoft Access , you should specify them on separate Criteria lines of the query.

(True/False)

4.8/5

(33)

Question 40

Showing 21 - 40 of 79

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

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

A database management system is:

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

It is not possible to create queries for more than on table at a time.

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

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

Which one of these is not a good guideline to follow when creating tables in a relational database?

This tool enables a DBMS to extract only a subset of records from a database:

DML stands for "data management logic."

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

An advantage of using a drop-down box in an Access database is that:

This is the Access tool that prohibits users from deleting parent records with child records (i.e., records related in a one-to-many relationship):

An advantage of defining a default value for an Access data field is that it:

A database developer can require Access to display records in an ascending sequence using this data field property:

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

Database management systems can be implemented on:

Validation rules are useful to prevent data entry errors in databases.

Which of these is most likely to represent an input mask for a telephone number in an Access database?

If you wish to create a select query with alternate criteria using Microsoft Access , you should specify them on separate Criteria lines of the query.

Accounting Information Systems and the Accountant

Accounting on the Internet

Information Technology and Aiss

Accounting and Data Analytics

Integrated Accounting and Enterprise Software

Introduction to Internal Control Systems and Risk Management

Computer Controls for Organizations and Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Cybercrime, Fraud, and Ethics

Information Technology Auditing

Documenting Accounting Information Systems

Developing and Implementing Effective Accounting Information Systems

Database Design

Database Forms and Reports

Filters