Question 1

Which of the following database administration tasks is associated with database backup and recovery?

Accepted Answer

A)  managing security and ensuring that security system works 
B)  conducting training for users and operations personnel on various procedures 
C)  developing a system to record and prioritize requests for change 
D)  ensuring that all appropriate user input is considered when designing a database 
A)  managing security and ensuring that security system works 
B)  conducting training for users and operations personnel on various procedures 
C)  developing a system to record and prioritize requests for change 
D)  ensuring that all appropriate user input is considered when designing a database

Question 2

Explain the different database administration tasks associated with the backup and recovery of databases.

Accepted Answer

For important databases, most organizati

Question 3

Which of the following is true of database application programs?

Accepted Answer

A)  They cannot enable database processing over the Internet. 
B)  They are less effective than forms for non-standard functions. 
C)  They allow modification, but not deletion, of database data. 
D)  They process logic that is specific to a given business need. 
A)  They cannot enable database processing over the Internet. 
B)  They are less effective than forms for non-standard functions. 
C)  They allow modification, but not deletion, of database data. 
D)  They process logic that is specific to a given business need.

Question 4

Which of the following statements about Structured Query Language is true?

Accepted Answer

A)  SQL is a product-specific language used only with MySQL applications. 
B)  SQL is the industry standard language used in the U.S., but not elsewhere. 
C)  SQL is an international standard language for processing a database. 
D)  Major DBMS products do not accept and process SQL statements. 
A)  SQL is a product-specific language used only with MySQL applications. 
B)  SQL is the industry standard language used in the U.S., but not elsewhere. 
C)  SQL is an international standard language for processing a database. 
D)  Major DBMS products do not accept and process SQL statements.

Question 5

The database design team transforms entities into tables and expresses relationships by defining foreign keys.

Accepted Answer

A) True 
 B)False

Question 6

What are the components of a database application system?

Accepted Answer

The three major components of a database

Question 7

A database is called self-describing because it reduces data duplication.

Accepted Answer

A) True 
 B)False

Question 8

Surrogate keys are unique identifiers assigned by the DBMS.

Accepted Answer

A) True 
 B)False

Question 9

Normalized tables cannot eliminate data duplication, but they can be faster to process.

Accepted Answer

A) True 
 B)False

Question 10

In a database, records refer to the data in columns.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following database administration tasks is associated with database operation?

Accepted Answer

A)  evaluating application design 
B)  forming a steering committee 
C)  tracking and resolving problems 
D)  conducting training 
A)  evaluating application design 
B)  forming a steering committee 
C)  tracking and resolving problems 
D)  conducting training

Question 12

What are maximum cardinalities and minimum cardinalities?

Accepted Answer

The maximum number of entities that can

Question 13

Explain the different operation database administration tasks.

Accepted Answer

For important databases, most organizati

Question 14

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

Accepted Answer

A)  The number of entities on each side cannot be different. 
B)  More than one entity is allowed on each side of the relationship. 
C)  One side must have a greater number of entities than the other. 
D)  They are also called one-to-many relationships. 
A)  The number of entities on each side cannot be different. 
B)  More than one entity is allowed on each side of the relationship. 
C)  One side must have a greater number of entities than the other. 
D)  They are also called one-to-many relationships.

Question 15

Developers use ________ to define the entities that will be stored in the database and the relationships among those entities.

Accepted Answer

A)  the waterfall model 
B)  spiral models 
C)  incremental models 
D)  the E-R data model 
A)  the waterfall model 
B)  spiral models 
C)  incremental models 
D)  the E-R data model

Question 16

What are metadata? How are metadata used in databases?

Accepted Answer

Databases are self-describing because th

Question 17

The easiest time to change the database structure is during the ________ stage.

Accepted Answer

A)  data modeling 
B)  data warehousing 
C)  database design 
D)  data entry 
A)  data modeling 
B)  data warehousing 
C)  database design 
D)  data entry

Question 18

Reports are used to ________.

Accepted Answer

A)  read, insert, modify, and delete data 
B)  create and administer a database 
C)  show data in a structured context 
D)  minimize the use of SQL in a database 
A)  read, insert, modify, and delete data 
B)  create and administer a database 
C)  show data in a structured context 
D)  minimize the use of SQL in a database

Question 19

Bill, a database designer, says that the tables in the manager's database are not normalized. What does he mean by this?

Accepted Answer

A)  He means that the tables have irregular, not-normal data. 
B)  He means that the tables have a format that could cause data integrity problems. 
C)  He means that the tables do not have duplicated data. 
D)  He means that the tables do not represent entities. 
A)  He means that the tables have irregular, not-normal data. 
B)  He means that the tables have a format that could cause data integrity problems. 
C)  He means that the tables do not have duplicated data. 
D)  He means that the tables do not represent entities.

Question 20

Access and SQL Server are examples of DBMS products.

Accepted Answer

A) True 
 B)False

Which of the following database administration tasks is associated with database backup and recovery?

Explain the different database administration tasks associated with the backup and recovery of databases.

Which of the following is true of database application programs?

Which of the following statements about Structured Query Language is true?

The database design team transforms entities into tables and expresses relationships by defining foreign keys.

What are the components of a database application system?

A database is called self-describing because it reduces data duplication.

Surrogate keys are unique identifiers assigned by the DBMS.

Normalized tables cannot eliminate data duplication, but they can be faster to process.

In a database, records refer to the data in columns.

Which of the following database administration tasks is associated with database operation?

What are maximum cardinalities and minimum cardinalities?

Explain the different operation database administration tasks.

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

Developers use ________ to define the entities that will be stored in the database and the relationships among those entities.

What are metadata? How are metadata used in databases?

The easiest time to change the database structure is during the ________ stage.

Reports are used to ________.

Bill, a database designer, says that the tables in the manager's database are not normalized. What does he mean by this?

Access and SQL Server are examples of DBMS products.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters

Exam 4: Database Processing

Which of the following database administration tasks is associated with database backup and recovery?

Explain the different database administration tasks associated with the backup and recovery of databases.

Which of the following is true of database application programs?

Which of the following statements about Structured Query Language is true?

The database design team transforms entities into tables and expresses relationships by defining foreign keys.

What are the components of a database application system?

A database is called self-describing because it reduces data duplication.

Surrogate keys are unique identifiers assigned by the DBMS.

Normalized tables cannot eliminate data duplication, but they can be faster to process.

In a database, records refer to the data in columns.

Which of the following database administration tasks is associated with database operation?

What are maximum cardinalities and minimum cardinalities?

Explain the different operation database administration tasks.

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

Developers use ________ to define the entities that will be stored in the database and the relationships among those entities.

What are metadata? How are metadata used in databases?

The easiest time to change the database structure is during the ________ stage.

Reports are used to ________.

Bill, a database designer, says that the tables in the manager's database are not normalized. What does he mean by this?

Access and SQL Server are examples of DBMS products.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters