Question 1

Enterprise DBMS products process large organizational and workgroup databases.

Accepted Answer

A) True 
 B)False

Question 2

Database administrators 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) True 
 B)False

Question 3

Which of the following is a database adaptation task?

Accepted Answer

A)  monitoring database performance 
B)  managing configuration change 
C)  monitoring backup procedures 
D)  tracking problems and managing resolution 
A)  monitoring database performance 
B)  managing configuration change 
C)  monitoring backup procedures 
D)  tracking problems and managing resolution

Question 4

A multi-user data base must implement ________ to prevent a lost update problem.

Accepted Answer

A)  encryption 
B)  locking 
C)  decryption 
D)  anti-virus software 
A)  encryption 
B)  locking 
C)  decryption 
D)  anti-virus software

Question 5

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

Question 6

Relationships between tables in a relational database are accomplished by associating a foreign key in one table with a key field in another.

Accepted Answer

A) True 
 B)False

Question 7

Adaptation tasks for a database refer to backup and recovery processes.

Accepted Answer

A) True 
 B)False

Question 8

The format of metadata is consistent across all software products used to process databases.

Accepted Answer

A) True 
 B)False

Question 9

The lost update problem can be solved by locking, which allows coordination of user activities.

Accepted Answer

A) True 
 B)False

Question 10

What is SQL?

Accepted Answer

Structured Query Language (SQL) is an in

Question 11

A ________ is a program used to create, process, and administer a database.

Accepted Answer

A)  distributed data store 
B)  database model 
C)  database transaction 
D)  database management system 
A)  distributed data store 
B)  database model 
C)  database transaction 
D)  database management system

Question 12

In a relational database, every table must have a ________.

Accepted Answer

A)  client 
B)  field 
C)  key 
D)  query 
A)  client 
B)  field 
C)  key 
D)  query

Question 13

The database design team expresses relationships by defining ________.

Accepted Answer

A)  normal forms 
B)  foreign keys 
C)  attributes 
D)  queries 
A)  normal forms 
B)  foreign keys 
C)  attributes 
D)  queries

Question 14

A ________ is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A)  query 
B)  record 
C)  form 
D)  key 
A)  query 
B)  record 
C)  form 
D)  key

Question 15

________ is the process of converting a data model into tables, relationships, and data constraints.

Accepted Answer

A)  Data acquisition 
B)  Database design 
C)  Data enrichment 
D)  Data warehousing 
A)  Data acquisition 
B)  Database design 
C)  Data enrichment 
D)  Data warehousing

Enterprise DBMS products process large organizational and workgroup databases.

Database administrators 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.

Which of the following is a database adaptation task?

A multi-user data base must implement ________ to prevent a lost update problem.

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

Relationships between tables in a relational database are accomplished by associating a foreign key in one table with a key field in another.

Adaptation tasks for a database refer to backup and recovery processes.

The format of metadata is consistent across all software products used to process databases.

The lost update problem can be solved by locking, which allows coordination of user activities.

What is SQL?

A ________ is a program used to create, process, and administer a database.

In a relational database, every table must have a ________.

The database design team expresses relationships by defining ________.

A ________ is a column or group of columns that identifies a unique row in a table.

________ is the process of converting a data model into tables, relationships, and data constraints.

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

Enterprise DBMS products process large organizational and workgroup databases.

Database administrators 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.

Which of the following is a database adaptation task?

A multi-user data base must implement ________ to prevent a lost update problem.

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

Relationships between tables in a relational database are accomplished by associating a foreign key in one table with a key field in another.

Adaptation tasks for a database refer to backup and recovery processes.

The format of metadata is consistent across all software products used to process databases.

The lost update problem can be solved by locking, which allows coordination of user activities.

What is SQL?

A ________ is a program used to create, process, and administer a database.

In a relational database, every table must have a ________.

The database design team expresses relationships by defining ________.

A ________ is a column or group of columns that identifies a unique row in a table.

________ is the process of converting a data model into tables, relationships, and data constraints.

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