Question 1

Which of the following elements of a database application provides security,data consistency,and special-purpose processing?

Accepted Answer

A)  query applications 
B)  application programs 
C)  reports 
D)  forms 
A)  query applications 
B)  application programs 
C)  reports 
D)  forms

Question 2

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 3

In a database,rows are also called ________.

Accepted Answer

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

Question 4

Define SQL.

Accepted Answer

Structured Query Language (SQL)is an int

Question 5

In a database,a ________ is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A)  field 
B)  record 
C)  file 
D)  key 
A)  field 
B)  record 
C)  file 
D)  key

Question 6

A DBMS is also referred to as a database.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  reports 
B)  application programs 
C)  queries 
D)  forms 
A)  reports 
B)  application programs 
C)  queries 
D)  forms

Question 8

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 9

Traditional database application programs are written in object-oriented languages like ________.

Accepted Answer

A)  Information Systems Base Language 
B)  VisualBasic 
C)  Datalog 
D)  Structured Query Language 
A)  Information Systems Base Language 
B)  VisualBasic 
C)  Datalog 
D)  Structured Query Language

Question 10

A(n)________ is a program that is used to create,process,and administer a collection of self-describing integrated records.

Accepted Answer

A)  decision support system (DSS) 
B)  knowledge management system (KMS) 
C)  database management system (DBMS) 
D)  enterprise planning system (EPS) 
A)  decision support system (DSS) 
B)  knowledge management system (KMS) 
C)  database management system (DBMS) 
D)  enterprise planning system (EPS)

Question 11

What are relational databases? What has led to the development of new nonrelational styles of database processing?

Accepted Answer

Databases that carry their data in the f

Question 12

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

Accepted Answer

A)  have no security requirements 
B)  mostly run within a corporate network that is protected from the Internet 
C)  are usually open to the public 
D)  fail to support graphical queries 
A)  have no security requirements 
B)  mostly run within a corporate network that is protected from the Internet 
C)  are usually open to the public 
D)  fail to support graphical queries

Question 13

What is a database application?

Accepted Answer

A database application is a collection o

Question 14

Which of the following is true of the relational database processing model?

Accepted Answer

A)  It supports very high transaction rates. 
B)  It can efficiently store files with large collections of bits. 
C)  It helps organizations store new data types such as images, audio, and videos. 
D)  It represents relationships with the help of foreign keys. 
A)  It supports very high transaction rates. 
B)  It can efficiently store files with large collections of bits. 
C)  It helps organizations store new data types such as images, audio, and videos. 
D)  It represents relationships with the help of foreign keys.

Question 15

In a database,the collection of data for all columns is called a file.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following best describes the metadata in a database?

Accepted Answer

A)  data that cannot be used as an information resource 
B)  special data that describes the structure of a database 
C)  data that describes a Web page 
D)  special data that is unique to a specific user 
A)  data that cannot be used as an information resource 
B)  special data that describes the structure of a database 
C)  data that describes a Web page 
D)  special data that is unique to a specific user

Question 17

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n)________ of the DBMS.

Accepted Answer

A)  processing operation 
B)  administrative function 
C)  creation function 
D)  modification function 
A)  processing operation 
B)  administrative function 
C)  creation function 
D)  modification function

Question 18

DB2 is a popular DBMS product that is licensed from Microsoft.

Accepted Answer

A) True 
 B)False

Question 19

SQL statements can be issued directly to the DBMS by an application program.

Accepted Answer

A) True 
 B)False

Question 20

The purpose of a database is to ________.

Accepted Answer

A)  test and troubleshoot newly installed software 
B)  design the source code for computer programs 
C)  describe and build computer architectures 
D)  store lists of data involving multiple themes 
A)  test and troubleshoot newly installed software 
B)  design the source code for computer programs 
C)  describe and build computer architectures 
D)  store lists of data involving multiple themes

Exam 5: Database Processing

Which of the following elements of a database application provides security,data consistency,and special-purpose processing?

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

In a database,rows are also called ________.

Define SQL.

In a database,a ________ is a column or group of columns that identifies a unique row in a table.

A DBMS is also referred to as a database.

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

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

Traditional database application programs are written in object-oriented languages like ________.

A(n)________ is a program that is used to create,process,and administer a collection of self-describing integrated records.

What are relational databases? What has led to the development of new nonrelational styles of database processing?

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

What is a database application?

Which of the following is true of the relational database processing model?

In a database,the collection of data for all columns is called a file.

Which of the following best describes the metadata in a database?

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n)________ of the DBMS.

DB2 is a popular DBMS product that is licensed from Microsoft.

SQL statements can be issued directly to the DBMS by an application program.

The purpose of a database is to ________.

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters