Question 1

Which of the following correctly describes the Referential Integrity Rule?
A. The primary key of a table must have data values (cannot be null)
B. Each attribute in a table must have a unique name
C. The data value for a foreign key could be null
D. Values of a specific attribute must be of the same type

Accepted Answer

The data value for a foreign key could be null

Question 2

The "Where" SQL clause can be used to link two tables.

Accepted Answer

The "Where" clause can be used to specify a condition that links two tables in a SQL statement.

Question 3

In a hierarchical data model, data elements are related in many-to-many relationships.

Accepted Answer

In a hierarchical data model, data elements are organized in a tree-like structure with one-to-many relationships between parent and child elements. Many-to-many relationships are not directly supported in this model, and require complex workarounds such as creating additional parent nodes or using multiple hierarchies.

Question 4

Classes could be grouped into Resources (R), Entities (E), and Assets (A) in data modeling.

Accepted Answer

The answer of Classes could be grouped into Resources (R),...

Question 5

Three types of data models used today are: the hierarchical model, the network model and the relational model.

Accepted Answer

The three types of data models used today are the hierarchical model, the network model, and the relational model.

Question 6

SQL is based on relational algebra and allows a user to query and update the database.

Accepted Answer

SQL is based on the concepts of relational algebra, which is a mathematical theory for working with relational databases. SQL allows users to query (retrieve data) and update (modify or delete data) the database using a set of commands and functions.

Question 7

Each attribute in a table can have several names.

Accepted Answer

Each attribute in a table is identified by a unique name to avoid ambiguity.

Question 8

Access is a simple database management system that can be used to run databases for individuals and small firms.

Accepted Answer

Access is a simple database management system that is commonly used for individuals and small firms to manage their data.

Question 9

In Access, users can edit database information in reports.

Accepted Answer

Users cannot edit database information in reports directly. They must go back to the table or form where the information originated to make changes.

Question 10

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations. Which of the following systems is most effective for this application?
A. A decision support system.
B. An executive support system.
C. An office automation system.
D. An enterprise resource planning system.

Accepted Answer

The answer of A company would like to implement a...

Question 11

Queries in Access are utilized by users to enter data into tables and view existing records.

Accepted Answer

Queries in Access are used to retrieve and manipulate data from tables, not to enter or view data directly.

Question 12

In Microsoft Access, we use tables in a database for:
A. Data entry
B. Data storage
C. Data retrieval
D. Two of the above are correct.

Accepted Answer

The answer of In Microsoft Access, we use tables in...

Question 13

In a database, while queries allow the user to access, read and report on desired data, the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).

Accepted Answer

Queries only allow the user to retrieve data, while the DBMS is responsible for modifying the actual database.

Question 14

Which of the following tasks cannot be performed through queries in Access?
A. Retrieve and display data
B. Calculations of data
C. Data sorting
D. Create and update relationships

Accepted Answer

The answer of Which of the following tasks cannot be...

Question 15

Which type of data models allows each record to have multiple parent and child records?
A. The hierarchical mode
B. The network model
C. The relational model
D. None of the above

Accepted Answer

The answer of Which type of data models allows each...

Question 16

Cloud computing is an internet-based computing where shared resources, software, and information is provided to firms on demand.

Accepted Answer

Cloud computing is indeed an internet-based computing where shared resources, software, and information is provided to firms on demand.

Question 17

While hierarchical and network data models require relationships to be formed at the database creation, relational data models allow relationships to be created and updated as needed.

Accepted Answer

Hierarchical and network data models have strict relationships that must be defined at the time of database creation, while relational data models allow for relationships to be created and updated as needed. This is one of the main advantages of the relational data model.

Question 18

The asterisk (*) following the SELECT SQL statement is a wild card indicating all columns should be selected.

Accepted Answer

The asterisk (*) in SQL is a wild card that selects all columns from the specified table.

Question 19

Access offers modules, which are defined by users to automate processes like opening a specific form.

Accepted Answer

The answer of Access offers modules, which are defined by...

Question 20

The SQL command "Group by" can be used to order an amount in a descending order.

Accepted Answer

The "Group by" command is used to group rows together based on one or more columns. It does not order data in a descending order. The "Order by" command is used for sorting data in a specific order.

Quiz 4: Relational Databases and Enterprise System