Quiz 1

Unified Modeling Language (UML) has quickly replaced the E-R Model as the most popular technique for creating data models. True or False

False

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: MST. RAD. CASE. CAD.

RAD.

A relational database stores data in the form of ---------------------------- lists forms columns tables spreadsheets

Tables

The DBMS is used to create the database itself. True or False

True

The ideal primary key is short, numeric, and nonchanging. True or False

True

The purpose of a database is to help people keep track of things. True or False

True

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released. exclusive lock authorization rule record controller Two-phase lock

Two-phase lock

A data mart is a(n): enterprise wide data warehouse. data warehouse that is limited in scope. smaller system built upon file processing technology. generic on-line shopping site.

data warehouse that is limited in scope.

A database may be used to help people with all of the following EXCEPT.... track which student is assigned to a particular advisor. know the current inventory levels of products their company sells. check on the estimated arrival time of an incoming flight at an airport. look up their checking account balance over the Internet. debug existing program code.

debug existing program code

Big data: does not require a strictly defined data model. requires a strictly defined schema. requires a normalized dataset to BCNF. requires a normalized dataset to 3rd Normal Form.

does not require a strictly defined data model.

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked. authorization rule record controller shared lock exclusive lock

exclusive lock

The SDLC phase in which database processing programs are created is the ________ phase. planning design analysis implementation

implementation

The SDLC phase in which database processing programs are created is the ________ phase. planning design analysis implementation

implementation

Big Data includes: large volumes of data with many different data types that are processed at very high speeds. large volumes of entity relationship diagrams (ERD) with many different data types that are processed at very high speeds. large volumes of data entry with a single data type processed at very high speeds. large volumes of entity relationship diagrams (ERD) with a single data type processed at very high speeds.

large volumes of data with many different data types that are processed at very high speeds.

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): database management system. data warehouse. index. repository

repository

A surrogate key should be considered when _____________________ a relationship is M:N. a composite key is required. the key contains a lengthy text field. the key contains a number. an index needs to be created.

the key contains a lengthy text field.

Forward recovery is faster than restore/rerun because: transactions do not have to be repeated. images are mirrored. security can be avoided. systems are more complete.

transactions do not have to be repeated.

Forward recovery is faster than restore/rerun because: transactions do not have to be repeated. images are mirrored. security can be avoided. systems are more complete.

transactions do not have to be repeated.

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released. exclusive lock. authorization rule. record controller. two-phase lock.

two-phase lock.

A relatively small team of people who collaborate on the same project is called a: server group. data collaborative. workgroup. typical arrangement.

workgroup.

A -------------------------- is a set of one or more computer programs that serves as an intermediary between the user and the DBMS. Microsoft Excel Spreadsheets Database application DBMS SQL Microsoft Access 2016

Database application

Which of the following terms is synonymous with 'tuple'? Attribute Table Field Row Relation

Row

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business. Systems analysts Users Database analysts Programmers

Systems analysts

A possible problem with keeping data in lists is that if you delete a row of data from a list, you may also delete some data items that you want to keep. True or False

True

A surrogate key is appropriate when the primary key of a table contains a lengthy text field. True or False

True

What role does the Web browser play in a Web database application? Hardware Support Microchip accelerator Web user interface Back-end Database Management System Bug-reporting System

Web user interface

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase. planning design analysis implementation

analysis

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase. planning design analysis implementation

analysis