Question 1

What is a database management system (DBMS)? Explain with suitable examples.

Accepted Answer

A database management system (DBMS)is a

Question 2

One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________.

Accepted Answer

A) storing data types such as images, audio, and videos in organizations 
B) gaining faster performance by limiting the number of servers used 
C) breaking up sales orders via normalization 
D) limiting the use of open-source document-oriented DBMS 
A) storing data types such as images, audio, and videos in organizations 
B) gaining faster performance by limiting the number of servers used 
C) breaking up sales orders via normalization 
D) limiting the use of open-source document-oriented DBMS

Question 3

Browser database application forms, reports, and queries are displayed and processed using HyperText Markup Language (HTML).

Accepted Answer

A) True 
 B)False

Question 4

HyperText Markup Language is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is a database management system (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 6

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 7

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 8

The database management system (DBMS)provides applications for processing operations such as ________.

Accepted Answer

A) sending and receiving emails 
B) generating software codes 
C) inserting or deleting information 
D) automating business processes 
A) sending and receiving emails 
B) generating software codes 
C) inserting or deleting information 
D) automating business processes

Question 9

Howie is a business analyst who is given access to the database of a product prior to its launch.He needs to understand the data presented and take appropriate action.Which of the following is Howie most likely to do?

Accepted Answer

A) send the database back to the source to interpret the data 
B) use the data present in the database in its raw format 
C) encrypt the data to secure the product's authenticity 
D) use SQL or graphical tools to query the database 
A) send the database back to the source to interpret the data 
B) use the data present in the database in its raw format 
C) encrypt the data to secure the product's authenticity 
D) use SQL or graphical tools to query the database

Question 10

DB2 is a popular database management system product that is licensed from Microsoft.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) datasheet 
B) dataflow 
C) database 
D) dataspace 
A) datasheet 
B) dataflow 
C) database 
D) dataspace

Question 12

Queries in database applications present data in a structured manner using operations such as sorting, grouping, and filtering.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The administrative functions of a database management system (DBMS)include backing up database data.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is true of browser-based database applications?

Accepted Answer

A) They are written in object-oriented languages such as Structured Query Language. 
B) The application, database management system (DBMS), and the database reside on the user's computer. 
C) They are displayed and processed using html, html5, or css3. 
D) They use C++ as the standard language for user-side processing. 
A) They are written in object-oriented languages such as Structured Query Language. 
B) The application, database management system (DBMS), and the database reside on the user's computer. 
C) They are displayed and processed using html, html5, or css3. 
D) They use C++ as the standard language for user-side processing.

Question 17

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

Accepted Answer

A) hierarchical 
B) network 
C) relational 
D) object 
A) hierarchical 
B) network 
C) relational 
D) object

Question 18

A database management system is also referred to as a database.

Accepted Answer

A) True 
 B)False

Question 19

In a database, columns are also called ________.

Accepted Answer

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

Question 20

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

Accepted Answer

A) It is a character of data. 
B) It is a group of rows. 
C) It is a collection of data. 
D) It is a group of columns. 
A) It is a character of data. 
B) It is a group of rows. 
C) It is a collection of data. 
D) It is a group of columns.

Exam 5: Database Processing

What is a database management system (DBMS)? Explain with suitable examples.

One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________.

Browser database application forms, reports, and queries are displayed and processed using HyperText Markup Language (HTML).

HyperText Markup Language is an international standard language for processing a database.

Which of the following is a database management system (DBMS)product from Microsoft?

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

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

The database management system (DBMS)provides applications for processing operations such as ________.

Howie is a business analyst who is given access to the database of a product prior to its launch.He needs to understand the data presented and take appropriate action.Which of the following is Howie most likely to do?

DB2 is a popular database management system product that is licensed from Microsoft.

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

Queries in database applications present data in a structured manner using operations such as sorting, grouping, and filtering.

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

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

The administrative functions of a database management system (DBMS)include backing up database data.

Which of the following is true of browser-based database applications?

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

A database management system is also referred to as a database.

In a database, columns are also called ________.

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems

Hardware and Software

The Cloud

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

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 Erpsystems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters