Question 1

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

Accepted Answer

A DBMS is primarily used for creating, updating, and storing data, but it does not provide an integrated development environment (IDE), which is a tool used for software development.

Question 2

Because applications are often developed independently in file processing systems:

Accepted Answer

In file processing systems, applications are often developed independently, leading to unplanned duplicate data files due to lack of coordination and integration.

Question 3

With the database approach, data descriptions are stored in a central location known as a:

Accepted Answer

A repository is a central location where data descriptions, such as metadata, are stored in a database approach.

Question 4

Data that describe the properties of other data are:

Accepted Answer

Metadata is data that provides information about other data, describing its properties and characteristics.

Question 5

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

Accepted Answer

In relational databases, a "relation" is a table that includes common fields (columns) to establish relationships between different entities (tables).

Question 6

________ are established between entities in a well-structured database so that the desired information can be retrieved.

Accepted Answer

Relationships are established between entities in a well-structured database to enable the retrieval of desired information.

Question 7

Which organizational function should set database standards?

Accepted Answer

Database Administration is responsible for setting database standards as they specialize in managing and maintaining databases, ensuring consistency, security, and efficiency.

Question 8

According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than:

Accepted Answer

In 2010, global enterprises stored more than 7 billion exabytes of data, according to a McKinsey Global Institute Report.

Question 9

A user view is:

Accepted Answer

A user view is a logical description of some portion of the database, tailored to the needs of a particular user or group of users.

Question 10

Which of the following is NOT an advantage of database systems?

Accepted Answer

Redundant data is not an advantage of database systems; it is typically a disadvantage as it can lead to inconsistencies and increased storage costs.

Question 11

Program-data dependence is caused by:

Accepted Answer

The answer of Program-data dependence is caused by:
...

Question 12

A database is an organized collection of ________ related data.

Accepted Answer

A database is an organized collection of logically related data, meaning the data is structured in a way that reflects the relationships and constraints of the real-world entities it represents.

Question 13

A major difference between data warehouses and transactional systems as compared to big data is:

Accepted Answer

Big data systems often handle unstructured data, unlike traditional data warehouses and transactional systems which typically deal with structured data.

Question 14

Legacy systems often contain data of ________ quality and are generally hosted on ________.

Accepted Answer

Legacy systems often have outdated data management practices leading to poor data quality and are typically hosted on mainframes, which were the prevalent technology when these systems were developed.

Question 15

A graphical system used to capture the nature and relationships among data is called a(n):

Accepted Answer

A data model is a graphical system used to capture the nature and relationships among data.

Question 16

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

Accepted Answer

An entity is a person, place, object, event, or concept about which an organization wishes to maintain data.

Question 17

Database management involves all of the following EXCEPT:

Accepted Answer

Designing web pages is not a part of database management; it involves web development and design skills. Database management focuses on collecting, organizing, and managing data.

Question 18

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

Accepted Answer

A user view is developed by identifying the specific forms or reports that a user regularly needs, as it represents the way a user interacts with the data.

Question 19

Metatdata typically describes all of the following EXCEPT:

Accepted Answer

Metadata typically describes data definitions, length, and allowable values, but not the physical location on disk.

Question 20

________ is a tool even non-programmers can use to access information from a database.

Accepted Answer

Structured Query Language (SQL) is a tool that allows users, including non-programmers, to access and manipulate data in a database.

Quiz 1: The Database Environment and Development Process