Question 1

Today,the only remaining personal DBMS of significance is Microsoft SQL Server.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Which of the following is an example of enterprise DBMS?

Accepted Answer

A)  Paradox 
B)  dBase 
C)  R:base 
D)  MySQL 
A)  Paradox 
B)  dBase 
C)  R:base 
D)  MySQL D

Question 4

A(n)________ is an assembly of forms,reports,queries,and application programs that process a database.

Accepted Answer

A)  SQL server 
B)  metadata 
C)  database management system 
D)  database application system 
A)  SQL server 
B)  metadata 
C)  database management system 
D)  database application system

Question 5

To modify an existing table - for example,to add a new column - the developer opens the metadata form for that table and adds a new row of metadata.

Accepted Answer

A) True 
 B)False

Question 6

What are the differences between a spreadsheet and a database?

Accepted Answer

The purpose of both,a spreadsheet and a

Question 7

To locate something in the database,one must type in the keyword into the ________ of the application.

Accepted Answer

A)  report 
B)  query form 
C)  data entry form 
D)  data column 
A)  report 
B)  query form 
C)  data entry form 
D)  data column

Question 8

Which of the following is true of database application?

Accepted Answer

A)  A database can have only one application, and each application may have one user. 
B)  It is a language that processes information in a database management system. 
C)  Application programs process logic that is specific to a given business need. 
D)  It uses hypertext markup language to process information in a database. 
A)  A database can have only one application, and each application may have one user. 
B)  It is a language that processes information in a database management system. 
C)  Application programs process logic that is specific to a given business need. 
D)  It uses hypertext markup language to process information in a database.

Question 9

________ is both a DBMS and an application development product.

Accepted Answer

A)  FoxPro 
B)  Access 
C)  Oracle 
D)  MySQL 
A)  FoxPro 
B)  Access 
C)  Oracle 
D)  MySQL

Question 10

How can one prevent the lost-update problem of multiuser processing?

Accepted Answer

The lost-update problem exemplifies one

Question 11

Explain database management systems.

Accepted Answer

A database management system (DBMS)is a

Question 12

Relational databases have almost disappeared from use.

Accepted Answer

A) True 
 B)False

Question 13

DBMS administrative functions include backing up database data,adding structures to improve the performance of database applications,removing data that are no longer wanted or needed,and similar tasks.

Accepted Answer

A) True 
 B)False

Question 14

To find out what a database contains,we just look at the metadata inside the database.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is a DBMS product from Microsoft?

Accepted Answer

A)  MySQL 
B)  SQL Server 
C)  DB2 
D)  Sybase ASE 
A)  MySQL 
B)  SQL Server 
C)  DB2 
D)  Sybase ASE

Question 16

A database cannot have more than one application running on it.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

What is the function of a database application system?

Accepted Answer

A database,all by itself,is not very use

Question 19

The purpose of a database is to ________.

Accepted Answer

A)  use special technology to monitor a single theme 
B)  design, write, test, troubleshoot, and maintain the source code of computer programs 
C)  use a logical data model of information to describe and build architectures 
D)  keep track of things that involve more than one thing 
A)  use special technology to monitor a single theme 
B)  design, write, test, troubleshoot, and maintain the source code of computer programs 
C)  use a logical data model of information to describe and build architectures 
D)  keep track of things that involve more than one thing

Question 20

________ is an example of personal DBMS.

Accepted Answer

A)  DB2 
B)  FoxPro 
C)  Oracle 
D)  MySQL 
A)  DB2 
B)  FoxPro 
C)  Oracle 
D)  MySQL

Exam 5: Database Processing

Today,the only remaining personal DBMS of significance is Microsoft SQL Server.

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

Which of the following is an example of enterprise DBMS?

A(n)________ is an assembly of forms,reports,queries,and application programs that process a database.

To modify an existing table - for example,to add a new column - the developer opens the metadata form for that table and adds a new row of metadata.

What are the differences between a spreadsheet and a database?

To locate something in the database,one must type in the keyword into the ________ of the application.

Which of the following is true of database application?

________ is both a DBMS and an application development product.

How can one prevent the lost-update problem of multiuser processing?

Explain database management systems.

Relational databases have almost disappeared from use.

DBMS administrative functions include backing up database data,adding structures to improve the performance of database applications,removing data that are no longer wanted or needed,and similar tasks.

To find out what a database contains,we just look at the metadata inside the database.

Which of the following is a DBMS product from Microsoft?

A database cannot have more than one application running on it.

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

What is the function of a database application system?

The purpose of a database is to ________.

________ is an example of personal DBMS.

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