Chapter 5

________ is a popular enterprise database management system (DBMS) product from IBM. DB2 Access SQL Server MySQL

DB2

Which of the following is a nonrelational data store developed by Amazon.com? Bigtable Dynamo Cassandra MongoDB

Dynamo

________ are browser-based queries that are created when a user clicks on a graphic. Graphical queries Application programs User reports Databases

Graphical queries

Why don't many new Internet applications need ACID (atomic, consistent, isolated, durable) transactions? Because what is stored today must be stored tomorrow. Because transactions have to be processed in the same manner. Internet applications do not necessarily have to store all of a transaction. Because once a transaction is stored, it never goes away.

Internet applications do not necessarily have to store all of a transaction.

Which of the following best describes a byte in a database? It is a character of data. It is a group of rows. It is a collection of data. It is a group of columns.

It is a character of data.

Which of the following is TRUE of the relational database processing model? It supports very high transaction rates. It can efficiently store files with large collections of bits. It helps organizations store new data types such as images, audio, and videos. It represents relationships with the help of foreign keys.

It represents relationships with the help of foreign keys.

________ is an example of metadata. Name: Josh White Date: 01/01/2020 Message: Long Text Student Number: 125962

Message: Long Text

Access and SQL Server are popular ________ DBMS products. open source IBM Oracle Corporation Microsoft

Microsoft

Which of the following is an open source document-oriented NoSQL DBMS product? Access MongoDB SQL Server DB2

MongoDB

________ refer to software products that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud. NoSQL DBMS MySQL DBMS Traditional DBMS Relational DBMS

NoSQL DBMS

Which of the following is an international standard language for querying databases? C++ SQL Python Visual Basic

SQL

Which of the following is a database management system (DBMS) product from Microsoft? MySQL SQL Server DB2 Sybase ASE

SQL Server

Which of the following is TRUE of browser-based database applications? They are written in object-oriented languages such as Structured Query Language. The application, database management system (DBMS), and the database reside on the user's computer. They are displayed and processed using html, html5, or css3. They use C++ as the standard language for user-side processing.

They are displayed and processed using html, html5, or css3.

Traditional database application programs are written in object-oriented languages like ________. Pascal Visual Basic Datalog Unigraphics

Visual Basic

With ________ like Microsoft Access, the application, DBMS, and database all reside on the user's computer. a simple query application a single user database a spreadsheet a common database

a single user database

If the structure of a list is simple and limited to a single theme, such as a list of student grades, the user should use ________. a database a spreadsheet google docs paper and pencil

a spreadsheet

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________. encrypting emails encapsulating data objects administering the database testing program codes

administering the database

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________. processing administration creation modification

administration

Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________. creation modification processing administration

administration

Which of the following elements of a database application provides security, data consistency, and special-purpose processing? query applications application programs reports forms

application programs

All of these are DBMS processes EXCEPT ________. create data process the database assist in the administration of the database create tables and other database structures

create data

A ________ is a self-describing collection of integrated records. datasheet dataflow database dataspace

database

Lists that involve data with multiple themes require a ________. field spreadsheet file database

database

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. database application metadata table database hierarchy dimension table

database application

The A in ACID means Atomic and means ________. either all or none of the transactions in the database are processed all of the transactions are processed the same way a transaction never goes away processed alone

either all or none of the transactions in the database are processed

In a database, columns are also called ________. records tables files fields

fields

In a database, a table is also called a ________. record matrix file field

file

Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data? reports application programs queries forms

forms

The database management system (DBMS) provides applications for processing operations such as ________. sending and receiving emails generating software codes inserting or deleting information automating business processes

inserting or deleting information

Which of the following is a major drawback of multi-user processing of a database? lack of data integrity software redundancy lost-update problem limited access to data

lost-update problem

Relational databases have been the standard way of processing databases for over 30 years because ________. of fixed-sized tables of gaining faster performance by the number of servers used of the ability to have multiple primary keys improved storage capabilities

of fixed-sized tables

Which of the following is a function of the database management system (DBMS)? implementing lean systems in workstations eliminating bottlenecks in business processes automating workflows in the databases of companies processing a database by inserting or modifying data

processing a database by inserting or modifying data

In a database, rows are also called ________. records fields tables files

records

In a database, a table is formally referred to as a ________. matrix field record relation

relation

Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases. hierarchical network relational object

relational

Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations? queries forms reports application programs

reports

One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________. storing data types such as images, audio, and videos in organizations gaining faster performance by limiting the number of servers used breaking up sales orders via normalization limiting the use of open-source document-oriented DBMS

storing data types such as images, audio, and videos in organizations

In a database, a group of similar rows is called a ________. table record field matrix

table

The conversion of the existing traditional databases in organizations to NoSQL databases is ________. highly efficient and is being practiced by many organizations highly recommended because it is user friendly very cost-effective but can be enormously disruptive unnecessary when relational databases meet the needs of organizations

unnecessary when relational databases meet the needs of organizations

Howie is a business analyst who is given access to the database of a product prior to its launch. He needs to turn the data into a format so he can construct useful information. Which of the following is Howie most likely to do? send the database back to the source to interpret the data use the data present in the database in its raw format encrypt the data to secure the product's authenticity use SQL or graphical tools to query the database

use SQL or graphical tools to query the database