Question 1

Discuss the creation of a database. Explain its working.

Accepted Answer

Database developers use the database man

Question 2

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

Accepted Answer

A)  programs used to create, process, and administer a database 
B)  special data that describes the structure of a database 
C)  data that is stored in a Web site 
D)  special data that is unique to a specific user 
A)  programs used to create, process, and administer a database 
B)  special data that describes the structure of a database 
C)  data that is stored in a Web site 
D)  special data that is unique to a specific user

Question 3

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

Accepted Answer

A database management system (DBMS) is a

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

Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations?

Accepted Answer

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

Question 7

The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

Accepted Answer

A) True 
 B)False

Question 8

Google is a database that is used by Facebook and Twitter.

Accepted Answer

A) True 
 B)False

Question 9

The A in ACIS means Atomic and means ________.

Accepted Answer

A)  either all of none of the transactions in the database are processed 
B)  all of the transactions are processed the same way 
C)  a transaction never goes away 
D)  processed alone 
A)  either all of none of the transactions in the database are processed 
B)  all of the transactions are processed the same way 
C)  a transaction never goes away 
D)  processed alone

Question 10

All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS) server computer.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is a nonrelational data store developed by Amazon.com?

Accepted Answer

A)  Bigtable 
B)  Dynamo 
C)  Cassandra 
D)  MongoDB 
A)  Bigtable 
B)  Dynamo 
C)  Cassandra 
D)  MongoDB

Question 12

Which of the following is an open source document-oriented NoSQL DBMS product?

Accepted Answer

A)  Access 
B)  MongoDB 
C)  SQL Server 
D)  DB2 
A)  Access 
B)  MongoDB 
C)  SQL Server 
D)  DB2

Question 13

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 14

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 15

Bytes are grouped into rows in a database.

Accepted Answer

A) True 
 B)False

Question 16

New products such as NoSQL databases will replace the relational model.

Accepted Answer

A) True 
 B)False

Question 17

Browser database applications are thick-client applications that need to be preinstalled on the users' computers.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

With ________ like Microsoft Access, the application, DBMS, and database all reside on the user's computer.

Accepted Answer

A)  a simple query applications 
B)  a single user database 
C)  a spreadsheet 
D)  a common database 
A)  a simple query applications 
B)  a single user database 
C)  a spreadsheet 
D)  a common database

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

Discuss the creation of a database. Explain its working.

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

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

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

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

Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations?

The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

Google is a database that is used by Facebook and Twitter.

The A in ACIS means Atomic and means ________.

All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS) server computer.

Which of the following is a nonrelational data store developed by Amazon.com?

Which of the following is an open source document-oriented NoSQL DBMS product?

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

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

Bytes are grouped into rows in a database.

New products such as NoSQL databases will replace the relational model.

Browser database applications are thick-client applications that need to be preinstalled on the users' computers.

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

With ________ like Microsoft Access, the application, DBMS, and database all reside on the user's computer.

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

The Cloud

Processes, 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 2016

Database Design

Using Microsoft Access 2016

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

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters