Question 1

What does metadata include?

Accepted Answer

Metadata includes:
-The source of the data,including contact information.
-Tables that are related to the data.
-Field and index information,such as the size and type of the field (e.g.,whether it is text or numeric),and the ways the data is sorted.
-Programs and processes that use the data.
-Population rules: what is inserted,or updated,and how often.

Question 2

In the database approach,a(n)_________ is any object about which an organization chooses to collect data.

Accepted Answer

entity

Question 3

-------- means data about data.

Accepted Answer

Metadata

Question 4

In the_________ phase,specialists ensure that all data is consistent.

Accepted Answer

A) loading 
B) extraction 
C) transformation 
D) divisional 
A) loading 
B) extraction 
C) transformation 
D) divisional

Question 5

In relational database,a record or row is called a_________ .

Accepted Answer

A) tuple 
B) attribute 
C) table 
D) relation 
A) tuple 
B) attribute 
C) table 
D) relation

Question 6

One of the most useful manipulations of object-oriented databases (ODBs) is the creation of a new table from two or more other tables.

Accepted Answer

A) True 
 B)False

Question 7

Organizations often organize their data warehouse as a collection of_________ ,smaller collections of data that focus on a particular subject or department.

Accepted Answer

The answer of Organizations often organize their data warehouse as...

Question 8

A(n)_________is the field by which records in a table are uniquely identified.

Accepted Answer

A) database model 
B) query 
C) primary key 
D) object 
A) database model 
B) query 
C) primary key 
D) object

Question 9

In the context of data management, _________refers to all the occurrences sharing the same types of data.

Accepted Answer

A) metadata 
B) entity 
C) encapsulation 
D) schema 
A) metadata 
B) entity 
C) encapsulation 
D) schema

Question 10

To retrieve records from a relational database,or to sort them,you must use a key.

Accepted Answer

A) True 
 B)False

Question 11

A(n)_________ is created "on the fly" as a result of a query and exists only for the duration the user wishes to view it or to create a paper report from it.

Accepted Answer

A) join table 
B) two-way table 
C) object table 
D) entity table 
A) join table 
B) two-way table 
C) object table 
D) entity table

Question 12

A challenge with traditional file storage is _________.

Accepted Answer

A) low data redundancy 
B) high data accuracy 
C) high data integrity 
D) low data misrepresentation 
A) low data redundancy 
B) high data accuracy 
C) high data integrity 
D) low data misrepresentation

Question 13

The conceptual blueprint of a database is called a(n)_________ .

Accepted Answer

A) structured query language (SQL) 
B) uniform resource diagram (UR
D)  
C) entity relationship diagram (ER
D)  
D) unified modeling language (UML) 
A) structured query language (SQL) 
B) uniform resource diagram (UR
D)  
C) entity relationship diagram (ER
D)  
D) unified modeling language (UML)

Question 14

A collection of related records,such as all the records of a college's students,is called a(n) _________.

Accepted Answer

A) field 
B) character 
C) item 
D) file 
A) field 
B) character 
C) item 
D) file

Question 15

Discuss the security issues concerning databases.

Accepted Answer

The use of databases raises security and

Question 16

From a technical point of view,online databases that are used with Web browsers are different from other databases.

Accepted Answer

A) True 
 B)False

Question 17

The combined storage of both data and the procedures that manipulate the data within an object is referred to as
_____.

Accepted Answer

A) compression 
B) packaging 
C) encapsulation 
D) zipping 
A) compression 
B) packaging 
C) encapsulation 
D) zipping

Question 18

There are two overall approaches to maintaining data: the traditional file approach-which has no mechanism for tagging,retrieving,and manipulating data-and the_________ ,which does have this mechanism.

Accepted Answer

A) database approach 
B) object-oriented approach 
C) asymmetric approach 
D) indexed file approach 
A) database approach 
B) object-oriented approach 
C) asymmetric approach 
D) indexed file approach

Question 19

A(n) _________creates a temporary table that is a subset of the original table or tables.

