MIS Chapter 5
A group of similar rows or records is known as _________. A prototype A table A field An attribute A cluster
A table
Which of the following is an example of a database management system? MS Excel BigData NoSQL Access MS Visio
Access
When using the relational model to represent two tables, one must ________. Add a foreign key to one of the tables Have more than two primary keys in the model Establish only N:M relationships between the tables Use metadata instead of foreign keys Minimize the number of columns in the second table
Add a foreign key to one of the tables
Browser-based applications ________. Need to be preinstalled on the users' computers Run within a corporate network that is protected from the Internet Eliminate the need to check for data consistency Are more vulnerable to security threats than are traditional applications Do not need to be encrypted
Are more vulnerable to security threats than are traditional applications
The term ________ implies that either all transactions relate to a traditional relational DBMS are processed or none of them are processed. Consistent Atomic Durable Isolated Ironic
Atomic
Which of the following is the smallest element in a database? Field Record Byte Metadata Zetta
Byte
In a database, ________ are grouped into columns. Fields Records Bytes Files Nibbles
Bytes
A primary key in a database is a ________. Group of rows that identifies a unique table or file Column or group of columns that identifies a unique row in a table Group of fields or columns that represent metadata Group of tables or files formed to identify a unique field or row Group of records that identifies similar attribute
Column or group of columns that identifies a unique row in a table
Identify the first step in transforming a data model into a relational database design. Representing the entity relationships Normalizing the data and files Creating foreign keys Create a table for each entity Creating data triggers for export
Create a table for each entity
The forked lines on the lines representing relationship between two related entities are referred to as ________. Identifiers Foreign keys Crow's feet Entities Switch
Crow's feet
A data integrity problem will occur only if ________. A database has multiple administrators Data are duplicated in a database The database is very complex There are complex relationships between entities in a database The database has too many keys
Data are duplicated in a database
In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________. Data integrity problem Crow's-foot paradigm Adaption conflict Security problem Data loopback problem
Data integrity problem
A ________ describes the data and relationships that will be stored in a database. Data aggregator Query model Data model Data application Data-tree model
Data model
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? Data aggregator Query model Data model Data application Data tunnel outlay
Data model
A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. Database application Database design Data field Data model Data bridge
Database application
________ is the process of converting a data model into tables, relationships, and data constraints. Database design Database querying Data mining Database aggregation Database cross modeling
Database design
A(n) ________ is a program used to create, process, and administer a database. Operating system Database management system Information system Database system Operating system driver
Database management system
For Falon Security, the primary purpose of creating a database of video information is to ________. Keep track of a single theme Eliminate concern about the lost update problem Enable querying based on video characteristics Avoid the use of spreadsheets Encrypt data streams
Enable querying based on video characteristics
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 ________. Identifiers Records Primary keys Entities Quarks
Entities
In a data model, a(n) ________ is something that a user wants to track. Record Byte Entity Primary key Quark
Entity
Which of the following is a developmental task of database administration? Evaluating an application design Monitoring backup procedures Conducting training for users Managing configuration changes in systems Testing backup procedures
Evaluating an application design
A DBMS and database are synonymous terms that can be used interchangeably. True False
False
A logical representation of database data, called the data model, is constructed by developers after building a database. True False
False
Browser applications are thin-clients applications that need to be preinstalled on the users' computers. True False
False
Each table in a database must have at foreign key True False
False
Managing the impact of database structural changes on applications and users is an operational task for a database administrator. True False
False
Most traditional databases use the internet to transmit traffic back and forth between the users' computer and the DBMS server. True False
False
The accuracy of a database design is not dependent on the corresponding data model. True False
False
The easiest time to change the database structure is after the data modeling stage. True False
False
The lost-update problem can be resolved by implementing single-user database processing. True False
False
The columns in a database are also called ________. Records Tables Files Fields Verticals
Fields
Which of the following data elements is placed higher than records in the database hierarchy? File Field Character Byte Bit
File
Columns that are keys to different tables than the ones in which they reside are called ________. Attributes Foreign keys Primary keys Internal records Nonlocal keys
Foreign keys
Relational databases represent relationships using _________. Foreign keys File systems Metadata Primary keys Trees
Foreign keys
Which of the following is used to process and display browser database application forms, reports, and queries? C++ HTML COBOL VisualBasic DB2
HTML
A database is used instead of a spreadsheet when ________. Lists of data involve a single theme Structures of data lists are simple Lists involve data with multiple themes Users do not want to store all data in one place Users have a small amount of data to store
Lists involve data with multiple themes
A data model is a ________. Logical representation of database data Repository of unprocessed data Collection of isolated databases Set of programs used to retrieve data Array of data variables
Logical representation of database data
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 ________. Lost-update problem Crow's-foot paradigm Bullwhip effect Update query problem Bait-and-switch problem
Lost-update problem
Which of the following database administrations tasks is related to adaption? Monitoring backup procedures Conducting training for users Monitoring database performance Managing configuration changes in systems Conducting data audit requirements
Managing configuration changes in systems
Constraints on the minimum number of entities in a relationship are called ________ cardinalities. Specific Minimum Primary Critical Plank
Minimum
________ in an E-R diagram refer to the least number of entities required in a relationship. Minimum candidate keys Primary keys Foreign keys Minimum Chernozem cardinalities
Minimum
Identify an open source DBMS product. MySQL DB2 Access Oracle Database TableOS
MySQL
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. 1:N 1:1 N:M M:1 N:1
N:M
Browser applications are thin-client applications that ________. Use COBOL as the standard language for user-side processing Are processed using VisualBasic and C++ Need not be preinstalled on the users' computer Depend on internal networks and not the internet to transmit data Do not need to be encrypted
Need not be preinstalled on the users' computer
________is the process of converting a poorly-structured table into two or more well-structured tables Optimization Normalization Refactoring Standardization Banding
Normalization
Jed is a database administrator for a mid-sized computer component manufacturer. Part of his duties include managing security, tacking problems, and monitoring the performance of the database. This is an example of Jed's ________ tasks. Development Adaption Backup and recovery Operation Data audit
Operation
Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________. Primary key Key attribute Foreign key Functionally dependent record Secondary key
Primary key
The modification or deletion of data in a database is an example of ________ operations of a database management system. Statistical Analytical Administrative Processing Technical
Processing
A(n) ________ is a request for data from a database. Form Report Query Application DB pull
Query
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. Report Data model Database administrative function Query Pull function
Query
The rows in a database are also called ________. Records Tables Files Fields Laterals
Records
In an E-R diagram, a line between two entities represents a(n) ________. Attribute Identifier Cardinality Relationship Branch
Relationship
Which of the following is an international standard language for processing a database? Cassandra DB2 SQL MS Access Relational LM
SQL
Which of the following notations is an E-R diagram means that the entity is optional and a relationship need not have an entity of the type? Vertical bar Arrow Double line Small oval Triangle
Small oval
Browser-based applications ________. Are thick-client applications Can display only static content Support graphical queries Process queries using C++ Process queries without using SQL
Support graphical queries
Which of the following is TRUE of single-user databases? They are displayed and processed using HTML5, CSS3, and JavaScript. They use JavaScript for user-side processing. The Internet is used to access the DBMS server computer. The application, the DBMS, and the database all reside on the user's computer. They run on clustered Linux or Unix systems
The application, the DBMS, and the database all reside on the user's computer.
Which of the following is TRUE of traditional database application programs? Application forms, reports, and queries are displayed and processed using a browser application. The application logic is contained in a program on the client-side computer. They are written in object-oriented languages such as C++ and VisualBasic. They are thin-client applications that need not be preinstalled on the users' computers. They are cloud-based applications that need not be preinstalled on the user's computers.
They are written in object-oriented languages such as C++ and VisualBasic.
Which of the following is TRUE of N:M relationships? They are the same as N:N relationships They represent minimum cardinalities in a relationship They are also called one-to-many relationships They can have more than one entity on each side of the relationship They connect different data types
They can have more than one entity on each side of the relationship
Which of the following is TRUE of in-memory DBMS products? They support or extend the relational model They do not provide ACID transaction support They are a hotbed of development MongoDB is an in-memory DBMS product They are low-volume, but high integrity DBMS product
They support or extend the relational model
Traditional database application programs are ________. Browser-based and display dynamic content Written in languages such as HTML5 and JavaScript Entirely dependent on the database server for application logic Thick applications that need to be installed on users' computers Cloud-based applications
Thick applications that need to be installed on users' computers
A foreign key is a key of a different (foreign) table than the one in which it resides. True False
True
A group of similar rows or records in a table is called a file. True False
True
A line in an entity-relationship (E-R) diagram is used to represent the relationship between two entities True False
True
A user must have user account credentials to access and process a database. True False
True
An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance. True False
True
Lists that involve data with multiple themes can be stored in a spreadsheet. True False
True
Locking must be used to coordinate the activities of users in order to prevent the lost-update problem. True False
True
Metadata refers to special data that describes the structure of a database. True False
True
One of the functions of a DBMS is to provide tools to assist in the administration of a database. True False
True
Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations. True False
True
SQL is an international standard language for processing a database. True False
True
The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship. True False
True
The data integrity problem occurs only if data are duplicated. True False
True
The purpose of a database is to keep track of lists of data that involve multiple themes. True False
True
To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata True False
True
________ are the final judges as to wha data the database should contain and how the records in that database should be related to one another. Administrators Developers Users Designers Auditors
Users
In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required. Small oval Vertical bar Arrow Triangular block Wave
Vertical bar
The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed. consistent atomic durable isolated iconic
atomic
Entities in a data model have ________ that describe the characteristics of the entity. characters primary keys codes attributes scribes
attributes
Metadata is/are ________. codes used for server-side processing error logs of databases data that describes data data that are encrypted more important data
data that describes data
Sonya is the database administrator for RedTriangle media. She is responsible for validating the data model to be used by the DBMS, and specifying the database requirements to endure all appropriate user input is considered. This is an example of Sonya's ________ tasks. development recovery adaptation operation data audit
development
For Falcon Security, the primary purpose of creating a database of video information is to ________. keep track of a single theme eliminate concern about the lost update problem enable querying based on video characteristics avoid the use of spreadsheets encrypt data streams
enable querying based on video characteristics
Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data? reports forms queries operations triggers
forms
Each entity in a database has a unique attribute called a(n) ________. public key identifier foreign key index field prime value
identifier
The process of normalization constructs tables such that every table has a ________. one-to-one relationship between entities single theme foreign key specialized graphical query minimized metadata footprint
single theme
A significant difference between using Access versus Mongo DB to store Falcon Security's video information is: 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 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 there is no significant difference in using Access versus Mongo DB for storing Falcon's video information Mongo DB cannot be used for querying because it is a NoSQL database Access can retrieve data more quickly than Mongo DB
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
