Question 1

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

Accepted Answer

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

Question 2

Databases are static and it is only the information systems that change.

Accepted Answer

A) True 
 B)False  False

Question 3

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. A

Question 4

A cylindrical symbol labeled "database" represents ________ because databases are stored on disks.

Accepted Answer

A)  a drum of data 
B)  dataflow 
C)  a computer disk drive 
D)  dataspace 
A)  a drum of data 
B)  dataflow 
C)  a computer disk drive 
D)  dataspace

Question 5

Permissions have to be general when administering a database.

Accepted Answer

A) True 
 B)False

Question 6

________ databases process databases in main memory.

Accepted Answer

A)  NoSQL 
B)  NewSQL 
C)  In-memory 
D)  Relational 
A)  NoSQL 
B)  NewSQL 
C)  In-memory 
D)  Relational

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

Databases can not be used in a browser.

Accepted Answer

A) True 
 B)False

Question 9

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 10

In a database, a group of similar rows is called a ________.

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

Relational databases have been the standard way of processing databases for over 30 years because ________.

Accepted Answer

A)  of fixed sized tables 
B)  of gaining faster performance by number of servers used 
C)  of the ability to have multiple primary keys 
D)  improved storage capabilities 
A)  of fixed sized tables 
B)  of gaining faster performance by number of servers used 
C)  of the ability to have multiple primary keys 
D)  improved storage capabilities

Question 14

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 15

What is an in-memory database management system?

Accepted Answer

An in-memory database management system

Question 16

SQL stands for ________.

Accepted Answer

A)  Standard Query Language 
B)  Secondary Query Language 
C)  Structured Query Language 
D)  Simplified Query Language 
A)  Standard Query Language 
B)  Secondary Query Language 
C)  Structured Query Language 
D)  Simplified Query Language

Question 17

Access and SQL Server are popular ________ DBMS products.

Accepted Answer

A)  open source 
B)  IBM 
C)  Oracle Corporation 
D)  Microsoft 
A)  open source 
B)  IBM 
C)  Oracle Corporation 
D)  Microsoft

Question 18

SQL statements can only be issued behind the scenes.

Accepted Answer

A) True 
 B)False

Question 19

In a database, bytes are grouped into ________.

Accepted Answer

A)  tables 
B)  columns 
C)  rows 
D)  records 
A)  tables 
B)  columns 
C)  rows 
D)  records

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

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

Databases are static and it is only the information systems that change.

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

A cylindrical symbol labeled "database" represents ________ because databases are stored on disks.

Permissions have to be general when administering a database.

________ databases process databases in main memory.

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

Databases can not be used in a browser.

In a database, columns are also called ________.

In a database, a group of similar rows is called a ________.

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

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

Relational databases have been the standard way of processing databases for over 30 years because ________.

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?

What is an in-memory database management system?

SQL stands for ________.

Access and SQL Server are popular ________ DBMS products.

SQL statements can only be issued behind the scenes.

In a database, bytes are grouped into ________.

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

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