BCIS Quiz 5

In a data model, a(n) ________ is something that a user wants to track.

A) byte
B) record
C) entity
D) primary key

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) adaptation
B) recovery
C) operation
D) development

A ________ is a collection of forms, reports, queries, and programs that process a database.

A) data model
B) database application
C) data field
D) database design

From among the following, identify the open source DBMS product.

A) Oracle Database
B) MySQL
C) Access
D) DB2

Which of the following types of DBMS products is designed for smaller and simpler database applications?

A) personal DBMS
B) strategic DBMS
C) object-oriented DBMS
D) enterprise DBMS

Which of the following is a nonrelational data store developed by Amazon?

A) Dynamo
B) Bigtable
C) Cassandra
D) SharePoint

A(n) ________ is a program used to create, process, and administer a database.

A) DBMS
B) data mart
C) KMS
D) operating system

________ is an example of a personal DBMS.

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

When you modify or delete data present in a database, you are ________.

A) creating a new database
B) forming a data model
C) processing the database
D) simplifying the data structure

In a database, when data items disagree with one another, this leads to a(n) _______.

A) crow's-foot paradigm
B) data integrity problem
C) adaptation conflict
D) lost-update problem

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) entities
C) identifiers
D) records

A ________ is a request for data from a database.

A) command
B) query
C) report
D) data entry

Which of the following data elements is placed higher than records in the data hierarchy?

A) file
B) character
C) byte
D) field

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

A) process
B) enterprise
C) personal
D) operational

A data integrity problem will occur only if ________.

A) data are duplicated
B) there are complex relationships
C) the database is very large
D) there are multiple administrators

Which of the following is a nonrelational data store developed by Google?

A) Cassandra
B) SharePoint
C) Bigtable
D) Dynamo

Which of the following is the smallest data element in a database?

A) byte
B) field
C) file
D) record

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 dentifies a unique row in a table

Which of the following is a valid observation of MySQL?


A) It is a closed-source database product.
B) It is license-free for most applications.
C) It is offered by Oracle.
D) It is yet to be widely adopted.

The purpose of a(n) ________ is to keep track of things.

A) database
B) storage folder
C) cloud
D) application software

Which of the following is an example of an enterprise DBMS?

A) Access
B) Paradox
C) SQL Server
D) FoxPro

Which of the following is true about the database development process?

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

Entities in a data model have ________ that describe the characteristics of the entity.

A) characters
B) codes
C) primary keys
D) attributes

A database design team transforms entities into tables and expresses relationships by defining ________.

A) cardinalities
B) attributes
C) departments
D) foreign keys

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) report
B) query
C) reference
D) data entry

Identify the first step in transforming a data model into a relational database design.

A) normalizing the data and files
B) representing the data relationships
C) creating foreign keys
D) creating a table for each entity

A ________ describes the data and relationships that will be stored in a database.

A) data aggregator
B) query model
C) data model
D) data application

Which of the following database administration tasks is related to adaptation?

A) monitoring backup procedures
B) monitoring database performance
C) conducting training for users
D) managing configuration changes in systems

________ is the process of converting a data model into tables, relationships, and data constraints.

A) Data mining
B) Database aggregation
C) Database design
D) Database querying

When using the relational model to represent data, one must ________.

A) have more than ten tables in the model
B) add a foreign key to one of the tables
C) establish only N:M relationships between tables
D) use metadata instead of foreign keys

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

A) vertical bar
B) arrow
C) small oval
D) triangular block

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) N:M
B) M:1
C) 1:1
D) 1:N

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) enterprise
B) personal
C) open source
D) interenterprise

The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

A) development
B) operational
C) adaptation
D) recovery

A data model is a ________.

A) set of programs to retrieve data
B) repository of unprocessed data
C) logical representation of database data
D) collection of isolated databases

Every table in a normalized database has ________.

A) maximum cardinality
B) single theme
C) specialized query format
D) duplicated data model

Which of the following is true of N:M relationships?

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

Which of the following is a nonrelational data store developed by Facebook?

A) Dynamo
B) Cassandra
C) SharePoint
D) Bigtable

________ forms are used to read, insert, modify, and delete data.

A) Reporting
B) Query
C) Data entry
D) Request

Metadata are ________.

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

The rows in a database are called ________.

A) files
B) records
C) tables
D) fields

Which of the following is an example of a database management system?

A) Access
B) MS Excel
C) Unix
D) Ubuntu

The forked lines on the right side of a line on an diagram that indicates a 1:N relationship between two entities is referred to as ________.

A) crow's feet
B) maximum cardinality
C) minimum cardinality
D) Kerberos

An administrator should create ________ before developing a database design.

A) query model
B) data aggregator
C) data model
D) data application

Which of the following is a developmental task of database administration?

A) creating and staffing the DBA function
B) conducting training for users
C) monitoring backup procedures
D) managing configuration changes in systems

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n) ________.

A) attribute
B) relationship
C) database
D) department

________ 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) Users
B) Administrators
C) Designers
D) Developers