Question 1

The ____ assigned to a user indicate which parts of the database the user can view, modify, or delete.
A) permissions
B) controls
C) locks
D) attributes

Accepted Answer

Permissions are access rights granted to a user that indicates which parts of the database the user can view, modify, or delete. Controls refer to tools or mechanisms used to manage and regulate access to the database. Locks are used to prevent concurrent access to a specific part of the database. Attributes are characteristics of data that describe its properties.

Question 2

A table that contains repeating groups is ____.
A) unnormalized
B) normalized
C) simplified
D) non-normalized

Accepted Answer

A table that contains repeating groups violates the First Normal Form (1NF) of relational database design, and is therefore unnormalized.

Question 3

A(n) ____ key is a column that is not a key in a table, but it contains an attribute that is a key in a related table.
A) alternate
B) candidate
C) foreign
D) primary

Accepted Answer

A foreign key is a column that contains a key from a related table, establishing a connection between the two tables.

Question 4

A primary key should be ____________________, meaning that a value does not change during normal operation.

Accepted Answer

The answer of A primary key should be ____________________, meaning...

Question 5

A ____________________ is a binary large object, which is a collection of binary data such as an image, video, or audio clip stored in a database system.

Accepted Answer

The answer of A ____________________ is a binary large object,...

Question 6

A ____ relationship is the most common type of relationship between tables.
A) one-to-many
B) one-to-one
C) many-to-one
D) many-to-many

Accepted Answer

A one-to-many relationship is the most common type of relationship between tables. In this type of relationship, one record in the first table can be related to many records in the second table, but each record in the second table can only be related to one record in the first table. This is a common relationship seen in databases where one record in a main table (such as a customer) can be related to many records in a secondary table (such as orders).

Question 7

A transitive ____ occurs when the value of a nonkey attribute determines, or predicts, the value of another nonkey attribute.
A) conversion
B) recursion
C) dependency
D) anomaly

Accepted Answer

This is the definition of a transitive dependency, which occurs when the value of one nonkey attribute determines the value of another nonkey attribute. This can cause data redundancy and potential inconsistencies in the database if not handled properly. Choices A, B, and D are not directly related to this concept.

Question 8

To ____ a table is to reduce it to a lower normal form by placing some repeated information back into the table.
A) denormalize
B) normalize
C) flatten
D) compose

Accepted Answer

To denormalize a table is to reduce it to a lower normal form by placing some repeated information back into the table.

Question 9

____ is the unnecessary repetition of data.
A) Data duplication
B) Data replication
C) Data normalization
D) Data redundancy

Accepted Answer

Data redundancy refers to the unnecessary duplication of data, which can lead to inconsistencies and inefficiencies in data management.

Question 10

____________________ are composed of associated records.

Accepted Answer

The answer of ____________________ are composed of associated records....

Question 11

____________________ are formed from groups of related fields.

Accepted Answer

The answer of ____________________ are formed from groups of related...

Question 12

A ____ is a subset of rows in a database table that all depend on the same key.
A) complete group
B) flattened group
C) repeating group
D) normalized group

Accepted Answer

A repeating group is a subset of rows in a database table that all depend on the same key, often used to represent multiple values for a single attribute.

Question 13

____ is the process of coding data into a format that human beings cannot read.
A) Integrity
B) Encoding
C) Encryption
D) RFID

Accepted Answer

Encryption is the process of converting data into a code so that it cannot be read by unauthorized users. It is a security measure that helps protect sensitive information from being accessed by hackers or other unauthorized users.

Question 14

Database developers also refer to operations or transactions as ____ transactions when they appear to execute completely or not at all.
A) coupled
B) atomic
C) decoupled
D) nominal

Accepted Answer

Atomic transactions refer to transactions that are indivisible and either execute completely or not at all. This ensures data consistency and integrity in the database. Coupled transactions refer to transactions that are dependent on each other, decoupled transactions refer to transactions that are independent of each other, and nominal transactions do not have a clear definition in the context of databases.

Question 15

When you combine two columns to create a compound key, you are ____ the columns.
A) splitting
B) converting
C) joining
D) concatenating

Accepted Answer

When you combine two columns to create a compound key, you are concatenating the columns.

Question 16

A ____ is a mechanism that prevents changes to a database for a period of time.
A) flag
B) lock
C) permission
D) transaction

Accepted Answer

A lock is a mechanism used to prevent changes to a database for a period of time. It is commonly used in multi-user environments to ensure that two or more users cannot make conflicting changes to the same data simultaneously. A flag is a variable or indicator that is used to signal a certain condition or state. Permissions and transactions are also components of database management systems, but they do not directly prevent changes to a database for a period of time.

Question 17

A(n) ____________________ is a long-term database lock required when users want to maintain a consistent view of their data while making modifications over a long transaction.

Accepted Answer

The answer of A(n) ____________________ is a long-term database lock...

Question 18

A database has ____ when it follows a set of rules that makes the data accurate and consistent.
A) transparent integrity
B) data availability
C) data integrity
D) data security

Accepted Answer

Data integrity refers to the accuracy and consistency of data in a database, achieved through a set of rules and procedures that ensure data is reliable and free from errors. Transparent integrity is not a commonly used term in database management, data availability refers to the accessibility of data, and data security refers to protecting data from unauthorized access and data loss.

Question 19

____ techniques include storing and verifying passwords or even using physical characteristics, such as fingerprints or voice recognition, before users can view data.
A) Authorization
B) Data conversion
C) Data normalization
D) Authentication

Accepted Answer

Authentication techniques are used to verify that users are who they claim to be before giving them access to data. This can be done through methods such as password verification or biometric authentication, including fingerprints or voice recognition. Authorization, data conversion, and data normalization are not directly related to user authentication.

Question 20

An ____ is an irregularity in a database's design that causes problems and inconveniences.
A) inversion
B) inference
C) anomaly
D) abstraction

Accepted Answer

An anomaly is a deviation from the expected or normal behavior in a database, which can lead to inconvenience and problems when using it. Inversions, inferences, and abstractions are not related to database design irregularities.

Quiz 14: Using Relational Databases

The ____ assigned to a user indicate which parts of the database the user can view, modify, or delete.

A table that contains repeating groups is ____.

A(n) ____ key is a column that is not a key in a table, but it contains an attribute that is a key in a related table.

A primary key should be ____________________, meaning that a value does not change during normal operation.

A ____________________ is a binary large object, which is a collection of binary data such as an image, video, or audio clip stored in a database system.

A ____ relationship is the most common type of relationship between tables.

A transitive ____ occurs when the value of a nonkey attribute determines, or predicts, the value of another nonkey attribute.

To ____ a table is to reduce it to a lower normal form by placing some repeated information back into the table.

____ is the unnecessary repetition of data.

____________________ are composed of associated records.

____________________ are formed from groups of related fields.

A ____ is a subset of rows in a database table that all depend on the same key.

____ is the process of coding data into a format that human beings cannot read.

Database developers also refer to operations or transactions as ____ transactions when they appear to execute completely or not at all.

When you combine two columns to create a compound key, you are ____ the columns.

A ____ is a mechanism that prevents changes to a database for a period of time.

A(n) ____________________ is a long-term database lock required when users want to maintain a consistent view of their data while making modifications over a long transaction.

A database has ____ when it follows a set of rules that makes the data accurate and consistent.

____ techniques include storing and verifying passwords or even using physical characteristics, such as fingerprints or voice recognition, before users can view data.

An ____ is an irregularity in a database's design that causes problems and inconveniences.