Question 1

Which of the following is NOT an advantage of using a database system over a file-based legacy system?

Accepted Answer

Data redundancy and inconsistencies are increased

Question 2

In a relational database, what is the primary purpose of normalization?

Accepted Answer

To ensure that every column in a row is single valued and to solve update, insert, and delete anomalies

Question 3

Which DBMS language is used to build the data dictionary and create the database structure?

Accepted Answer

Data Definition Language (DDL)

Question 4

A table in a relational database has a column 'CustomerID' that is the primary key in the 'Customers' table and appears as a foreign key in the 'Sales' table. What rule must be followed for referential integrity?

Accepted Answer

Every value of 'CustomerID' in the 'Sales' table must correspond to a value of 'CustomerID' in the 'Customers' table

Question 5

Which of the following anomalies can occur if all data is stored in one large table instead of related tables?

Accepted Answer

All of the above

Question 6

A user wants to retrieve all invoices for customer 'D. Ainge' and see the salesperson for each invoice. Which DBMS language should be used?

Accepted Answer

Data Query Language (DQL)

Question 7

Which schema level provides an organization-wide view of the entire database?

Accepted Answer

Conceptual-level schema

Question 8

If a primary key in a table is left empty (null), which database design rule is violated?

Accepted Answer

Entity integrity

Question 9

Which of the following best describes the relationship between a file, a record, and a field in a database?

Accepted Answer

A file is a related group of records, and a record is a related group of fields

Question 10

Which of the following is TRUE about the logical and physical views of a database?

Accepted Answer

Physical view refers to how data is actually stored in the system

Question 11

Suppose you are designing a database for a retail company. Which of the following would be the best choice for a primary key in the 'Sales' table?

Accepted Answer

Sales Invoice Number

Question 12

Which of the following statements about the data dictionary is correct?

Accepted Answer

It is a blueprint of the database structure, including data elements, field types, and programs that use the data

Question 13

A database designer needs to understand the conceptual level of the database. What does this mean?

Accepted Answer

Understanding the organization-wide view and relationships between files

Question 14

Which of the following is a consequence of violating the rule that every column in a row must be single valued?

Accepted Answer

It can cause update, insert, and delete anomalies

Question 15

If a foreign key in a table does NOT correspond to any value in the referenced primary key table, which integrity rule is violated?

Accepted Answer

Referential integrity

Question 16

Which of the following best describes the function of the Data Manipulation Language (DML)?

Accepted Answer

It changes the content in the database by creating, updating, inserting, and deleting records

Question 17

A company wants to analyze sales data by salesperson and customer for cross-functional reporting. Which database feature makes this possible?

Accepted Answer

Data integration

Question 18

Which of the following is an example of a query in a relational database?

Accepted Answer

Retrieving all invoices for a specific customer and listing the salesperson for each invoice

Question 19

Given the following formula for referential integrity, which must be true? $\forall x \in 	ext{ForeignKeyTable},\ x \in 	ext{PrimaryKeyTable}$

Accepted Answer

Every value in the foreign key table must exist in the primary key table

Question 20

Which of the following best explains why a relational database uses multiple related tables instead of one large table?

Accepted Answer

To minimize anomalies and improve data integrity

Relational Databases in Accounting Information Systems

Study Guide - Practice Questions

Study Guide - Flashcards