Question 1

Shadow systems are managed by individuals or departments and not by the central IT staff in an organization.

Accepted Answer

A) True 
 B)False

Question 2

Shadow systems focus on ________.

Accepted Answer

A) specific information requirements of an individual or department 
B) improving the scalability of relational databases 
C) intelligence gathering and strategic planning 
D) reducing redundancies in relational data 
A) specific information requirements of an individual or department 
B) improving the scalability of relational databases 
C) intelligence gathering and strategic planning 
D) reducing redundancies in relational data

Question 3

________ is a process that refines entities and their relationships to help minimize duplication of information in tables.

Accepted Answer

A) Normalization 
B) Autonumbering 
C) Querying 
D) Data modeling 
A) Normalization 
B) Autonumbering 
C) Querying 
D) Data modeling

Question 4

Kris, an IT manager at Park Infosystems, is handling four projects simultaneously. Each project has loaned and shared resources from other teams. The relationship between Kris and the project that he is working on represents a ________.

Accepted Answer

A) one-to-many relationship 
B) many-to-one relationship 
C) many-to-many relationship 
D) one-to-one relationship 
A) one-to-many relationship 
B) many-to-one relationship 
C) many-to-many relationship 
D) one-to-one relationship

Question 5

The early file processing systems were very difficult to maintain because of ________.

Accepted Answer

A) complicated tables and fields with no metadata 
B) data dependency between the programs and files 
C) frequent software upgrades 
D) lack of database administrators and IT personnel 
A) complicated tables and fields with no metadata 
B) data dependency between the programs and files 
C) frequent software upgrades 
D) lack of database administrators and IT personnel

Question 6

The database performance tuning process takes into account ________.

Accepted Answer

A) the system's capacity of scaling 
B) the kind of data accessed by the end users 
C) the language used by users to access the database 
D) the security permissions accorded to different users 
A) the system's capacity of scaling 
B) the kind of data accessed by the end users 
C) the language used by users to access the database 
D) the security permissions accorded to different users

Question 7

Aban Constructions Limited, a construction company, maintains data in the form of records within tables, and the tables are interconnected by linking matching fields. Which type of database architecture does Aban Constructions Limited use?

Accepted Answer

A) hierarchical database 
B) network database 
C) relational database 
D) object-oriented database 
A) hierarchical database 
B) network database 
C) relational database 
D) object-oriented database

Question 8

Which of the following do database developers use to avoid anomalies that result when users try to insert, edit, or delete data?

Accepted Answer

A) autonumbering 
B) accuracy checks 
C) normalization 
D) referential integrity 
A) autonumbering 
B) accuracy checks 
C) normalization 
D) referential integrity

Question 9

Which of the following is a disadvantage of using shadow systems?

Accepted Answer

A) Shadow systems are difficult to create, deploy, and maintain. 
B) Shadow systems cannot be developed by individuals or departments to handle specific information requirements. 
C) Shadow systems contain information that is not consistent with the corporate database. 
D) Shadow systems require extensive IT support and documentation. 
A) Shadow systems are difficult to create, deploy, and maintain. 
B) Shadow systems cannot be developed by individuals or departments to handle specific information requirements. 
C) Shadow systems contain information that is not consistent with the corporate database. 
D) Shadow systems require extensive IT support and documentation.

Question 10

A data model that graphically shows the tables, attributes, keys, and logical relationships for a database is called a ________.

Accepted Answer

A) data graph 
B) shadow schema 
C) database schema 
D) referential schema 
A) data graph 
B) shadow schema 
C) database schema 
D) referential schema

Question 11

Changes to an integrated database take less time from IT but more from the end users.

Accepted Answer

A) True 
 B)False

Question 12

Define relational database. Why are relational databases a standard in most organizations?

Accepted Answer

Relational database is the most widely u

Question 13

A field or a group of fields that make a record unique in a table is called a(n)________.

Accepted Answer

A) primary key 
B) autonumber 
C) central entity 
D) attribute record 
A) primary key 
B) autonumber 
C) central entity 
D) attribute record

Question 14

What approach do database developers use while choosing primary keys for a data model?

Accepted Answer

While choosing primary keys for a data m

Question 15

How is metadata related to information?

Accepted Answer

A) It helps clarify the nature of the information. 
B) It helps gather unstructured information. 
C) It organizes unstructured information to form structured information. 
D) It removes redundant data from unstructured information. 
A) It helps clarify the nature of the information. 
B) It helps gather unstructured information. 
C) It organizes unstructured information to form structured information. 
D) It removes redundant data from unstructured information.

Question 16

Databases that are smaller than enterprise databases and focus on their creators' specific information requirements are known as ________.

Accepted Answer

A) shadow systems 
B) data warehouses 
C) data stewards 
D) referential schemas 
A) shadow systems 
B) data warehouses 
C) data stewards 
D) referential schemas

Question 17

Documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning, is known as ________.

Accepted Answer

A) database schema 
B) data dictionary 
C) data model 
D) data definition 
A) database schema 
B) data dictionary 
C) data model 
D) data definition

Question 18

What is the drawback of using Social Security Numbers (SSN)as the primary key for tables of employees, hospital patients, students, or cable TV customers?

Accepted Answer

A) Typing the nine digit SSN numbers is laborious and time consuming. 
B) Non-U.S. citizens may not have an SSN. 
C) It is not a confidential identification number. 
D) It is not a unique identification number. 
A) Typing the nine digit SSN numbers is laborious and time consuming. 
B) Non-U.S. citizens may not have an SSN. 
C) It is not a confidential identification number. 
D) It is not a unique identification number.

Question 19

The process by which users are directed to a copy of the database when the main one fails is called ________.

Accepted Answer

A) mirroring 
B) threading 
C) tuning 
D) scaling 
A) mirroring 
B) threading 
C) tuning 
D) scaling

Question 20

Batch processing is defined as ________.

Accepted Answer

A) the sequential execution of operations on each record in a large set 
B) the arrangement of data in a table as records and fields 
C) the removal of duplicates from a set of data 
D) the strategy of defining and linking records 
A) the sequential execution of operations on each record in a large set 
B) the arrangement of data in a table as records and fields 
C) the removal of duplicates from a set of data 
D) the strategy of defining and linking records

Shadow systems are managed by individuals or departments and not by the central IT staff in an organization.

Shadow systems focus on ________.

________ is a process that refines entities and their relationships to help minimize duplication of information in tables.

Kris, an IT manager at Park Infosystems, is handling four projects simultaneously. Each project has loaned and shared resources from other teams. The relationship between Kris and the project that he is working on represents a ________.

The early file processing systems were very difficult to maintain because of ________.

The database performance tuning process takes into account ________.

Aban Constructions Limited, a construction company, maintains data in the form of records within tables, and the tables are interconnected by linking matching fields. Which type of database architecture does Aban Constructions Limited use?

Which of the following do database developers use to avoid anomalies that result when users try to insert, edit, or delete data?

Which of the following is a disadvantage of using shadow systems?

A data model that graphically shows the tables, attributes, keys, and logical relationships for a database is called a ________.

Changes to an integrated database take less time from IT but more from the end users.

Define relational database. Why are relational databases a standard in most organizations?

A field or a group of fields that make a record unique in a table is called a(n)________.

What approach do database developers use while choosing primary keys for a data model?

How is metadata related to information?

Databases that are smaller than enterprise databases and focus on their creators' specific information requirements are known as ________.

Documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning, is known as ________.

What is the drawback of using Social Security Numbers (SSN)as the primary key for tables of employees, hospital patients, students, or cable TV customers?

The process by which users are directed to a copy of the database when the main one fails is called ________.

Batch processing is defined as ________.

Information Systems and People

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web, E-Commerce, and M-Commerce

Business Intelligence and Decision Making

Collaborating With Technology

Knowledge Management and E-Learning

Ethics, Privacy, and Security

Systems Development and Procurement

Project Management and Strategic Planning

Filters

Exam 4: Databases and Datawarehouses

Shadow systems are managed by individuals or departments and not by the central IT staff in an organization.

Shadow systems focus on ________.

________ is a process that refines entities and their relationships to help minimize duplication of information in tables.

Kris, an IT manager at Park Infosystems, is handling four projects simultaneously. Each project has loaned and shared resources from other teams. The relationship between Kris and the project that he is working on represents a ________.

The early file processing systems were very difficult to maintain because of ________.

The database performance tuning process takes into account ________.

Aban Constructions Limited, a construction company, maintains data in the form of records within tables, and the tables are interconnected by linking matching fields. Which type of database architecture does Aban Constructions Limited use?

Which of the following do database developers use to avoid anomalies that result when users try to insert, edit, or delete data?

Which of the following is a disadvantage of using shadow systems?

A data model that graphically shows the tables, attributes, keys, and logical relationships for a database is called a ________.

Changes to an integrated database take less time from IT but more from the end users.

Define relational database. Why are relational databases a standard in most organizations?

A field or a group of fields that make a record unique in a table is called a(n)________.

What approach do database developers use while choosing primary keys for a data model?

How is metadata related to information?

Databases that are smaller than enterprise databases and focus on their creators' specific information requirements are known as ________.

Documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning, is known as ________.

What is the drawback of using Social Security Numbers (SSN)as the primary key for tables of employees, hospital patients, students, or cable TV customers?

The process by which users are directed to a copy of the database when the main one fails is called ________.

Batch processing is defined as ________.

Information Systems and People

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web, E-Commerce, and M-Commerce

Business Intelligence and Decision Making

Collaborating With Technology

Knowledge Management and E-Learning

Ethics, Privacy, and Security

Systems Development and Procurement

Project Management and Strategic Planning

Filters