Question 1

What is a database application?

Accepted Answer

A database application is a collection o

Question 2

SQL Server is an open source DBMS product that is free for most applications.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is a function of the DBMS?

Accepted Answer

A)  considering multiuser processing 
B)  mastering database application programs 
C)  preparing reports 
D)  processing the database 
A)  considering multiuser processing 
B)  mastering database application programs 
C)  preparing reports 
D)  processing the database

Question 4

Define SQL.

Accepted Answer

Structured Query Language (SQL)is an int

Question 5

What are personal DBMS products?

Accepted Answer

DBMS products fall into two broad catego

Question 6

Enterprise DBMS products are designed for smaller,simpler database applications.

Accepted Answer

A) True 
 B)False

Question 7

SQL stands for ________.

Accepted Answer

A)  Standard Query Language 
B)  Standard Question Language 
C)  Structured Query Language 
D)  Simplified Query Language 
A)  Standard Query Language 
B)  Standard Question Language 
C)  Structured Query Language 
D)  Simplified Query Language

Question 8

The ________ problem is unique to a multiuser database processing.

Accepted Answer

A)  data integrity 
B)  redundancy 
C)  lost-update 
D)  scrambled report 
A)  data integrity 
B)  redundancy 
C)  lost-update 
D)  scrambled report

Question 9

Bytes are grouped into columns,which are also called ________.

Accepted Answer

A)  records 
B)  rows 
C)  files 
D)  fields 
A)  records 
B)  rows 
C)  files 
D)  fields

Question 10

Explain enterprise DBMS products.

Accepted Answer

DBMS products fall into two broad catego

Question 11

Database developers use the ________ to create relationships in the database.

Accepted Answer

A)  DBMS 
B)  metadata 
C)  rows 
D)  columns 
A)  DBMS 
B)  metadata 
C)  rows 
D)  columns

Question 12

Personal DBMS products are designed ________.

Accepted Answer

A)  to process large organizational and workgroup databases 
B)  to span dozens of different magnetic disks with hundreds of gigabytes or more of data 
C)  to support many users and many different database applications 
D)  for smaller, simpler database applications 
A)  to process large organizational and workgroup databases 
B)  to span dozens of different magnetic disks with hundreds of gigabytes or more of data 
C)  to support many users and many different database applications 
D)  for smaller, simpler database applications

Question 13

Which of the following stands true for enterprise DBMS products?

Accepted Answer

A)  Enterprise DBMS products are designed for small and simple database applications. 
B)  Enterprise DBMS products support many (perhaps thousands) of users and many different database applications. 
C)  Paradox is an example of an enterprise DBMS product. 
D)  Most of the enterprise DBMS products are out of business today. 
A)  Enterprise DBMS products are designed for small and simple database applications. 
B)  Enterprise DBMS products support many (perhaps thousands) of users and many different database applications. 
C)  Paradox is an example of an enterprise DBMS product. 
D)  Most of the enterprise DBMS products are out of business today.

Question 14

Describe the usefulness of metadata.

Accepted Answer

A database is self-describing in that it

Question 15

Which of the following is the most significant personal DBMS product available in the market today?

Accepted Answer

A)  MS Access 
B)  FoxPro 
C)  dBase 
D)  Paradox 
A)  MS Access 
B)  FoxPro 
C)  dBase 
D)  Paradox

Question 16

A ________ is a collection of reports,forms,and queries that process a database.

Accepted Answer

A)  database application 
B)  SQL query 
C)  DBMS 
D)  database structure 
A)  database application 
B)  SQL query 
C)  DBMS 
D)  database structure

Question 17

Each of the elements of the database application system calls on the database management system (DBMS)to process the database tables.

Accepted Answer

A) True 
 B)False

Question 18

________ are used to read,insert,modify,and delete data.

Accepted Answer

A)  Markup language codes 
B)  DBMS applications 
C)  Data entry forms 
D)  Application programs 
A)  Markup language codes 
B)  DBMS applications 
C)  Data entry forms 
D)  Application programs

Question 19

How does one create a database and its structures?

Accepted Answer

Database developers use the DBMS to crea

Question 20

A ________ is a self-describing collection of integrated records.

Accepted Answer

A)  datasheet 
B)  metadata 
C)  database 
D)  data record 
A)  datasheet 
B)  metadata 
C)  database 
D)  data record

Exam 5: Database Processing

What is a database application?

SQL Server is an open source DBMS product that is free for most applications.

Which of the following is a function of the DBMS?

Define SQL.

What are personal DBMS products?

Enterprise DBMS products are designed for smaller,simpler database applications.

SQL stands for ________.

The ________ problem is unique to a multiuser database processing.

Bytes are grouped into columns,which are also called ________.

Explain enterprise DBMS products.

Database developers use the ________ to create relationships in the database.

Personal DBMS products are designed ________.

Which of the following stands true for enterprise DBMS products?

Describe the usefulness of metadata.

Which of the following is the most significant personal DBMS product available in the market today?

A ________ is a collection of reports,forms,and queries that process a database.

Each of the elements of the database application system calls on the database management system (DBMS)to process the database tables.

________ are used to read,insert,modify,and delete data.

How does one create a database and its structures?

A ________ is a self-describing collection of integrated records.

The Importance of MIS

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Data Communications

Business Process Management

E-Commerce, Web 2.0, and Social Networking

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Information Systems Management

Information Security Management

Improving Your Collaboration Skills

Using Collaboration Information Systems

Information Systems and Decision Making

Knowledge Management and Expert Systems

Introduction to Microsoft Excel

Preparing a Computer Budget Using Excel

Database Design

Using Microsoft Access 2010

Using Excel and Access Together

Remote, Nomadic, and Mobile Systems

Functional Processes, Applications, and Systems

Enterprise Resource Planning (ERP)Systems

Supply Chain Management

Processing Social Capital: Facebook, Twitter, and User-Generated Content (UGC)

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Business Process Management

Systems Development Project Management

Outsourcing

International MIS

Filters