A Data Integrity Problem Will Occur Only If ________.

A ________ is a collection of forms, reports, queries, and programs that process a database.
A) database design
B) data field
C) data model
D) database application

D) database application

The forked lines on the right side of a line on an E-R diagram that indicates a 1:N relationship between two entities is referred to as ________.
A) minimum cardinality
B) crow's feet
C) Kerberos
D) maximum cardinality

B) crow's feet

A) Oracle Database
B) SQL Server
C) DB2
D) Access

D) Access

________ forms are used to read, insert, modify, and delete data.
A) Query
B) Reporting
C) Request
D) Data entry

D) Data entry

Which of the following is true of N:M relationships?
A) They are common examples of minimum cardinalities.
B) The number of entities on each side must be equal.
C) They can have more than one entity on each side of the relationship.
D) They are also called one-to-many relationships.

C) They can have more than one entity on each side of the relationship.

________ is the process of converting a poorly- structured table into two or more well-structured tables.
A) Normalization
B) Standardization
C) Refactoring
D) Optimization

A) Normalization

Which of the following database administration tasks is related to adaptation?
A) monitoring database performance
B) managing configuration changes in systems
C) monitoring backup procedures
D) conducting training for users

B) managing configuration changes in systems

Which of the following is an example of an enterprise DBMS?
A) Access
B) SQL Server
C) Paradox
D) FoxPro

B) SQL Server

Identify the first step in transforming a data model into a relational database design.
A) creating a table for each entity
B) normalizing the data and files
C) representing the data relationships
D) creating foreign keys

A) creating a table for each entity

From among the following, identify the open source DBMS product.
A) Oracle Database
B) Access
C) MySQL
D) DB2

C) MySQL

A student management system allows students to have multiple majors and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.
A) M:1
B) 1:1
C) N:M
D) 1:N

...

A ________ is a request for data from a database.
A) report
B) query
C) command
D) data entry

B) query

When using the relational model to represent data, one must ________.
A) use metadata instead of foreign keys
B) establish only N:M relationships between tables
C) add a foreign key to one of the tables
D) have more than ten tables in the model

C) add a foreign key to one of the tables

A data model is a ________.
A) logical representation of database data
B) set of programs to retrieve data
C) repository of unprocessed data
D) collection of isolated databases

A) logical representation of database data

In a database, when data items disagree with one another, this leads to a(n) ________.
A) data integrity problem
B) lost-update problem
C) crow's-foot paradigm
D) adaptation conflict

A) data integrity problem

Which of the following types of DBMS products is designed for smaller and simpler database applications?
A) strategic DBMS
B) object-oriented DBMS
C) personal DBMS
D) enterprise DBMS

C) personal DBMS

A data integrity problem will occur only if ________.
A) there are multiple administrators
B) data are duplicated
C) there are complex relationships
D) the database is very large

B) data are duplicated

Entities in a data model have ________ that describe the characteristics of the entity.
A) characters
B) attributes
C) codes
D) primary keys

B) attributes

Which of the following data elements is placed higher than records in the data hierarchy?
A) file
B) byte
C) field
D) character

A) file

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.
A) development
B) recovery
C) operation
D) adaptation

A) development

A(n) ________ DBMS is designed to process large organizational and workgroup databases.
A) operational
B) enterprise
C) process
D) personal

B) enterprise

Which of the following is a nonrelational data store developed by Facebook?
A) Dynamo
B) Bigtable
C) Cassandra
D) SharePoint

C) Cassandra

A primary key used in a database is a ________.
A) column or group of columns that identifies a unique row in a table
B) character or byte that represents fields or columns
C) group of tables or files formed to identify a unique field or row
D) group of rows that are formed to identify a unique table or file

A) column or group of columns that identifies a unique row in a table

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n) ________.
A) relationship
B) database
C) attribute
D) department

A) relationship

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.
A) primary keys
B) records
C) identifiers
D) entities

D) entities

Which of the following is an international standard language for processing a database?
A) Paradox
C) DB2
D) MS Access

B) SQL

Every table in a normalized database has ________.
A) single theme
B) maximum cardinality
C) specialized query format
D) duplicated data model

A) single theme

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.
A) triangular block
B) vertical bar
C) small oval
D) arrow

