Question 1

In comparison with flat file systems,databases:

Accepted Answer

A)  minimize data redundancy.
B)  are easier to design.
C)  have less sophisticated security measures.
D)  require more storage space.

Question 2

In a relational database model,which operation pares down a table by eliminating columns according to certain criteria?

Accepted Answer

A)  project operation
B)  join operation
C)  find operation
D)  insert operation

Question 3

Discuss why an organization might choose a distributed database.

Accepted Answer

Answers will vary.A distributed database...

Question 4

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Accepted Answer

A) True 
 B)False

Question 5

The data _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

Accepted Answer

A)  manipulation
B)  generation
C)  definition
D)  administration

Question 6

Briefly discuss the advantages and disadvantages of database marketing.

Accepted Answer

Answers will vary.Database marketing off...

Question 7

In data warehouses,_____ is information about data-its content,quality,condition,origin,and other characteristics.

Accepted Answer

A)  metadata
B)  big data
C)  summary data
D)  raw data

Question 8

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

Accepted Answer

A)  tuples
B)  attributes
C)  branches
D)  roots

Question 9

Describe the features and benefits of an object-oriented database.

Accepted Answer

Answers will vary.Like object-oriented p...

Question 10

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

Accepted Answer

A)  database engine
B)  data-driven site
C)  static site
D)  database mine

Question 11

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 model

Question 12

Discuss how data was stored in flat files in the past.Explain the disadvantages associated with the flat file organization.

Accepted Answer

Answers will vary.In the past,data was s...

Question 13

To begin designing a relational database,you must define the _____ by defining each table and the fields in it.

Accepted Answer

A)  physical structure
B)  logical structure
C)  primary key
D)  foreign key

Question 14

The advantage of the _____ access method is that both sequential and random access can be used to access records,depending on the number being accessed.

Accepted Answer

A)  indexed sequential
B)  progressive
C)  direct random
D)  random-serialized

Question 15

Data warehouses are sometimes called hypercubes because they _____.

Accepted Answer

A)  are function oriented
B)  store multidimensional data
C)  capture raw transaction data
D)  manage transactions

Question 16

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Accepted Answer

A) True 
 B)False

Question 17

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 tool

Question 18

Briefly explain the responsibilities of a database administrator (DBA).

Accepted Answer

Answers will vary.A DBA's responsibiliti...

Question 19

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

Accepted Answer

A)  sequential
B)  random
C)  indexed
D)  direct

Question 20

In a _____ model,the relationships among records form a treelike structure.

Accepted Answer

A)  hierarchical
B)  relational
C)  network
D)  spiral

Exam 3: Database Systems,Data Warehouses,and Data Marts

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Briefly explain the responsibilities of a database administrator (DBA).

Correct AnswerverifiedAnswers will vary.A DBA's responsibiliti...View AnswerShow Answer

Discuss why an organization might choose a distributed database.

Correct AnswerverifiedAnswers will vary.A distributed database...View AnswerShow Answer

In a _____ model,the relationships among records form a treelike structure.

Correct AnswerverifiedShow Answer

The advantage of the _____ access method is that both sequential and random access can be used to access records,depending on the number being accessed.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In data warehouses,_____ is information about data-its content,quality,condition,origin,and other characteristics.

Correct AnswerverifiedShow Answer

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Correct AnswerverifiedShow Answer

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

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

In a relational database model,which operation pares down a table by eliminating columns according to certain criteria?

Correct AnswerverifiedShow Answer

The data _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

Correct AnswerverifiedShow Answer

Describe the features and benefits of an object-oriented database.

Correct AnswerverifiedAnswers will vary.Like object-oriented p...View AnswerShow Answer

To begin designing a relational database,you must define the _____ by defining each table and the fields in it.

Correct AnswerverifiedShow Answer

In comparison with flat file systems,databases:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Data warehouses are sometimes called hypercubes because they _____.

Correct AnswerverifiedShow Answer

Discuss how data was stored in flat files in the past.Explain the disadvantages associated with the flat file organization.

Correct AnswerverifiedAnswers will vary.In the past,data was s...View AnswerShow Answer

Briefly discuss the advantages and disadvantages of database marketing.

Correct AnswerverifiedAnswers will vary.Database marketing off...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.A DBA's responsibiliti...
View Answer

Correct Answer
verified
Answers will vary.A distributed database...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.Like object-oriented p...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers will vary.In the past,data was s...
View Answer

Correct Answer
verified
Answers will vary.Database marketing off...
View Answer