MIS EXAM 2 CHAPTER 5
Which of the following is a nonrelational data store developed by Google?
A) Bigtable
A(n) ________ is a program used to create, process, and administer a database.
A) DBMS
________ are used by users to read, insert, modify, and delete data in a database.
A) Forms
________ is the process of converting a poorly-structured table into two or more well-structured tables.
A) Normalization
Which of the following is an international standard language for processing a database?
A) SQL
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.
Which of the following is true of N:M relationships?
A) They can have more than one entity on each side of the 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) Users
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) crow's feet
A data integrity problem will occur only if ________.
A) data are duplicated in a database
In a database, when data items disagree with one another, it leads to a(n) ________.
A) data integrity problem
In a data model, a(n) ________ is something that a user wants to track.
A) entity
Which of the following is used to process and display browser database application forms, reports, and queries?
A) html
A data model is a ________.
A) logical representation of database data
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
Browser applications are thin-client applications that ________.
A) need not be pre-installed on the users' computers
A(n) ________ is a request for data from a database.
A) query
The rows in a database are called ________.
A) records
In an E-R diagram, a line between two entities represents a(n) ________.
A) relationship
Browser-based applications ________.
A) support querying using graphics
In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.
A) vertical bar
Which of the following is an example of a database management system?
B) Access
Which of the following is a nonrelational data store developed by Amazon?
B) Dynamo
Which of the following is true of single-user databases?
B) The application, the DBMS, and the database all reside on the user's computer.
Which of the following is the smallest data element in a database?
B) byte
In a database, ________ are grouped into columns.
B) bytes
A primary key used in a database is a ________.
B) column or group of columns that identifies a unique row in a table
An administrator should create a ________ before developing a database design.
B) data model
A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
B) database application
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 ________.
B) entities
The columns in a database are called ________.
B) fields
Which of the following data elements is placed higher than records in the database hierarchy?
B) file
Which of the following database administration tasks is related to adaptation?
B) managing configuration changes in systems
Every table in a normalized database has a ________.
B) single theme
________ is the process of converting a data model into tables, relationships, and data constraints.
C) Database design
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.
C) N:M
Which of the following is true of traditional database application programs?
C) They are written in object-oriented languages such as C++ and VisualBasic.
When using the relational model to represent two tables, one must ________.
C) add a foreign key to one of the tables
Which of the following is a developmental task of database administration?
C) creating and staffing the DBA function
Metadata are ________.
C) data that describe data
Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.
C) development
The tables that appear in a database are known as ________.
C) files
Columns that are keys to different tables than the ones in which they reside are called ________.
C) foreign keys
The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.
C) operational
________ is the term used to describe data collections that are characterized by huge volume, rapid velocity, and great variety.
D) BigData
Which of the following is true of MySQL?
D) It is license-free for most applications.
________ in an E-R diagram refer to the least number of entities required in a relationship.
D) Minimum cardinalities
Identify the open source DBMS product among the following.
D) MySQL
Browser-based 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.
D) attributes
Identify the first step in transforming a data model into a relational database design.
D) creating a table for each entity
A ________ describes the data and relationships that will be stored in a database.
D) data model
Relational databases represent relationships using ________.
D) foreign keys
Each entity in a database has a unique attribute called a(n) ________.
D) identifier
A database is required instead of a spreadsheet when ________.
D) lists involve data with multiple themes
Constraints on the number of entities in a relationship are called ________ cardinalities.
D) minimum
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) ________.
D) primary key
When you modify or delete data present in a database, you are ________.
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.
D) query
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?
D) small oval
Traditional database applications programs are ________.
D) thick applications that need to be installed on users' computers
