MIS Chapter 5

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

A) Cassandra

47) ________ 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

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

A) MySQL

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

A) add a foreign key to one of the tables

18) 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

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

A) data integrity problem

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

A) database application

19) 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) recovery D) operation

A) development

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

A) file

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

A) foreign keys

34) 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 to retrieve data

A) logical representation of database data

26) Which of the following refers to the problem that exists in database applications when two users update 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

8) 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) primary record

A) primary key

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

A) records

55) Which of the following is true about the database development process? A) The database structure cannot be changed during the data modeling stage. B) Changing a relationship from 1:N to N:M is simply a matter of changing the 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.

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

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

B) DBMS

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

B) Data entry

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

B) Dynamo

15) Which of the following is a valid observation 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.

49) ________ 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

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

B) SQL Server

7) 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

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

B) data are duplicated

1) A(n) ________ is a self-describing collection of integrated records. A) cloud B) database C) storage folder D) application software

B) database

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

B) files

9) Columns that belong to a different table than the one in which they reside are called ________. A) attributes B) foreign keys C) primary keys D) internal records

B) foreign keys

38) 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

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

B) minimum

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

B) single theme

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

B) vertical bar

42) 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

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

C) SQL

56) ________ 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

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

C) byte

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

C) crow's feet

32) 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

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

C) data model

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

C) data that describe data

35) 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

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

C) foreign keys

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

C) personal

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

C) personal DBMS

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

C) query

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

D) Access

31) ________ is an example of a personal DBMS. A) SQL Server B) DB2 C) Oracle Database D) Access

D) Access

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

D) Bigtable

41) Which of the following is true of N:M relationships? A) The number of entities on each side must be equal. B) They are common examples of minimum cardinalities. 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.

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

D) attributes

53) 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

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

D) enterprise

36) 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

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

D) fields

21) 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

20) 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

16) 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

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

D) query

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

D) relationship

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

D) relationship

46) 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