Question 1

In a database,columns are also called ________.

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

All traditional databases require the Internet to transmit traffic between a user's computer and a DBMS server computer.

Accepted Answer

A) True 
 B)False

Question 4

One of the important functions of a DBMS is to provide the necessary tools for ________.

Accepted Answer

A) encapsulating data objects 
B) testing program codes 
C) administering the database 
D) encrypting e-mails 
A) encapsulating data objects 
B) testing program codes 
C) administering the database 
D) encrypting e-mails

Question 5

Which of the following is considered an administrative function of the DBMS?

Accepted Answer

A) using international standard languages for processing database applications 
B) testing program codes in the system for errors 
C) creating tables,relationships,and other structures in databases 
D) adding structures to improve the performance of database applications 
A) using international standard languages for processing database applications 
B) testing program codes in the system for errors 
C) creating tables,relationships,and other structures in databases 
D) adding structures to improve the performance of database applications

Question 6

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

Accepted Answer

A) dimension table 
B) database administrator 
C) knowledge management system 
D) database application 
A) dimension table 
B) database administrator 
C) knowledge management system 
D) database application

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

What is a database application?

Accepted Answer

A database application is a collection o

Question 9

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

Accepted Answer

A) relation 
B) matrix 
C) field 
D) record 
A) relation 
B) matrix 
C) field 
D) record

Question 10

The conversion of the existing traditional databases in organisations to NoSQL databases is ________.

Accepted Answer

A) highly recommended because any technology-tolerant business professional can use NoSQL 
B) unnecessary in cases where relational databases meet the needs of organisations 
C) very cost-effective,but can be enormously disruptive 
D) highly efficient and is being practiced by many organisations 
A) highly recommended because any technology-tolerant business professional can use NoSQL 
B) unnecessary in cases where relational databases meet the needs of organisations 
C) very cost-effective,but can be enormously disruptive 
D) highly efficient and is being practiced by many organisations

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

Define SQL.

Accepted Answer

Structured Query Language (SQL)is an int

Question 14

What are the differences between a spreadsheet and a database?

Accepted Answer

The purpose of both a spreadsheet and a

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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) forms 
B) application programs 
C) queries 
D) reports 
A) forms 
B) application programs 
C) queries 
D) reports

Question 18

The DBMS can be used to set up a security system involving user accounts,passwords,permissions,and limits for processing the database.

Accepted Answer

A) True 
 B)False

Question 19

Describe the usefulness of metadata.

Accepted Answer

A database is self-describing in that it

Question 20

In a database,columns are also called records.

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

In a database,columns are also called ________.

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

All traditional databases require the Internet to transmit traffic between a user's computer and a DBMS server computer.

One of the important functions of a DBMS is to provide the necessary tools for ________.

Which of the following is considered an administrative function of the DBMS?

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

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

What is a database application?

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

The conversion of the existing traditional databases in organisations to NoSQL databases is ________.

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

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

Define SQL.

What are the differences between a spreadsheet and a database?

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

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

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

The DBMS can be used to set up a security system involving user accounts,passwords,permissions,and limits for processing the database.

Describe the usefulness of metadata.

In a database,columns are also called records.

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

The Cloud

Organisations 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

Collaboration 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 Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters