Question 1

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

Accepted Answer

A)   data warehouse
B)   data mart
C)   data dictionary
D)   data modelE) C) and D)
F) A) and B)

Question 2

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following types of databases is not limited by the data's physical location?

Accepted Answer

A)   A distributed database
B)   A relational database
C)   A multi-structured database
D)   A semi-structured databaseE) A) and B)
F) A) and C)

Question 4

Describe how records are accessed in a random access file structure.

Accepted Answer

Answers will vary.In a random access fil...

Question 5

In a relational database model, a(n)  _____ pares down a table by eliminating columns according to certain criteria.

Accepted Answer

A)   project operation
B)   join operation
C)   find operation
D)   insert operationE) A) and C)
F) C) and D)

Question 6

Discuss the advantages of data marts over data warehouses.

Accepted Answer

Answers will vary.Data marts have the fo...

Question 7

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Accepted Answer

A) True 
 B)False

Question 8

A _____is software for creating, storing, maintaining, and accessing database files. ​

Accepted Answer

A)   database management system
B)   data hierarchical system
C)   database modelling tool
D)   data warehousing toolE) C) and D)
F) None of the above

Question 9

_____tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels. ​

Accepted Answer

A)   Online analytical processing
B)   Online transaction processing
C)   Extraction, transformation, and loading
D)   Business analyticsE) B) and C)
F) A) and B)

Question 10

In a relational database model, the columns are called _____.

Accepted Answer

A)   attributes
B)   tuples
C)   branches
D)   rootsE) A) and B)
F) A) and C)

Question 11

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Accepted Answer

A)   Database mining
B)   Database marketing
C)   Data encapsulation
D)   Data normalizationE) All of the above
F) None of the above

Question 12

Which of the following statements is true of database marketing?

Accepted Answer

A)   It works by using univariate analysis to transform marketing from a proactive to a reactive process.
B)   It works by utilizing information that can be found outside the organizational database.
C)   It makes an organization responsive to the needs of its customers.
D)   It allows an organization to resist changes in the marketplace.E) C) and D)
F) A) and D)

Question 13

In the context of the data administration component of a database management system (DBMS) , the acronym CRUD stands for _____.

Accepted Answer

A)   create, read, update, and delete
B)   copy, revise, undo, and define
C)   create, repeat, undo, and develop
D)   copy, read, update, and defineE) All of the above
F) B) and D)

Question 14

In comparison with a flat file system, _____ in a database.

Accepted Answer

A)   storage space is reduced
B)   programs and data are interdependent
C)   complex requests cannot be handled easily
D)   data redundancy is introducedE) A) and B)
F) A) and C)

Question 15

In a relational database, every record must be uniquely identified by a _____. ​

Accepted Answer

A)   primary key
B)   super key
C)   remote key
D)   candidate keyE) B) and C)
F) C) and D)

Question 16

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

A)   Triangulation
B)   Fragmentation
C)   Normalization
D)   EncapsulationE) A) and C)
F) None of the above

Question 17

Static Web sites are useful for e-commerce sites that need frequent updates.

Accepted Answer

A) True 
 B)False

Question 18

In a(n)  _____, records can be accessed in any order, regardless of their physical locations in storage media. ​

Accepted Answer

A)   sequential access file structure
B)   random access file structure
C)   indexed access file structure
D)   direct access file structureE) B) and C)
F) All of the above

Question 19

Unlike data in databases, data in data warehouses is:

Accepted Answer

A)   function oriented.
B)   raw transaction data.
C)   collected from a single source.
D)   used for analytical purposes.E) All of the above
F) B) and C)

Question 20

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Accepted Answer

A) True 
 B)False

Exam 3: Database Systems, Data Warehouses and Data Marts

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Correct AnswerverifiedShow Answer

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

Correct AnswerverifiedShow Answer

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Correct AnswerverifiedShow Answer

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Correct AnswerverifiedShow Answer

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Correct AnswerverifiedShow Answer

Discuss the advantages of data marts over data warehouses.

Correct AnswerverifiedAnswers will vary.Data marts have the fo...View AnswerShow Answer

Describe how records are accessed in a random access file structure.

Correct AnswerverifiedAnswers will vary.In a random access fil...View AnswerShow Answer

Which of the following statements is true of database marketing?

Correct AnswerverifiedShow Answer

In a(n) _____, records can be accessed in any order, regardless of their physical locations in storage media. ​

Correct AnswerverifiedShow Answer

A _____is software for creating, storing, maintaining, and accessing database files. ​

Correct AnswerverifiedShow Answer

In a relational database model, a(n) _____ pares down a table by eliminating columns according to certain criteria.

Correct AnswerverifiedShow Answer

Unlike data in databases, data in data warehouses is:

Correct AnswerverifiedShow Answer

In comparison with a flat file system, _____ in a database.

Correct AnswerverifiedShow Answer

Which of the following types of databases is not limited by the data's physical location?

Correct AnswerverifiedShow Answer

Static Web sites are useful for e-commerce sites that need frequent updates.

Correct AnswerverifiedShow Answer

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Correct AnswerverifiedShow Answer

_____tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels. ​

Correct AnswerverifiedShow Answer

In a relational database, every record must be uniquely identified by a _____. ​

Correct AnswerverifiedShow Answer

In the context of the data administration component of a database management system (DBMS) , the acronym CRUD stands for _____.

Correct AnswerverifiedShow Answer

In a relational database model, the columns are called _____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.Data marts have the fo...
View Answer

Correct Answer
verified
Answers will vary.In a random access fil...
View Answer

Correct Answer
verified

In a(n) _____, records can be accessed in any order, regardless of their physical locations in storage media.

Correct Answer
verified

A _____is software for creating, storing, maintaining, and accessing database files.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

_____tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

Correct Answer
verified

In a relational database, every record must be uniquely identified by a _____.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified