MIS Ch 5

_______ is the term used to describe data collections that are characterized by huge volume, rapid velocity, and great variety. A) BigData B) NoSQL C) Dynamo D) Hadoop

A) BigData

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

A) Database design

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

A) MySQL

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

A) The easiest time to change the database structure is during the data modeling stage.

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

A) add a foreign key to one of the tables

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

A) creating and staffing the DBA function

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

A) data integrity problem

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. A) database application B) database design C) data field D) data model

A) database application

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) adaptation C) backup and recovery D) operation

A) development

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

A) file

Relational databases represent relationships using ________. A) foreign keys B) file systems C) metadata D) unique identifiers

A) foreign keys

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

A) logical representation of database data

34) Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded? A) lost-update problem B) crow's-foot paradigm C) bullwhip effect D) update query problem

A) lost-update problem

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________. A) primary key B) identifier C) foreign key D) functionally dependent record

A) primary key

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

A) records

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

B) DBMS

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

B) Dynamo

________ are used by users to read, insert, modify, and delete data in a database. A) Reports B) Forms C) Queries D) DBMS

B) Forms

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

B) It is license-free for most applications.

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

B) Normalization

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

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

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

B) data are duplicated in a database

The tables that appear in a database are known as ________. A) records B) files C) fields D) attributes

B) files

Columns that are keys to different tables than the ones in which they reside are called ________. A) attributes B) foreign keys C) primary keys D) internal records

B) foreign keys

Which of the following is used to process and display browser database application forms, reports, and queries? A) C++ B) html C) COBOL D) VisualBasic

B) html

Each entity in a database has a unique attribute called a(n) ________. A) public key B) identifier C) foreign key D) index field

B) identifier

Constraints on the number of entities in a relationship are called ________ cardinalities. A) specific B) minimum C) primary D) critical

B) minimum

Every table in a normalized database has a ________. A) one-to-one relationship between entities B) single theme C) foreign key D) specialized query format

B) single theme

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

B) vertical bar

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

C) N:M

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

C) SQL

Which of the following is true of traditional database application programs? A) Application forms, reports, and queries are displayed and processed using a browser. B) All of the application logic is contained in a program on the database server. C) They are written in object-oriented languages such as C++ and VisualBasic. D) They are thin-client applications that need not be pre-installed on the users' computers.

C) They are written in object-oriented languages such as C++ and VisualBasic.

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

C) Users

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

C) byte

In a database, ________ are grouped into columns. A) fields B) records C) bytes D) files

C) bytes

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________. A) identifiers B) foreign keys C) crow's feet D) entities

C) crow's feet

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

C) data model

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

C) data model

Metadata are ________. A) code used for server-side processing B) error logs of databases C) data that describe data D) encrypted data transmissions

C) data that describe data

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

C) entity

A database is required instead of a spreadsheet when ________. A) professionals need to keep a track of things B) a user requires control over data C) lists involve data with multiple themes D) one or more users want to access the same data

C) lists involve data with multiple themes

Browser applications are thin-client applications that ________. A) mostly display static content B) are processed using VisualBasic and C++ C) need not be pre-installed on the users' computers D) depend on internal networks and not the Internet to transmit data

C) need not be pre-installed on the users' computers

A(n) ________ is a request for data from a database. A) form B) report C) query D) application

C) query

Browser-based applications ________. A) are thick-client applications B) can only display static content C) support querying using graphics D) process queries using C++

C) support querying using graphics

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

D) Access

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

D) Bigtable

________ in an E-R diagram refer to the least number of entities required in a relationship. A) One-to-one relationships B) Primary keys C) Foreign keys D) Minimum cardinalities

D) Minimum cardinalities

Which of the following is true of single-user databases? A) They are displayed and processed using html5, css3, and JavaScript. B) They use JavaScript for user-side processing. C) The Internet is used to access the DBMS server computer. D) The application, the DBMS, and the database all reside on the user's computer.

D) The application, the DBMS, and the database all reside on the user's computer.

Which of the following is true of N:M relationships? A) They are the same as N:N relationships. B) They represent minimum cardinalities in a relationship. C) They are also called one-to-many relationships. D) They can have more than one entity on each side of the relationship.

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

Browser-based applications ________. A) need to be pre-installed on the users' computers B) run within a corporate network that is protected from the Internet C) eliminate the need to check for data consistency D) are more vulnerable to security threats than are traditional applications

D) are more vulnerable to security threats than are traditional applications

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

D) attributes

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

D) creating a table for each entity

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

D) entities

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

D) fields

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

D) managing configuration changes in systems

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) recovery C) adaptation D) operational

D) operational

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

D) processing the database

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. She should use a ________ to obtain the information that she wants from the database. A) report B) data model C) database administrative function D) query

D) query

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

D) relationship

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type? A) vertical bar B) arrow C) double line D) small oval

D) small oval

Traditional database applications programs are ________. A) browser-based and display dynamic content B) written in languages such as html5 and JavaScript C) entirely dependent on the database server for application logic D) thick applications that need to be installed on users' computers

D) thick applications that need to be installed on users' computers