Question 1

Normalized tables are faster to process than denormalized tables.

Accepted Answer

A) True 
 B)False

Question 2

In order to find the data one is looking for in a DBMS, one has to type in the keyword into a query form.

Accepted Answer

A) True 
 B)False

Question 3

A database application is a collection of forms, reports, queries, and application programs that process a database.

Accepted Answer

A) True 
 B)False

Question 4

A student management system allows students to have multiple majors and advisers are assigned to handle multiple students and courses.This is an example of a(n)________ relationship.

Accepted Answer

A) 1:N 
B) 1:1 
C) N:M 
D) M:1 
A) 1:N 
B) 1:1 
C) N:M 
D) M:1

Question 5

Constraints on the number of entities in a relationship are called ________ cardinalities.

Accepted Answer

A) specific 
B) minimum 
C) primary 
D) critical 
A) specific 
B) minimum 
C) primary 
D) critical

Question 6

Metadata are ________.

Accepted Answer

A) data stored on the main server 
B) error logs of databases 
C) data that describe data 
D) encrypted data transmissions 
A) data stored on the main server 
B) error logs of databases 
C) data that describe data 
D) encrypted data transmissions

Question 7

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra

Question 8

Relational databases represent relationships using ________.

Accepted Answer

A) foreign keys 
B) file systems 
C) metadata 
D) unique identifiers 
A) foreign keys 
B) file systems 
C) metadata 
D) unique identifiers

Question 9

Facebook developed a nonrelational data store called Bigtable.

Accepted Answer

A) True 
 B)False

Question 10

Google developed a nonrelational data store called Dynamo.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

Most organizations develop their own DBMS software in order to obtain control over data.

Accepted Answer

A) True 
 B)False

Question 13

The lost-update problem can be resolved by implementing multi-user database processing.

Accepted Answer

A) True 
 B)False

Question 14

The rows in a database need to have two or more primary keys.

Accepted Answer

A) True 
 B)False

Question 15

The easiest time to change the database structure is immediately before the data modeling stage.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following data elements is placed higher than records in the data hierarchy?

Accepted Answer

A) file 
B) field 
C) character 
D) byte 
A) file 
B) field 
C) character 
D) byte

Question 17

A ________ describes the data and relationships that will be stored in a database.

Accepted Answer

A) data aggregator 
B) query model 
C) data model 
D) data application 
A) data aggregator 
B) query model 
C) data model 
D) data application

Question 18

________ is an example of a personal DBMS.

Accepted Answer

A) SQL Server 
B) DB2 
C) Oracle Database 
D) Access 
A) SQL Server 
B) DB2 
C) Oracle Database 
D) Access

Question 19

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

Accepted Answer

A) vertical bar 
B) arrow 
C) double line 
D) small oval 
A) vertical bar 
B) arrow 
C) double line 
D) small oval

Question 20

________ forms are used to read, insert, modify, and delete data.

Accepted Answer

A) Reporting 
B) Data entry 
C) Query 
D) Request 
A) Reporting 
B) Data entry 
C) Query 
D) Request

Normalized tables are faster to process than denormalized tables.

In order to find the data one is looking for in a DBMS, one has to type in the keyword into a query form.

A database application is a collection of forms, reports, queries, and application programs that process a database.

A student management system allows students to have multiple majors and advisers are assigned to handle multiple students and courses.This is an example of a(n)________ relationship.

Constraints on the number of entities in a relationship are called ________ cardinalities.

Metadata are ________.

What is the purpose of a database?

Relational databases represent relationships using ________.

Facebook developed a nonrelational data store called Bigtable.

Google developed a nonrelational data store called Dynamo.

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

Most organizations develop their own DBMS software in order to obtain control over data.

The lost-update problem can be resolved by implementing multi-user database processing.

The rows in a database need to have two or more primary keys.

The easiest time to change the database structure is immediately before the data modeling stage.

Which of the following data elements is placed higher than records in the data hierarchy?

A ________ describes the data and relationships that will be stored in a database.

________ is an example of a personal DBMS.

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

________ forms are used to read, insert, modify, and delete data.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 5: Database Processing

Normalized tables are faster to process than denormalized tables.

In order to find the data one is looking for in a DBMS, one has to type in the keyword into a query form.

A database application is a collection of forms, reports, queries, and application programs that process a database.

A student management system allows students to have multiple majors and advisers are assigned to handle multiple students and courses.This is an example of a(n)________ relationship.

Constraints on the number of entities in a relationship are called ________ cardinalities.

Metadata are ________.

What is the purpose of a database?

Relational databases represent relationships using ________.

Facebook developed a nonrelational data store called Bigtable.

Google developed a nonrelational data store called Dynamo.

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

Most organizations develop their own DBMS software in order to obtain control over data.

The lost-update problem can be resolved by implementing multi-user database processing.

The rows in a database need to have two or more primary keys.

The easiest time to change the database structure is immediately before the data modeling stage.

Which of the following data elements is placed higher than records in the data hierarchy?

A ________ describes the data and relationships that will be stored in a database.

________ is an example of a personal DBMS.

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

________ forms are used to read, insert, modify, and delete data.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters