Question 1

Which of the following is an international standard language for processing a database?

Accepted Answer

A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access 
E)  Relational LM 
A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access 
E)  Relational LM C

Question 2

In a database, ________ are grouped into columns.

Accepted Answer

A)  fields 
B)  records 
C)  bytes 
D)  files 
E)  nibbles 
A)  fields 
B)  records 
C)  bytes 
D)  files 
E)  nibbles C

Question 3

A data integrity problem will occur only if ________.

Accepted Answer

A)  a database has multiple administrators 
B)  data are duplicated in a database 
C)  the database is very complex 
D)  there are complex relationships between entities in a database 
E)  the database has too many keys 
A)  a database has multiple administrators 
B)  data are duplicated in a database 
C)  the database is very complex 
D)  there are complex relationships between entities in a database 
E)  the database has too many keys B

Question 4

In an E-R diagram, a line between two entities represents a(n) ________.

Accepted Answer

A)  attribute 
B)  identifier 
C)  cardinality 
D)  relationship 
E)  branch 
A)  attribute 
B)  identifier 
C)  cardinality 
D)  relationship 
E)  branch

Question 5

Explain the role of users in the database development process.

Accepted Answer

A database is a model of how the users v

Question 6

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ________.

Accepted Answer

A)  lost-update problem 
B)  crow's-foot paradigm 
C)  bullwhip effect 
D)  update query problem 
E)  bait-and-switch problem 
A)  lost-update problem 
B)  crow's-foot paradigm 
C)  bullwhip effect 
D)  update query problem 
E)  bait-and-switch problem

Question 7

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 
E)  data-tree model 
A)  data aggregator 
B)  query model 
C)  data model 
D)  data application 
E)  data-tree model

Question 8

The process of normalization constructs tables such that every table has a ________.

Accepted Answer

A)  one-to-one relationship between entities 
B)  single theme 
C)  foreign key 
D)  specialized graphical query 
E)  minimized metadata footprint 
A)  one-to-one relationship between entities 
B)  single theme 
C)  foreign key 
D)  specialized graphical query 
E)  minimized metadata footprint

Question 9

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 
E)  N:1 
A)  1:N 
B)  1:1 
C)  N:M 
D)  M:1 
E)  N:1

Question 10

SQL is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

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. 
E)  It limits databases to 2 TB in size. 
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. 
E)  It limits databases to 2 TB in size.

Question 12

Browser-based applications ________.

Accepted Answer

A)  are thick-client applications 
B)  can display only static content 
C)  support graphical queries 
D)  process queries using C++ 
E)  process queries without using SQL 
A)  are thick-client applications 
B)  can display only static content 
C)  support graphical queries 
D)  process queries using C++ 
E)  process queries without using SQL

Question 13

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.

Accepted Answer

A)  identifiers 
B)  records 
C)  primary keys 
D)  entities 
E)  quarks 
A)  identifiers 
B)  records 
C)  primary keys 
D)  entities 
E)  quarks

Question 14

A group of similar rows or records is known as ________.

Accepted Answer

A)  a prototype 
B)  a table 
C)  a field 
D)  an attribute 
E)  a cluster 
A)  a prototype 
B)  a table 
C)  a field 
D)  an attribute 
E)  a cluster

Question 15

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 16

Define the acronym ACID, and describe why ACID transactions are important.

Accepted Answer

Traditional relational DBMS products dev

Question 17

Sonya is the database administrator for RedTriangle media. She is responsible for validating the data model to be used by the DBMS, and specifying the database requirements to endure all appropriate user input is considered. This is an example of Sonya's ________ tasks.

Accepted Answer

A)  development 
B)  recovery 
C)  adaptation 
D)  operation 
E)  data audit 
A)  development 
B)  recovery 
C)  adaptation 
D)  operation 
E)  data audit

Question 18

________ 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 
E)  Auditors 
A)  Administrators 
B)  Developers 
C)  Users 
D)  Designers 
E)  Auditors

Question 19

What is database administration?

Accepted Answer

Database administration involves a wide

Question 20

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

Which of the following is an international standard language for processing a database?

In a database, ________ are grouped into columns.

A data integrity problem will occur only if ________.

In an E-R diagram, a line between two entities represents a(n) ________.

Explain the role of users in the database development process.

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

The process of normalization constructs tables such that every table has a ________.

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.

SQL is an international standard language for processing a database.

Which of the following is True of MySQL?

Browser-based applications ________.

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.

A group of similar rows or records is known as ________.

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

Define the acronym ACID, and describe why ACID transactions are important.

Sonya is the database administrator for RedTriangle media. She is responsible for validating the data model to be used by the DBMS, and specifying the database requirements to endure all appropriate user input is considered. This is an example of Sonya's ________ tasks.

________ 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.

What is database administration?

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

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 an international standard language for processing a database?

In a database, ________ are grouped into columns.

A data integrity problem will occur only if ________.

In an E-R diagram, a line between two entities represents a(n) ________.

Explain the role of users in the database development process.

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

The process of normalization constructs tables such that every table has a ________.

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.

SQL is an international standard language for processing a database.

Which of the following is True of MySQL?

Browser-based applications ________.

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.

A group of similar rows or records is known as ________.

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

Define the acronym ACID, and describe why ACID transactions are important.

Sonya is the database administrator for RedTriangle media. She is responsible for validating the data model to be used by the DBMS, and specifying the database requirements to endure all appropriate user input is considered. This is an example of Sonya's ________ tasks.

________ 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.

What is database administration?

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

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