B) vertical bar

A(n) ________ is a program used to create, process, and administer a database.
A) DBMS
B) operating system
C) data mart
D) KMS

A) DBMS

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.
A) data entry
B) report
C) reference
D) query

D) query

Which of the following is a nonrelational data store developed by Amazon?
A) Cassandra
B) SharePoint
C) Dynamo
D) Bigtable

C) Dynamo

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n) ________.
A) department
B) relationship
C) attribute
D) database

B) relationship

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.
A) Developers
B) Designers
C) Users
D) Administrators

C) Users

Which of the following is a valid observation of MySQL?
A) It is yet to be widely adopted.
B) It is license-free for most applications.
C) It is offered by Oracle.
D) It is a closed-source database product.

B) It is license-free for most applications.

An organization buys a proprietary database application to be used by a small workgroup of five people. This is an example of a(n) ________ DBMS.
A) open source
B) enterprise
C) personal
D) interenterprise

C) personal

Which of the following is an example of a database management system?
A) MS Excel
B) Access
C) Ubuntu
D) Unix

B) Access

A ________ describes the data and relationships that will be stored in a database.
A) data aggregator
B) query model
C) data application
D) data model

D) data model

In an E-R diagram, a line between two entities represents a(n) ________.
A) identifier
B) relationship
C) attribute
D) cardinality

B) relationship

The purpose of a(n) ________ is to keep track of things.
A) storage folder
B) application software
C) cloud
D) database

D) database

Metadata are ________.
A) encrypted data transmissions
B) data stored on the main server
C) data that describe data
D) error logs of databases

C) data that describe data

________ is a request for data from a database.
A) data entry
B) command
C) report
D) query

D) query

________ is the process of converting a data model into tables, relationships, and data constraints.
A) Database querying
B) Database aggregation
C) Data mining
D) Database design

D) Database design

A) entities

Which of the following is a nonrelational data store developed by Google?
A) SharePoint
B) Cassandra
C) Bigtable
D) Dynamo

C) Bigtable

The forked lines on the right side of a line on an E-R diagram that indicates a 1:N relationship between two entities is referred to as ________.
A) minimum cardinality
B) maximum cardinality
C) crow's feet
D) Kerberos

C) crow's feet

________ forms are used to read, insert, modify, and delete data.
A) Data entry
B) Query
C) Request
D) Reporting

A) Data entry

When using the relational model to represent data, one must ________.
A) establish only N:M relationships between tables
B) use metadata instead of foreign keys
C) have more than ten tables in the model
D) add a foreign key to one of the tables

D) add a foreign key to one of the tables

The rows in a database are called ________.
A) tables
B) records
C) fields
D) files

B) records

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.
A) development
B) operation
C) recovery
D) adaptation

A) development

From among the following, identify the open source DBMS product.
A) DB2
B) MySQL
C) Oracle Database
D) Access

B) MySQL

Which of the following data elements is placed higher than records in the data hierarchy?
A) byte
B) character
C) field

D) file

Which of the following is an example of an enterprise DBMS?
A) FoxPro
B) SQL Server
C) Paradox
D) Access

B) SQL Server

Which of the following is true about the database development process?
A) User review of the data model is avoided as it is not helpful in data modeling.
B) A database is a model of how the developers view their business world.
C) Changing a relationship from 1:N to N:M is simply a matter of changing the notations.
D) The database structure cannot be changed during the data modeling stage.

C) Changing a relationship from 1:N to N:M is simply a matter of changing the notations.

A primary key used in a database is a ________.
A) column or group of columns that identifies a unique row in a table
B) group of rows that are formed to identify a unique table or file
C) group of tables or files formed to identify a unique field or row
D) character or byte that represents fields or columns

A) column or group of columns that identifies a unique row in a table

Which of the following is the smallest data element in a database?
A) byte
B) field
C) file
D) record

A) byte

A data integrity problem will occur only if ________.
A) there are complex relationships
B) there are multiple administrators
C) the database is very large
D) data are duplicated

D) data are duplicated

Entities in a data model have ________ that describe the characteristics of the entity.
A) characters
B) codes
C) attributes
D) primary keys

C) attributes

A data model is a ________.
A) set of programs to retrieve data
B) logical representation of database data
C) collection of isolated databases
D) repository of unprocessed data