Accepted Answer

relational

Question 20

The larger the data warehouse,the larger the storage capacity,the greater the memory,and the greater the processing power of the computers that are needed.

Accepted Answer

A) True 
 B)False

What does metadata include?

In the database approach,a(n)_________ is any object about which an organization chooses to collect data.

-------- means data about data.

In the_________ phase,specialists ensure that all data is consistent.

In relational database,a record or row is called a_________ .

One of the most useful manipulations of object-oriented databases (ODBs) is the creation of a new table from two or more other tables.

Organizations often organize their data warehouse as a collection of_________ ,smaller collections of data that focus on a particular subject or department.

A(n)_________is the field by which records in a table are uniquely identified.

In the context of data management, _________refers to all the occurrences sharing the same types of data.

To retrieve records from a relational database,or to sort them,you must use a key.

A(n)_________ is created "on the fly" as a result of a query and exists only for the duration the user wishes to view it or to create a paper report from it.

A challenge with traditional file storage is _________.

The conceptual blueprint of a database is called a(n)_________ .

A collection of related records,such as all the records of a college's students,is called a(n) _________.

Discuss the security issues concerning databases.

From a technical point of view,online databases that are used with Web browsers are different from other databases.

The combined storage of both data and the procedures that manipulate the data within an object is referred to as _____.

There are two overall approaches to maintaining data: the traditional file approach-which has no mechanism for tagging,retrieving,and manipulating data-and the_________ ,which does have this mechanism.

A(n) _________creates a temporary table that is a subset of the original table or tables.

The larger the data warehouse,the larger the storage capacity,the greater the memory,and the greater the processing power of the computers that are needed.

Business Information Systems

Strategic Uses of Information Systems

Business Functions and Supply Chains

Business Hardware

Business Software

Business Networks and Telecommunications

The Web-Enabled Enterprise

Challenges of Global Information Systems

Decision Support and Expert Systems

Business Intelligence and Knowledge Management

Systems Planning and Development

Choices in Systems Acquisition

Risks, Security, and Disaster Recovery

Filters

Exam 7: Databases and Data Warehouses

What does metadata include?

In the database approach,a(n)_________ is any object about which an organization chooses to collect data.

-------- means data about data.

In the_________ phase,specialists ensure that all data is consistent.

In relational database,a record or row is called a_________ .

One of the most useful manipulations of object-oriented databases (ODBs) is the creation of a new table from two or more other tables.

Organizations often organize their data warehouse as a collection of_________ ,smaller collections of data that focus on a particular subject or department.

A(n)_________is the field by which records in a table are uniquely identified.

In the context of data management, _________refers to all the occurrences sharing the same types of data.

To retrieve records from a relational database,or to sort them,you must use a key.

A(n)_________ is created "on the fly" as a result of a query and exists only for the duration the user wishes to view it or to create a paper report from it.

A challenge with traditional file storage is _________.

The conceptual blueprint of a database is called a(n)_________ .

A collection of related records,such as all the records of a college's students,is called a(n) _________.

Discuss the security issues concerning databases.

From a technical point of view,online databases that are used with Web browsers are different from other databases.

The combined storage of both data and the procedures that manipulate the data within an object is referred to as _____.

There are two overall approaches to maintaining data: the traditional file approach-which has no mechanism for tagging,retrieving,and manipulating data-and the_________ ,which does have this mechanism.

A(n) _________creates a temporary table that is a subset of the original table or tables.

The larger the data warehouse,the larger the storage capacity,the greater the memory,and the greater the processing power of the computers that are needed.

Business Information Systems

Strategic Uses of Information Systems

Business Functions and Supply Chains

Business Hardware

Business Software

Business Networks and Telecommunications

The Web-Enabled Enterprise

Challenges of Global Information Systems

Decision Support and Expert Systems

Business Intelligence and Knowledge Management

Systems Planning and Development

Choices in Systems Acquisition

Risks, Security, and Disaster Recovery

Filters