Question 1

1:N,N:M,and 1:1 are common examples of minimum cardinalities.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Minimum cardinalities represent the minimum number of entity instances required in a relationship.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

A primary key used in a database is a ________.

Accepted Answer

A)  group of rows that are formed to identify a unique table or file 
B)  column or group of columns that identifies a unique row in a table 
C)  character or byte that represents fields or columns 
D)  group of tables or files formed to identify a unique field or row 
A)  group of rows that are formed to identify a unique table or file 
B)  column or group of columns that identifies a unique row in a table 
C)  character or byte that represents fields or columns 
D)  group of tables or files formed to identify a unique field or row

Question 6

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 7

The tables that appear in a database are known as ________.

Accepted Answer

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

Question 8

The columns in a database are called ________.

Accepted Answer

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

Question 9

A line in an E-R diagram is used to represent the attributes of the entities.

Accepted Answer

A) True 
 B)False

Question 10

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Accepted Answer

A) True 
 B)False

Question 11

The accuracy of a database design is independent of the corresponding data model.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

In data models,physical objects are represented as entities,whereas logical constructs and transactions are represented as attributes.

Accepted Answer

A) True 
 B)False

Question 14

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Accepted Answer

A)  Administrators 
B)  Developers 
C)  Users 
D)  Designers 
A)  Administrators 
B)  Developers 
C)  Users 
D)  Designers

Question 15

A ________ is a collection of forms,reports,queries,and programs that use the DBMS to process a database.

Accepted Answer

A)  database application 
B)  database design 
C)  data field 
D)  data model 
A)  database application 
B)  database design 
C)  data field 
D)  data model

Question 16

A database is required instead of a spreadsheet when ________.

Accepted Answer

A)  professionals need to keep track of things 
B)  a user requires control over data 
C)  lists involve data with multiple themes 
D)  one or more users want to access the same data 
A)  professionals need to keep track of things 
B)  a user requires control over data 
C)  lists involve data with multiple themes 
D)  one or more users want to access the same data

Question 17

Describe a database and its various elements.

Accepted Answer

A database is a self-describing collecti

Question 18

Why are NoSQL databases likely to be used only by wealthy organizations with unique
database needs.?

Accepted Answer

As a rule,NoSQL DBMS products require su

Question 19

Describe the differences between Enterprise DBMS and Personal DBMS?

Accepted Answer

DBMS products fall into two broad catego

Question 20

A many-to-many (N:M)relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Accepted Answer

A) True 
 B)False

1:N,N:M,and 1:1 are common examples of minimum cardinalities.

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

Minimum cardinalities represent the minimum number of entity instances required in a relationship.

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

A primary key used in a database is a ________.

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.

The tables that appear in a database are known as ________.

The columns in a database are called ________.

A line in an E-R diagram is used to represent the attributes of the entities.

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

The accuracy of a database design is independent of the corresponding data model.

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

In data models,physical objects are represented as entities,whereas logical constructs and transactions are represented as attributes.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

A ________ is a collection of forms,reports,queries,and programs that use the DBMS to process a database.

A database is required instead of a spreadsheet when ________.

Describe a database and its various elements.

Why are NoSQL databases likely to be used only by wealthy organizations with unique database needs.?

Describe the differences between Enterprise DBMS and Personal DBMS?

A many-to-many (N:M)relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

The Importance of MIS

Business Processes, Information Systems, and Information

Networks and the Cloud

Information Systems Security

Using Is to Improve Processes

Supporting Processes With ERP Systems

Supporting the Procurement Process With SAP

Supporting the Sales Process With SAP

Collaboration and IS

Social Media and IS

Business Intelligence and IS

Filters

Exam 4: Database Processing

1:N,N:M,and 1:1 are common examples of minimum cardinalities.

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

Minimum cardinalities represent the minimum number of entity instances required in a relationship.

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

A primary key used in a database is a ________.

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.

The tables that appear in a database are known as ________.

The columns in a database are called ________.

A line in an E-R diagram is used to represent the attributes of the entities.

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

The accuracy of a database design is independent of the corresponding data model.

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

In data models,physical objects are represented as entities,whereas logical constructs and transactions are represented as attributes.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

A ________ is a collection of forms,reports,queries,and programs that use the DBMS to process a database.

A database is required instead of a spreadsheet when ________.

Describe a database and its various elements.

Why are NoSQL databases likely to be used only by wealthy organizations with unique database needs.?

Describe the differences between Enterprise DBMS and Personal DBMS?

A many-to-many (N:M)relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

The Importance of MIS

Business Processes, Information Systems, and Information

Networks and the Cloud

Information Systems Security

Using Is to Improve Processes

Supporting Processes With ERP Systems

Supporting the Procurement Process With SAP

Supporting the Sales Process With SAP

Collaboration and IS

Social Media and IS

Business Intelligence and IS

Filters