Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

SQL is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 5

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 
A)  identifiers 
B)  records 
C)  primary keys 
D)  entities

Question 6

A(n) ________ is a request for data from a database.

Accepted Answer

A)  form 
B)  report 
C)  query 
D)  application 
A)  form 
B)  report 
C)  query 
D)  application

Question 7

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________.

Accepted Answer

A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  security problem 
A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  security problem

Question 8

The data in a database are modified and deleted. These operations of DBMS are known as ________.

Accepted Answer

A)  statistical operations 
B)  analytical operations 
C)  administrative operations 
D)  processing operations 
A)  statistical operations 
B)  analytical operations 
C)  administrative operations 
D)  processing operations

Question 9

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

To transform a data model into a relatio

Question 10

A logical representation of database data, called the data model, is constructed by developers after building a database.

Accepted Answer

A) True 
 B)False

Question 11

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 12

NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

Accepted Answer

A) True 
 B)False

Question 13

In a data model, a(n) ________ is something that a user wants to track.

Accepted Answer

A)  record 
B)  byte 
C)  entity 
D)  primary key 
A)  record 
B)  byte 
C)  entity 
D)  primary key

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Which of the following database administration tasks is related to adaptation?

Accepted Answer

A)  monitoring backup procedures 
B)  conducting training for users 
C)  monitoring database performance 
D)  managing configuration changes in systems 
A)  monitoring backup procedures 
B)  conducting training for users 
C)  monitoring database performance 
D)  managing configuration changes in systems

Question 18

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 19

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

Accepted Answer

A)  small oval 
B)  vertical bar 
C)  arrow 
D)  triangular block 
A)  small oval 
B)  vertical bar 
C)  arrow 
D)  triangular block

Question 20

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

Accepted Answer

A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access 
A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access

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

Which of the following is True of MySQL?

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

SQL is an international standard language for processing a database.

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(n) ________ is a request for data from a database.

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________.

The data in a database are modified and deleted. These operations of DBMS are known as ________.

What are the steps involved in transforming a data model into a relational database design?

A logical representation of database data, called the data model, is constructed by developers after building a database.

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

NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

In a data model, a(n) ________ is something that a user wants to track.

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

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

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

Which of the following database administration tasks is related to adaptation?

The columns in a database are called ________.

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

Which of the following is an international standard language for processing 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

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

Which of the following is True of MySQL?

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

SQL is an international standard language for processing a database.

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(n) ________ is a request for data from a database.

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n) ________.

The data in a database are modified and deleted. These operations of DBMS are known as ________.

What are the steps involved in transforming a data model into a relational database design?

A logical representation of database data, called the data model, is constructed by developers after building a database.

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

NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

In a data model, a(n) ________ is something that a user wants to track.

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

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

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

Which of the following database administration tasks is related to adaptation?

The columns in a database are called ________.

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

Which of the following is an international standard language for processing 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