Question 1

The most complex type of a relationship is the__________ relationship.
A) N:1
B) N:M
C) 1:1
D) 1:N

Accepted Answer

An N:M (many-to-many) relationship is the most complex because it involves multiple records in one table being associated with multiple records in another table, requiring a junction table to manage the associations.

Question 2

A database administrator may be called a(n)__________ .
A) office of database administration
B) DA
C) DAD
D) DBA
E) DB

Accepted Answer

DBA stands for Database Administrator.

Question 3

One example of a popular DBMS is:
A) Excel
B) OEM.
C) Java.
D) SQL Server.
E).NET.

Accepted Answer

SQL Server is a popular DBMS (Database Management System).

Question 4

An entity has an unique attribute which is known as the:
A) identifier.
B) index field.
C) key attribute.
D) foreign key.

Accepted Answer

An identifier is a unique attribute that identifies each entity in a database.

Question 5

_____________is the most popular diagramming tool for database applications.
A) Workflow
B) E- R
C) UML
D) O- O

Accepted Answer

The E-R (Entity-Relationship) diagram is the most popular tool for modeling and designing database applications, as it visually represents the data and relationships between entities.

Question 6

SQL stands for:
A) Standard Query Language.
B) Structured Query Language.
C) Standard Question Language.
D) Simple Query Language.
E) Structured Question Language.

Accepted Answer

SQL stands for Structured Query Language.

Question 7

_____________is an example of a personal DBMS
A) Access
B) Oracle
C) DB2
D) SQL Server

Accepted Answer

Access is a personal DBMS designed for individual users or small groups, while Oracle, DB2, and SQL Server are enterprise-level DBMSs.

Question 8

A new information system enables user to perform in new ways, which leads to further changes in the system __________that the users couldn't visualize before.
A) indexes
B) queries
C) reports
D) forms
E) requirements

Accepted Answer

The correct choice is "requirements" because as users interact with a new system and discover new ways to perform tasks, they often identify additional needs or requirements that were not initially apparent.

Question 9

A vertical bar on a line in crow's- foot notation means that there:
A) may be more than one of the entity.
B) might be one of the entity.
C) must be one of the entity.
D) is a mistake...there should not be anything but the crow's feet.

Accepted Answer

In crow's-foot notation, a vertical bar indicates that the relationship is mandatory, meaning there must be at least one instance of the entity.

Question 10

Every normalized table has:
A) multiple topics..
B) data integrity problems.
C) a single theme.
D) duplicated data.
E) none of the above.

Accepted Answer

Normalization in database design ensures that each table has a single theme or topic, which helps eliminate redundancy and maintain data integrity.

Question 11

In a relational database, a collection of related records is a(n):
A) file.
B) application.
C) table.
D) kilobyte.
E) field.

Accepted Answer

In a relational database, a table is a collection of related records, where each record is a row in the table and each column represents a field.

Question 12

A(n) ___________ DBMS is designed to process large organizational and workgroup databases.
A) relational
B) object- oriented
C) personal
D) enterprise
E) network

Accepted Answer

An enterprise DBMS is designed to handle large-scale databases typically used by organizations and workgroups, supporting multiple users and high transaction volumes.

Question 13

A person, place or object would be represented in a database application as a(n):
A) table.
B) record.
C) class.
D) object.
E) entity.

Accepted Answer

In a database application, a person, place, or object is typically represented as an entity, which is a distinct object that can be identified and stored in the database.

Question 14

Students need to_____________ learn how to data models, because the will be asked which model best captures their world in the future.
A) process
B) update
C) interpret
D) design
E) adapt

Accepted Answer

Students need to interpret data models to understand and determine which model best captures their world.

Question 15

Databases contain:
A) Metadata.
B) Integrated records.
C) Data.
D) all of the above.
E) none of the above.

Accepted Answer

Databases contain metadata, integrated records, and data, making "all of the above" the correct choice.

Question 16

Bytes are grouped into columns, which are grouped into ______________.
A) bits
B) rows
C) files
D) fields

Accepted Answer

Bytes are grouped into columns, which are then grouped into rows in a database or spreadsheet context.

Question 17

Data entry forms:
A) add, subtract, modify, delete
B) read, insert, modify, delete
C) insert, delete, change, add
D) read, change, add, delete
E) insert, delete, add, subtract

Accepted Answer

Data entry forms typically allow users to read, insert, modify, and delete data.

Question 18

__________is used to indicate a many- to- many relationship.
A) 1:M
B) 1:1
C) M:1
D) M:N
E) N:M

Accepted Answer

The answer of __________is used to indicate a many- to-...

Question 19

Sometimes employees such as salespeople prefer not to use the centralized database application because they are unwilling to__________ their data on customer leads and contacts.
A) update
B) query
C) format
D) retrieve
E) share

Accepted Answer

Salespeople may be unwilling to share their data on customer leads and contacts due to concerns about competition, privacy, or losing control over their information.

Question 20

The most important point to keep in mind when debating which data model is the best one is how well it reflects how the view _____________their world.
A) executives
B) users
C) employees
D) data administrators
E) modelers

Accepted Answer

The best data model should accurately reflect how users view their world, as they are the ones who will interact with and rely on the data for their needs and tasks.

Quiz 5: Database Processing

The most complex type of a relationship is the__________ relationship.

A database administrator may be called a(n) __________ .

One example of a popular DBMS is:

An entity has an unique attribute which is known as the:

_____________is the most popular diagramming tool for database applications.

SQL stands for:

_____________is an example of a personal DBMS

A new information system enables user to perform in new ways, which leads to further changes in the system __________that the users couldn't visualize before.

A vertical bar on a line in crow's- foot notation means that there:

Every normalized table has:

In a relational database, a collection of related records is a(n) :

A(n) ___________ DBMS is designed to process large organizational and workgroup databases.

A person, place or object would be represented in a database application as a(n) :

Students need to_____________ learn how to data models, because the will be asked which model best captures their world in the future.

Databases contain:

Bytes are grouped into columns, which are grouped into ______________.

Data entry forms:

__________is used to indicate a many- to- many relationship.

Sometimes employees such as salespeople prefer not to use the centralized database application because they are unwilling to__________ their data on customer leads and contacts.

The most important point to keep in mind when debating which data model is the best one is how well it reflects how the view _____________their world.