Question 1

In a database, a table is formally referred to as a ________.

Accepted Answer

A)  matrix 
B)  field 
C)  record 
D)  relation 
A)  matrix 
B)  field 
C)  record 
D)  relation

Question 2

To find out what a database contains, one can look at the metadata inside the database.

Accepted Answer

A) True 
 B)False

Question 3

Security requirements are more stringent for traditional applications than for browser-based ones.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is a major drawback of multi-user processing of a database?

Accepted Answer

A)  lack of data integrity 
B)  software redundancy 
C)  lost-update problem 
D)  limited access to data 
A)  lack of data integrity 
B)  software redundancy 
C)  lost-update problem 
D)  limited access to data

Question 5

A database is a self-describing collection of integrated records. What is meant by the term "self-describing"?

Accepted Answer

Self-describing means that a database co

Question 6

Which of the following is an international standard language for querying databases?

Accepted Answer

A)  C++ 
B)  SQL 
C)  Python 
D)  Visual Basic 
A)  C++ 
B)  SQL 
C)  Python 
D)  Visual Basic

Question 7

The format of the metadata in a database depends on the software product that is processing the database.

Accepted Answer

A) True 
 B)False

Question 8

________ are browser based queries that are created when a user clicks on a graphic.

Accepted Answer

A)  Graphical queries 
B)  Application programs 
C)  User reports 
D)  Databases 
A)  Graphical queries 
B)  Application programs 
C)  User reports 
D)  Databases

Question 9

Which of the following is considered an administrative function of the database management system (DBMS)?

Accepted Answer

A)  adding structures to improve the performance of database applications 
B)  testing program codes in the system for errors 
C)  creating tables, relationships, and other structures in databases 
D)  using international standard languages for processing database applications 
A)  adding structures to improve the performance of database applications 
B)  testing program codes in the system for errors 
C)  creating tables, relationships, and other structures in databases 
D)  using international standard languages for processing database applications

Question 10

________ refers to software products that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.

Accepted Answer

A)  NoSQL DBMS 
B)  MySQL DBMS 
C)  Traditional DBMS 
D)  Relational DBMS 
A)  NoSQL DBMS 
B)  MySQL DBMS 
C)  Traditional DBMS 
D)  Relational DBMS

Question 11

If the structure of a list is simple, such as a list of student grades, the user should use ________.

Accepted Answer

A)  a database 
B)  a spreadsheet 
C)  google docs 
D)  paper and pencil 
A)  a database 
B)  a spreadsheet 
C)  google docs 
D)  paper and pencil

Question 12

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

Accepted Answer

A) True 
 B)False

Question 13

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.

Accepted Answer

A)  encrypting emails 
B)  encapsulating data objects 
C)  administering the database 
D)  testing program codes 
A)  encrypting emails 
B)  encapsulating data objects 
C)  administering the database 
D)  testing program codes

Question 14

Browser-based database applications differ from traditional applications in that they ________.

Accepted Answer

A)  have no security requirements 
B)  are used only by corporates 
C)  are usually open to the public 
D)  fail to support graphical queries 
A)  have no security requirements 
B)  are used only by corporates 
C)  are usually open to the public 
D)  fail to support graphical queries

Question 15

In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys.

Accepted Answer

A)  foreign 
B)  alternate 
C)  relational 
D)  candidate 
A)  foreign 
B)  alternate 
C)  relational 
D)  candidate

Question 16

________ is a popular enterprise database management system (DBMS) product from IBM.

Accepted Answer

A)  DB2 
B)  Access 
C)  SQL Server 
D)  MySQL 
A)  DB2 
B)  Access 
C)  SQL Server 
D)  MySQL

Question 17

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

Accepted Answer

A)  database application 
B)  metadata table 
C)  database hierarchy 
D)  dimension table 
A)  database application 
B)  metadata table 
C)  database hierarchy 
D)  dimension table

Question 18

Why does a user need to understand database technology?

Accepted Answer

Answers may vary. A user needs to know i

Question 19

All of these are DBMS processes EXCEPT ________.

Accepted Answer

A)  create data 
B)  process the database 
C)  assist in the administration of the database 
D)  create tables and other database structures 
A)  create data 
B)  process the database 
C)  assist in the administration of the database 
D)  create tables and other database structures

Question 20

Browser applications are thin-client applications that need not be preinstalled on the users' computers.

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

In a database, a table is formally referred to as a ________.

To find out what a database contains, one can look at the metadata inside the database.

Security requirements are more stringent for traditional applications than for browser-based ones.

Which of the following is a major drawback of multi-user processing of a database?

A database is a self-describing collection of integrated records. What is meant by the term "self-describing"?

Which of the following is an international standard language for querying databases?

The format of the metadata in a database depends on the software product that is processing the database.

________ are browser based queries that are created when a user clicks on a graphic.

Which of the following is considered an administrative function of the database management system (DBMS)?

________ refers to software products that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.

If the structure of a list is simple, such as a list of student grades, the user should use ________.

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.

Browser-based database applications differ from traditional applications in that they ________.

In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys.

________ is a popular enterprise database management system (DBMS) product from IBM.

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

Why does a user need to understand database technology?

All of these are DBMS processes EXCEPT ________.

Browser applications are thin-client applications that need not be preinstalled on the users' computers.

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2016

Database Design

Using Microsoft Access 2016

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning Erp Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters