Question 1

Define primary key, foreign key, and metadata.

Accepted Answer

A primary key is a column or group of co

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The data integrity problem occurs only if data are duplicated.

Accepted Answer

A) True 
 B)False

Question 4

When using the relational model to represent two tables, one must ________.

Accepted Answer

A) add a foreign key to one of the tables 
B) have more than two primary keys in the model 
C) establish only N:M relationships between the tables 
D) use metadata instead of foreign keys 
A) add a foreign key to one of the tables 
B) have more than two primary keys in the model 
C) establish only N:M relationships between the tables 
D) use metadata instead of foreign keys

Question 5

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Accepted Answer

A) True 
 B)False

Question 6

The purpose of a database is to keep track of lists of data that involve a single theme.

Accepted Answer

A) True 
 B)False

Question 7

A user does not need user account credentials to access and process a database.

Accepted Answer

A) True 
 B)False

Question 8

Columns that are keys to different tables than the ones in which they reside are called ________.

Accepted Answer

A) attributes 
B) foreign keys 
C) primary keys 
D) internal records 
A) attributes 
B) foreign keys 
C) primary keys 
D) internal records

Question 9

Which of the following is true of N:M relationships?

Accepted Answer

A) They are the same as N:N relationships. 
B) They represent minimum cardinalities in a relationship. 
C) They are also called one-to-many relationships. 
D) They can have more than one entity on each side of the relationship. 
A) They are the same as N:N relationships. 
B) They represent minimum cardinalities in a relationship. 
C) They are also called one-to-many relationships. 
D) They can have more than one entity on each side of the relationship.

Question 10

The rows in a database are called ________.

Accepted Answer

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

Question 11

Which of the following is true of MySQL?

Accepted Answer

A) It is a Microsoft product. 
B) It is license-free for most applications. 
C) It is a paid and proprietary database product. 
D) It uses Static Query Language (SQL)to manage a database. 
A) It is a Microsoft product. 
B) It is license-free for most applications. 
C) It is a paid and proprietary database product. 
D) It uses Static Query Language (SQL)to manage a database.

Question 12

Traditional database application programs are ________.

Accepted Answer

A) browser-based and display dynamic content 
B) written in languages such as html5 and JavaScript 
C) entirely dependent on the database server for application logic 
D) thick applications that need to be installed on users' computers 
A) browser-based and display dynamic content 
B) written in languages such as html5 and JavaScript 
C) entirely dependent on the database server for application logic 
D) thick applications that need to be installed on users' computers

Question 13

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is the smallest element in a database?

Accepted Answer

A) field 
B) record 
C) byte 
D) metadata 
A) field 
B) record 
C) byte 
D) metadata

Question 15

A(n)________ is a program used to create, process, and administer a database.

Accepted Answer

A) operating system 
B) database management system 
C) information system 
D) database system 
A) operating system 
B) database management system 
C) information system 
D) database system

Question 16

Relational databases represent relationships using ________.

Accepted Answer

A) foreign keys 
B) file systems 
C) metadata 
D) primary keys 
A) foreign keys 
B) file systems 
C) metadata 
D) primary keys

Question 17

A database is used instead of a spreadsheet when ________.

Accepted Answer

A) lists of data involve a single theme 
B) structures of data lists are simple 
C) lists involve data with multiple themes 
D) users do not want to store all data in one place 
A) lists of data involve a single theme 
B) structures of data lists are simple 
C) lists involve data with multiple themes 
D) users do not want to store all data in one place

Question 18

Acelane Inc., unlike its competitors, procures raw material from multiple suppliers. Each supplier in turn supplies raw material to many buyers, including Acelane. 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 19

A line in an entity-relationship (E-R)diagram is used to represent the attributes of an entity.

Accepted Answer

A) True 
 B)False

Question 20

Metadata refers to special data that describes the structure of a database.

Accepted Answer

A) True 
 B)False

Define primary key, foreign key, and metadata.

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

The data integrity problem occurs only if data are duplicated.

When using the relational model to represent two tables, one must ________.

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

The purpose of a database is to keep track of lists of data that involve a single theme.

A user does not need user account credentials to access and process a database.

Columns that are keys to different tables than the ones in which they reside are called ________.

Which of the following is true of N:M relationships?

The rows in a database are called ________.

Which of the following is true of MySQL?

Traditional database application programs are ________.

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Which of the following is the smallest element in a database?

A(n)________ is a program used to create, process, and administer a database.

Relational databases represent relationships using ________.

A database is used instead of a spreadsheet when ________.

Acelane Inc., unlike its competitors, procures raw material from multiple suppliers. Each supplier in turn supplies raw material to many buyers, including Acelane. This is an example of a(n)________ relationship.

A line in an entity-relationship (E-R)diagram is used to represent the attributes of an entity.

Metadata refers to special data that describes the structure of a database.

The Importance of Mis

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters

Exam 5: Database Processing

Define primary key, foreign key, and metadata.

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

The data integrity problem occurs only if data are duplicated.

When using the relational model to represent two tables, one must ________.

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

The purpose of a database is to keep track of lists of data that involve a single theme.

A user does not need user account credentials to access and process a database.

Columns that are keys to different tables than the ones in which they reside are called ________.

Which of the following is true of N:M relationships?

The rows in a database are called ________.

Which of the following is true of MySQL?

Traditional database application programs are ________.

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Which of the following is the smallest element in a database?

A(n)________ is a program used to create, process, and administer a database.

Relational databases represent relationships using ________.

A database is used instead of a spreadsheet when ________.

Acelane Inc., unlike its competitors, procures raw material from multiple suppliers. Each supplier in turn supplies raw material to many buyers, including Acelane. This is an example of a(n)________ relationship.

A line in an entity-relationship (E-R)diagram is used to represent the attributes of an entity.

Metadata refers to special data that describes the structure of a database.

The Importance of Mis

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters