Question 1

Which of the following is used to process and display browser database application forms, reports, and queries?

Accepted Answer

A)  C++ 
B)  html 
C)  COBOL 
D)  VisualBasic 
A)  C++ 
B)  html 
C)  COBOL 
D)  VisualBasic

Question 2

A primary key in a database is a ________.

Accepted Answer

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

Question 3

Which of the following is True about the database development process?

Accepted Answer

A)  The database structure is easy to change during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M in an existing database is a complex and lengthy process. 
C)  User review of the data model is avoided as it is not helpful in data modeling. 
D)  Databases are easier to develop than spreadsheets. 
A)  The database structure is easy to change during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M in an existing database is a complex and lengthy process. 
C)  User review of the data model is avoided as it is not helpful in data modeling. 
D)  Databases are easier to develop than spreadsheets.

Question 4

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 5

1:N, N:M, and 1:1 are common examples of minimum cardinalities, where N and M represent many relationships for two different entities.

Accepted Answer

A) True 
 B)False

Question 6

Metadata are ________.

Accepted Answer

A)  codes used for server-side processing 
B)  error logs of databases 
C)  data that describe data 
D)  data that are encrypted 
A)  codes used for server-side processing 
B)  error logs of databases 
C)  data that describe data 
D)  data that are encrypted

Question 7

In an entity-relationship data model, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

Accepted Answer

A) True 
 B)False

Question 8

A data model is a ________.

Accepted Answer

A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs used to retrieve data 
A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs used to retrieve data

Question 9

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Accepted Answer

A) True 
 B)False

Question 10

Most organizations develop their own database management system (DBMS) in order to obtain control over data.

Accepted Answer

A) True 
 B)False

Question 11

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Which of the following is True of traditional database application programs?

Accepted Answer

A)  Application forms, reports, and queries are displayed and processed using a browser application. 
B)  The application logic is contained in a program on the client-side computer. 
C)  They are written in object-oriented languages such as C++ and VisualBasic. 
D)  They are thin-client applications that need not be pre-installed on the users' computers. 
A)  Application forms, reports, and queries are displayed and processed using a browser application. 
B)  The application logic is contained in a program on the client-side computer. 
C)  They are written in object-oriented languages such as C++ and VisualBasic. 
D)  They are thin-client applications that need not be pre-installed on the users' computers.

Question 14

Entities in a data model have ________ that describe the characteristics of the entity.

Accepted Answer

A)  characters 
B)  primary keys 
C)  codes 
D)  attributes 
A)  characters 
B)  primary keys 
C)  codes 
D)  attributes

Question 15

Attributes are used to describe characteristics of entities.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance.

Accepted Answer

A) True 
 B)False

Question 18

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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.

Which of the following is used to process and display browser database application forms, reports, and queries?

A primary key in a database is a ________.

Which of the following is True about the database development process?

The rows in a database are called ________.

1:N, N:M, and 1:1 are common examples of minimum cardinalities, where N and M represent many relationships for two different entities.

Metadata are ________.

In an entity-relationship data model, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

A data model is a ________.

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Most organizations develop their own database management system (DBMS) in order to obtain control over data.

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

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

Which of the following is True of traditional database application programs?

Entities in a data model have ________ that describe the characteristics of the entity.

Attributes are used to describe characteristics of entities.

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

An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance.

What is the purpose of a database?

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

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

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

Which of the following is used to process and display browser database application forms, reports, and queries?

A primary key in a database is a ________.

Which of the following is True about the database development process?

The rows in a database are called ________.

1:N, N:M, and 1:1 are common examples of minimum cardinalities, where N and M represent many relationships for two different entities.

Metadata are ________.

In an entity-relationship data model, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

A data model is a ________.

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Most organizations develop their own database management system (DBMS) in order to obtain control over data.

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

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

Which of the following is True of traditional database application programs?

Entities in a data model have ________ that describe the characteristics of the entity.

Attributes are used to describe characteristics of entities.

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

An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance.

What is the purpose of a database?

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

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

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