Question 1

Which of the following is a major problem posed by multi-user processing of a database?

Accepted Answer

A) lack of data integrity 
B) lost-update problem 
C) software redundancy 
D) limited access to data 
A) lack of data integrity 
B) lost-update problem 
C) software redundancy 
D) limited access to data

Question 2

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

Accepted Answer

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

Question 3

How does one create a database and its structures?

Accepted Answer

Database developers use the DBMS to crea

Question 4

Databases are required to keep track of lists with multiple themes.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) query applications 
B) reports 
C) application programs 
D) forms 
A) query applications 
B) reports 
C) application programs 
D) forms

Question 8

SQL statements can be issued directly to the DBMS by an application program.

Accepted Answer

A) True 
 B)False

Question 9

Explain database management systems (DBMS).

Accepted Answer

A database management system (DBMS)is a

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

DB2 is a popular DBMS product that is licensed from Microsoft.

Accepted Answer

A) True 
 B)False

Question 13

In a database,the collection of data for all columns is called a ________.

Accepted Answer

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

Question 14

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 15

Which of the following is a DBMS product from Microsoft?

Accepted Answer

A) MySQL 
B) Sybase ASE 
C) DB2 
D) SQL Server 
A) MySQL 
B) Sybase ASE 
C) DB2 
D) SQL Server

Question 16

The administrative functions of a DBMS include backing up database data.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) foreign 
B) discrete 
C) continuous 
D) relational 
A) foreign 
B) discrete 
C) continuous 
D) relational

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) Relational DBMS 
B) Traditional DBMS 
C) MySQL DBMS 
D) NoSQL DBMS 
A) Relational DBMS 
B) Traditional DBMS 
C) MySQL DBMS 
D) NoSQL DBMS

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

Which of the following is a major problem posed by multi-user processing of a database?

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

How does one create a database and its structures?

Databases are required to keep track of lists with multiple themes.

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

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

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

SQL statements can be issued directly to the DBMS by an application program.

Explain database management systems (DBMS).

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

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

DB2 is a popular DBMS product that is licensed from Microsoft.

In a database,the collection of data for all columns is called a ________.

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

Which of the following is a DBMS product from Microsoft?

The administrative functions of a DBMS include backing up database data.

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

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

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

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

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