Question 1

In database terms, what is the analogy to an ordinary paper file you might keep in a file cabinet or an accounting ledger?
A) database
B) spreadsheet
C) data file
D) attribute

Accepted Answer

An ordinary paper file or accounting ledger can be thought of as a data file in a database. This file contains information or data that can be sorted, searched, or analyzed in various ways. Similarly, a data file in a database contains structured data that can be queried or processed using database management systems. Choices A, B, and D refer to other database concepts such as the entire collection of data, a type of data organization, and a characteristic of data, respectively.

Question 2

Users never interact with a database directly; database interaction is always through the DBMS.

Accepted Answer

Users always interact with a DBMS, which then communicates with the database. Direct interaction with the database is not possible without going through the DBMS.

Question 3

Increased complexity is one advantage of database processing.

Accepted Answer

Increased complexity is generally considered a disadvantage of database processing, as it requires more specialized skills and resources to manage and maintain.

Question 4

An attribute is known as a row in most databases.

Accepted Answer

An attribute is known as a column in most databases, not a row. A row is also known as a record or tuple.

Question 5

The relationship between different entities (in different tables) is handled by their common columns.

Accepted Answer

The common column(s) between tables is used to establish a relationship between them in a relational database. This allows for efficient retrieval and manipulation of data across multiple tables.

Question 6

If a user is authorized to access database data, the user will always be able to make changes to the data.

Accepted Answer

Being authorized to access database data does not necessarily grant the user permissions to modify the data; read-only access is a common restriction.

Question 7

Which aspect of an entity becomes the columns in the database table?
A) attributes
B) relationships
C) data files
D) E-R diagrams

Accepted Answer

Attributes define the characteristics of an entity and become the columns in a database table. Relationships, data files, and E-R diagrams do not directly determine the columns in a table.

Question 8

Which database term is a person, place, object, event, or idea for which you want to store and process data?
A) attribute
B) DBMS
C) entity
D) DBA

Accepted Answer

An entity is a person, place, object, event, or idea for which you want to store and process data in a database. It represents a table in a relational database and each entity has attributes that provide more information about the entity. A DBMS (B) is a software system that manages the storage and retrieval of data in a database. An attribute (A) is a characteristic or property of an entity and a DBA (D) is a database administrator who is responsible for overseeing the management of a database.

Question 9

A spreadsheet is a screen object used to maintain and view data from a database.

Accepted Answer

A spreadsheet is a screen object used to maintain and view data in a grid-like structure, not necessarily from a database.

Question 10

A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.

Accepted Answer

A database is designed to hold information about multiple types of entities and their relationships. This is achieved through the use of relational database management systems (RDBMS), which allow for the creation of tables that are linked to one another through keys or relationships. By storing information in this way, a database can provide a comprehensive view of an organization's operations and help decision-makers to make more informed choices.

Question 11

Which term can be described as the duplication of data and storing it in multiple locations?
A) data independence
B) redundancy
C) data integrity
D) security

Accepted Answer

Redundancy refers to the duplication of data and storing it in multiple locations, which can improve data availability and fault tolerance in case of system failures or disasters. Data independence refers to the separation of applications and data storage, allowing changes to be made in one without affecting the other. Data integrity refers to the accuracy and consistency of data, while security refers to the protection of data from unauthorized access or malicious attacks.

Question 12

An entity is a person, place, object, event, or idea for which you want to store and process data.

Accepted Answer

An entity can be any of the mentioned things for which data is to be stored and processed.

Question 13

Which of the following is called a field or column in many database systems?
A) attribute
B) entity
C) data file
D) relationship

Accepted Answer

A field or column in a database system is commonly referred to as an attribute. An entity represents a distinct object or concept in a database, a data file is a collection of related data records, and a relationship defines how entities are related.

Question 14

Each table in a database represents two or more entities.

Accepted Answer

Each table in a database typically represents a single entity, and the columns in the table represent attributes or properties of that entity.

Question 15

There is a greater impact of failure in a nondatabase, file-oriented system.

Accepted Answer

The answer of There is a greater impact of failure...

Question 16

A client is an example of an attribute.

Accepted Answer

A client is a party that interacts with a system, not an attribute of the system itself. Attributes are characteristics or properties of a system or object.

Question 17

An advantage of using the database approach to processing is that it facilitates consistency.

Accepted Answer

The database approach to processing ensures that data is consistent across all records and prevents data duplication or conflicting information. This is achieved through the use of data normalization and data validation techniques.

Question 18

Programs created with Visual Basic, Java, Perl, PHP, or C++ can interact with the database directly.

Accepted Answer

The answer of Programs created with Visual Basic, Java, Perl,...

Question 19

Redundancy wastes space because you are storing multiple copies of the same data.

Accepted Answer

Redundancy refers to the practice of storing multiple copies of the same data. This takes up additional storage space that could be used for other data. Therefore, the statement is true.

Question 20

Redundancy makes changing data more cumbersome and time-consuming.

Accepted Answer

Redundancy means the same information is stored in multiple places, which can make it more difficult to update or change the data consistently across all locations, thus making it more cumbersome and time-consuming.

Quiz 1: Introduction to Database Management

In database terms, what is the analogy to an ordinary paper file you might keep in a file cabinet or an accounting ledger?