B) logical representation of database data

Every table in a normalized database has ________.
A) specialized query format
B) maximum cardinality
C) duplicated data model
D) single theme

D) single theme

Which of the following is a nonrelational data store developed by Facebook?
A) Bigtable
B) SharePoint
C) Cassandra
D) Dynamo

C) Cassandra

Which of the following is a nonrelational data store developed by Facebook?
A) Dynamo
B) SharePoint
C) Cassandra
D) Bigtable

C) Cassandra

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.
A) Designers
B) Administrators
C) Users
D) Developers

C) Users

A primary key used in a database is a ________.
A) character or byte that represents fields or columns
B) group of tables or files formed to identify a unique field or row
C) group of rows that are formed to identify a unique table or file
D) column or group of columns that identifies a unique row in a table

D) column or group of columns that identifies a unique row in a table

Which of the following is a valid observation of MySQL?
A) It is license-free for most applications.
B) It is a closed-source database product.
C) It is yet to be widely adopted.
D) It is offered by Oracle.

A) It is license-free for most applications.

The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.
A) adaptation
B) operational
C) recovery
D) development

B) operational

An administrator should create ________ before developing a database design.
A) data aggregator
B) data model
C) query model
D) data application

B) data model

In a data model, a(n) ________ is something that a user wants to track.
A) byte
B) record
C) entity
D) primary key

C) entity

Which of the following database administration tasks is related to adaptation?
A) monitoring database performance
B) managing configuration changes in systems
C) conducting training for users
D) monitoring backup procedures

B) managing configuration changes in systems

A ________ is a collection of forms, reports, queries, and programs that process a database.
A) database design
B) database application
C) data model
D) data field

B) database application

When you modify or delete data present in a database, you are ________.
A) simplifying the data structure
B) creating a new database
C) forming a data model
D) processing the database

D) processing the database

C) add a foreign key to one of the tables

In a database, when data items disagree with one another, this leads to a(n) ________.
A) crow's-foot paradigm
B) lost-update problem
C) adaptation conflict
D) data integrity problem

D) data integrity problem

Which of the following types of DBMS products is designed for smaller and simpler database applications?
A) strategic DBMS
B) object-oriented DBMS
C) enterprise DBMS
D) personal DBMS

D) personal DBMS

A data model is a ________.
A) set of programs to retrieve data
B) logical representation of database data
C) repository of unprocessed data
D) collection of isolated databases

B) logical representation of database data

The purpose of a(n) ________ is to keep track of things.
A) cloud
B) application software
C) database
D) storage folder

C) database

A ________ describes the data and relationships that will be stored in a database.
A) data model
B) data aggregator
C) query model
D) data application

A) data model

From among the following, identify the open source DBMS product.
A) Access
B) Oracle Database
C) DB2
D) MySQL

D) MySQL

A(n) ________ DBMS is designed to process large organizational and workgroup databases.
A) enterprise
B) personal
C) operational
D) process

A) enterprise

Metadata are ________.
A) encrypted data transmissions
B) data stored on the main server
C) error logs of databases
D) data that describe data

D) data that describe data

A ________ is a request for data from a database.
A) query
B) command
C) data entry

A) query

A database design team transforms entities into tables and expresses relationships by defining ________.
A) foreign keys
B) departments
C) attributes
D) cardinalities

A) foreign keys

________ is the process of converting a poorly- structured table into two or more well-structured tables.
A) Refactoring
B) Standardization
C) Optimization
D) Normalization

D) Normalization

Which of the following is true of N:M relationships?
A) They can have more than one entity on each side of the relationship.
B) They are common examples of minimum cardinalities.
C) The number of entities on each side must be equal.
D) They are also called one-to-many relationships.

A) They can have more than one entity on each side of the relationship.

Every table in a normalized database has ________.
A) duplicated data model
B) specialized query format
C) maximum cardinality
D) single theme

D) single theme

B) N:M

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n) ________.
A) attribute
B) database
C) department
D) relationship

D) relationship

Which of the following is a developmental task of database administration?
A) conducting training for users
B) monitoring backup procedures
C) creating and staffing the DBA function
D) managing configuration changes in systems

C) creating and staffing the DBA function