Question 1

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

Accepted Answer

A database management system (DBMS)is a program used to create,process,and administer a database.A DBMS is different from a database in that a DBMS is a software program while a database is a collection of tables,relationships,and metadata.Almost no organization develops its own DBMS.Instead,companies license DBMS products from vendors such as IBM,Microsoft,Oracle,and others.Popular DBMS products are DB2 from IBM,Access and SQL Server from Microsoft,and Oracle Database from the Oracle Corporation.Another popular DBMS is MySQL,an open source DBMS product that is license-free for most applications.

Question 2

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 D

Question 3

A database application serves as an intermediary between users and database data.

Accepted Answer

A) True 
 B)False  True

Question 4

Data that describe the data contained in a database are called ________.

Accepted Answer

A) open matrices 
B) primary data 
C) metadata 
D) closed matrices 
A) open matrices 
B) primary data 
C) metadata 
D) closed matrices

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

In a database,columns are also called records.

Accepted Answer

A) True 
 B)False

Question 8

Reports in database applications provide security,data consistency,and special-purpose processing.

Accepted Answer

A) True 
 B)False

Question 9

________ 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 10

In single-user databases,the application,the database management system (DBMS),and the database all reside on a user's computer.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is a drawback of the relational database processing model?

Accepted Answer

A) It utilized an extensive amount of storage space. 
B) It required powerful processors to function. 
C) It was never a natural fit with business documents. 
D) It did not enable document piece-making via normalization. 
A) It utilized an extensive amount of storage space. 
B) It required powerful processors to function. 
C) It was never a natural fit with business documents. 
D) It did not enable document piece-making via normalization.

Question 12

In a database,a group of similar rows or records is called a table.

Accepted Answer

A) True 
 B)False

Question 13

Structured query language statements can be issued directly to the database management system (DBMS)by an application program.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

Bytes,which are characters of data,are grouped into rows in a database.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Exam 5: Database Processing

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

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

A database application serves as an intermediary between users and database data.

Data that describe the data contained in a database are called ________.

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

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

In a database,columns are also called records.

Reports in database applications provide security,data consistency,and special-purpose processing.

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

In single-user databases,the application,the database management system (DBMS),and the database all reside on a user's computer.

Which of the following is a drawback of the relational database processing model?

In a database,a group of similar rows or records is called a table.

Structured query language statements can be issued directly to the database management system (DBMS)by an application program.

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

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

Bytes,which are characters of data,are grouped into rows in a database.

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

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

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

In a database,rows are also called ________.

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 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 2013

Database Design

Using Microsoft Access 2013

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

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters