Question 1

Which of the following is used to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategies?

Accepted Answer

A)  data warehouse 
B)  operational database 
C)  data dictionary 
D)  shadow system 
A)  data warehouse 
B)  operational database 
C)  data dictionary 
D)  shadow system A

Question 2

In a relational database, information is organized into tables in which each row represents a(n ) ________.

Accepted Answer

A)  record 
B)  field 
C)  attribute 
D)  primary key 
A)  record 
B)  field 
C)  attribute 
D)  primary key A

Question 3

In Astec Limited, the HR department did not include interns as employees in their database, while the finance department included them. Such inconsistencies can be avoided through ________.

Accepted Answer

A)  shadow system 
B)  normalization 
C)  database schema 
D)  master data management 
A)  shadow system 
B)  normalization 
C)  database schema 
D)  master data management D

Question 4

An e-commerce Web site stores sales transactions with clearly defined fields for date, customer number, item number, invoice number, and amount. This is an example of which type of information resource?

Accepted Answer

A)  unstructured information 
B)  semi-structured information 
C)  structured information 
D)  shard information 
A)  unstructured information 
B)  semi-structured information 
C)  structured information 
D)  shard information

Question 5

A network database supports many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 6

Which process assigns incremental numbers to records as they are created to ensure that each record has a unique primary key?

Accepted Answer

A)  normalization 
B)  functional numbering 
C)  standardization 
D)  autonumbering 
A)  normalization 
B)  functional numbering 
C)  standardization 
D)  autonumbering

Question 7

What is a database? Why is it a better system of information organization compared to a file processing system?

Accepted Answer

The database is an integrated collection

Question 8

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

Accepted Answer

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

Question 9

Describe the most common strategy for creating a data warehouse.

Accepted Answer

The common strategy for drawing informat

Question 10

The database management software Oracle uses which type of database architecture?

Accepted Answer

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

Question 11

What are the functions of database management software (DBMS)? Name some common database management software.

Accepted Answer

Database management software (DBMS) is u

Question 12

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 13

During mergers, integration of multiple databases becomes a major challenge.

Accepted Answer

A) True 
 B)False

Question 14

What are the characteristics of high-quality information?

Accepted Answer

High-quality information is accurate, pr

Question 15

________ specifies the characteristics of a field, such as the type of data it will hold.

Accepted Answer

A)  Data definition 
B)  File processing system 
C)  Database architecture 
D)  Network database 
A)  Data definition 
B)  File processing system 
C)  Database architecture 
D)  Network database

Question 16

A legal firm has a back room stacked with boxes containing files of hundreds of cases. This is an example of ________.

Accepted Answer

A)  semi-structured information 
B)  unstructured information 
C)  meta data 
D)  relational data 
A)  semi-structured information 
B)  unstructured information 
C)  meta data 
D)  relational data

Question 17

A database schema is used to ________.

Accepted Answer

A)  graphically document the data model 
B)  record the details of the fields in a table 
C)  create a backup of the database 
D)  identify redundant information in the database 
A)  graphically document the data model 
B)  record the details of the fields in a table 
C)  create a backup of the database 
D)  identify redundant information in the database

Question 18

Database developers avoid using meaningful information for primary keys.

Accepted Answer

A) True 
 B)False

Question 19

An early database approach that linked records based on graded or ranked relationships, such as that in the organizational chart, is called ________.

Accepted Answer

A)  hierarchical database 
B)  network database 
C)  stratified database 
D)  cluster database 
A)  hierarchical database 
B)  network database 
C)  stratified database 
D)  cluster database

Question 20

Which of the following ensures that there will be minimum redundancy in a relational database?

Accepted Answer

A)  foreign key 
B)  autonumbering 
C)  functional ID 
D)  one to one relationships 
A)  foreign key 
B)  autonumbering 
C)  functional ID 
D)  one to one relationships

Which of the following is used to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategies?

In a relational database, information is organized into tables in which each row represents a(n ) ________.

In Astec Limited, the HR department did not include interns as employees in their database, while the finance department included them. Such inconsistencies can be avoided through ________.

An e-commerce Web site stores sales transactions with clearly defined fields for date, customer number, item number, invoice number, and amount. This is an example of which type of information resource?

A network database supports many-to-many relationships.

Which process assigns incremental numbers to records as they are created to ensure that each record has a unique primary key?

What is a database? Why is it a better system of information organization compared to a file processing system?

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

Describe the most common strategy for creating a data warehouse.

The database management software Oracle uses which type of database architecture?

What are the functions of database management software (DBMS)? Name some common database management software.

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

During mergers, integration of multiple databases becomes a major challenge.

What are the characteristics of high-quality information?

________ specifies the characteristics of a field, such as the type of data it will hold.

A legal firm has a back room stacked with boxes containing files of hundreds of cases. This is an example of ________.

A database schema is used to ________.

Database developers avoid using meaningful information for primary keys.

An early database approach that linked records based on graded or ranked relationships, such as that in the organizational chart, is called ________.

Which of the following ensures that there will be minimum redundancy in a relational database?

Information Systems and People

Systems Development and Procurement

Project Management and Strategic Planning

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web and E-Commerce

Ethics, Privacy, and Security

Business Intelligence and Decision Support

Collaborating with Technology

Knowledge Management and E-Learning

Filters

Exam 4: Managing Information Resources with Databases

Which of the following is used to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategies?

In a relational database, information is organized into tables in which each row represents a(n ) ________.

In Astec Limited, the HR department did not include interns as employees in their database, while the finance department included them. Such inconsistencies can be avoided through ________.

An e-commerce Web site stores sales transactions with clearly defined fields for date, customer number, item number, invoice number, and amount. This is an example of which type of information resource?

A network database supports many-to-many relationships.

Which process assigns incremental numbers to records as they are created to ensure that each record has a unique primary key?

What is a database? Why is it a better system of information organization compared to a file processing system?

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

Describe the most common strategy for creating a data warehouse.

The database management software Oracle uses which type of database architecture?

What are the functions of database management software (DBMS)? Name some common database management software.

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

During mergers, integration of multiple databases becomes a major challenge.

What are the characteristics of high-quality information?

________ specifies the characteristics of a field, such as the type of data it will hold.

A legal firm has a back room stacked with boxes containing files of hundreds of cases. This is an example of ________.

A database schema is used to ________.

Database developers avoid using meaningful information for primary keys.

An early database approach that linked records based on graded or ranked relationships, such as that in the organizational chart, is called ________.

Which of the following ensures that there will be minimum redundancy in a relational database?

Information Systems and People

Systems Development and Procurement

Project Management and Strategic Planning

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web and E-Commerce

Ethics, Privacy, and Security

Business Intelligence and Decision Support

Collaborating with Technology

Knowledge Management and E-Learning

Filters