MIS Ch. 5

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. The "Employee Number" column is referred to as a ________. A) primary key B) key attribute C) foreign key D) functionally dependent record

a

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

a

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

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

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

b

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

b

Heidi, an accountant, completed three mandatory training sessions in the last quarter. She needs to update her training record in the company's database. Which of the following elements will help Heidi modify her data? A) reports B) forms C) queries D) operations

b

The process of normalization constructs tables such that every table has a ________. A) one-to-one relationship between entities B) single theme C) foreign key D) specialized graphical query

b

The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed. A) consistent B) atomic C) durable D) isolated

b

Which of the following is true of MySQL? A) It is a Microsoft product. B) It is license-free for most applications. C) It is a paid and proprietary database product. D) It uses Static Query Language (SQL) to manage a database.

b

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

________ 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

n 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

Browser applications are thin-client applications that ________. A) use COBOL as the standard language for user-side processing B) are processed using VisualBasic and C++ C) need not be preinstalled on the users' computers D) depend on internal networks and not the Internet to transmit data

c

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

c

For Falcon Security, the primary purpose of creating a database of video information is to ________. A) keep track of a single theme B) eliminate concern about the lost update problem C) enable querying based on video characteristics D) avoid the use of spreadsheets

c

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

c

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

c

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

c

Ryan, a database administrator, is in the process of designing his company's database. Which of the following would Ryan have had to create before he began designing? A) data aggregator B) query model C) data model D) data application

c

The forked lines on the lines representing relationship between two related entities are referred to as ________. A) identifiers B) foreign keys C) crow's feet D) entities

c

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

c

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

c

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ________. A) lost-update problem B) crow's-foot paradigm C) bullwhip effect D) update query problem

a

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

a

Owen, the database administrator for a shipping company, is responsible for checking the data model, which is to be used in the database management system, for accuracy and completeness. This is an example of Owen's ________ tasks. A) development B) adaptation C) backup and recovery D) operation

a

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

a

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

a

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 primary keys in the model C) establish only N:M relationships between the tables D) use metadata instead of foreign keys

a

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

a

Which of the following is a developmental task of database administration? A) evaluating an application design B) monitoring backup procedures C) conducting training for users D) managing configuration changes in systems

a

Which of the following is true about the database development process? A) The database structure is easy to change during the data modeling stage. B) Changing a relationship from 1:N to N:M in an existing database is a complex and lengthy process. C) User review of the data model is avoided as it is not helpful in data modeling. D) Databases are easier to develop than spreadsheets.

a

Which of the following is true of in-memory DBMS products? A) They support or extend the relational model. B) They do not provide acid transaction support. C) They are a hotbed of development. D) MongoDB is an in-memory DBMS product.

a

Which of the following statements correctly describes the relationship between drones and videos in Falcon Security's database? A) A drone takes many videos; a video is taken by one and only one drone. B) A video is taken by many drones; a drone takes many videos. C) A video is taken by one and only one drone; a drone takes one and only one video. D) A drone takes one and only one video; a video is taken by many drones.

a

________ 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

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 complex D) there are complex relationships between entities in a database

b

A group of similar rows or records is known as ________. A) a prototype B) a file C) a field D) an attribute

b

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

b

A significant difference between using Access versus Mongo DB to store Falcon Security's video information is: A) with Mongo DB the video footage and the metadata are stored in separate databases, while in Access the video footage and the metadata are stored in the same database. B) with Mongo DB the video footage and the metadata are stored in the same database, while in Access the video footage and the metadata are stored in separate databases. C) there is no significant difference in using Access versus Mongo DB for storing Falcon's video information. D) Mongo DB cannot be used for querying because it is a NoSQL database.

b

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

b

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

Acelane Inc., unlike its competitors, procures raw material from multiple suppliers. Each supplier in turn supplies raw material to many buyers, including Acelane. This is an example of a(n) ________ relationship. A) 1:N B) 1:1 C) N:M D) M:1

c

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

c

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

A database is used instead of a spreadsheet when ________. A) lists of data involve a single theme B) structures of data lists are simple C) lists involve data with multiple themes D) users do not want to store all data in one place

c

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

c

________ 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

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, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________. A) identifiers B) records C) primary keys D) entities

d

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

Browser-based applications ________. A) need to be preinstalled 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

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

d

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

d

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

d

Samuel is the database administrator for Zimline Constructions. He determines the processing rights of employees based on their designation. Team leaders are given greater access to the database than their team members. This procedure of giving selective access is part of Samuel's ________ task. A) development B) recovery C) adaptation D) operation

d

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

d

The modification or deletion of data in a database is an example of ________ operations of a database management system. A) statistical B) analytical C) administrative D) processing

d

Traditional database application 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

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

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

d

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

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

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

d

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

d