Question 1

Typically, in hierarchical database management systems, a one-to-one relationship exists between data entities.

Accepted Answer

In hierarchical database management systems, data entities have a one-to-many relationship, where a parent entity can have multiple child entities, but a child entity can only have one parent entity.

Question 2

IBM's DB2 program contains a hybrid XML/relational database server.

Accepted Answer

IBM's DB2 program does contain a hybrid XML/relational database server which allows for more flexibility in data storage and retrieval.

Question 3

Hashing procedures usually result in two or more records being assigned the same storage address, an event known as a collision.

Accepted Answer

This is true as collisions can occur in hashing procedures depending on the specific algorithm and data being hashed. These collisions must be resolved through a collision resolution technique such as chaining or probing.

Question 4

Repairing or restoring data that has become corrupt, such as the result of a storage media error or a computer virus, is a database analysis activity.

Accepted Answer

Repairing or restoring data that has become corrupt is a data recovery activity, not specifically a database analysis activity. Database analysis typically involves examining data within databases to identify patterns, trends, or anomalies, rather than repairing or restoring data.

Question 5

The data dictionary includes data located in the database tables.

Accepted Answer

A data dictionary, also known as a metadata repository, is a centralized collection of information about data, such as meaning, relationships to other data, origin, usage, and format. It does not include the data itself that resides in database tables but rather describes the structure of these tables, the data types, and the relationships between tables.

Question 6

If a field needs to store decimal places, the Long Integer field size can be used.

Accepted Answer

The Long Integer field size cannot store decimal places, as it only stores whole numbers. Decimal places require the Decimal field size or the Double field size.

Question 7

Some client-server database systems just have two parts (the clients and the server), others have at least one middle component between the client and the server; these systems are referred to as n-tier database systems.

Accepted Answer

This statement is correct. Some client-server database systems have an additional middle component between the client and the server, making them n-tier database systems.

Question 8

A database that combines object and relational database technology can be referred to as an object-oriented database management system (OODBMS).

Accepted Answer

A database that combines object and relational database technology is referred to as an object-relational database management system (ORDBMS), not an object-oriented database management system (OODBMS).

Question 9

Many-to-many entity relationships exist when one entity can be related to more than one other entity, and those entities can be related to multiple entities of the same type as the original entity.

Accepted Answer

In many-to-many entity relationships, one entity can be related to multiple entities of the same type, and those entities can also be related to multiple entities of the original entity's type. This results in a complex web of relationships between the entities.

Question 10

Normalization is usually viewed as a multistep process, moving the table structures from first normal form (1NF) to usually fifth normal form (5NF).

Accepted Answer

The answer of Normalization is usually viewed as a multistep...

Question 11

N-tier database systems provide a great deal of flexibility and scalability, allowing the system to be modified as new needs and opportunities arise.

Accepted Answer

N-tier database systems are designed to be flexible and scalable, allowing changes to be made easily and accommodating growth over time. This makes them a popular choice for businesses and organizations that need to adapt their systems to changing circumstances or increasing demand.

Question 12

A database typically consists of interrelated tables that contain forms and reports.

Accepted Answer

A database typically consists of interrelated tables that store data, but forms and reports are used to display and present the data in a user-friendly way.

Question 13

​One of the most common types of software used in conjunction with a multi-dimensional database is Online Analytical Processing (OLAP).

Accepted Answer

OLAP is commonly used in conjunction with multi-dimensional databases to allow for complex analysis and reporting.

Question 14

Most databases created today do not use the hierarchical or network models; however, these models, which are generally used with legacy mainframe systems, are still operational and so must be maintained.

Accepted Answer

The statement correctly states that most databases created today do not use hierarchical or network models but adds that these models are still in use in legacy mainframe systems, which means they must be maintained.

Question 15

Arranging data for efficient retrieval is called data organization.

Accepted Answer

Data organization involves arranging data in a logical and structured way to enable efficient and effective retrieval when needed.

Question 16

Data integrity refers to the accuracy of data.

Accepted Answer

Data integrity means the data remains unaltered, timely and consistent throughout its life cycle. Therefore, it refers to the accuracy and completeness of data.

Question 17

Views need to be designed to extract the requested information from a relational database, as efficiently as possible.

Accepted Answer

The answer of Views need to be designed to extract...

Question 18

To protect against data loss caused by a database failure, an accidental deletion, or another problem that renders the main copy of a database unusable, stringent backup procedures should be implemented.

Accepted Answer

Stringent backup procedures are essential for protecting against data loss caused by various issues.

Question 19

Data accessibility refers to protecting data against destruction and misuse-both intentional and accidental.

Accepted Answer

Data accessibility primarily refers to the ease with which data can be accessed by authorized users, not the protection of data. Protection against destruction and misuse relates more to data security and integrity.

Question 20

Object-oriented and multidimensional databases are two examples of NoSQL (Not Only SQL) databases.

Accepted Answer

Both object-oriented and multidimensional databases are considered NoSQL databases because they do not use the traditional relational data model and SQL language.

Quiz 12: Databases and Database Management Systems