Question 1

A compiler is a separate program that converts the entire source program into machine language before executing it.

Accepted Answer

A) True 
 B)False

Question 2

What is data redundancy?

Accepted Answer

A)   There is no primary key to distinguish records.
B)   Each department has its own files, so the same data might be stored in multiple files.
C)   Data is linked to multiple records in a database.
D)   In the same database, each department enters data without checking to ensure it has not already been entered.E) A) and C)
F) None of the above B

Question 3

Which of the following consists of rules and standards that define how a database organizes data?

Accepted Answer

A)   data standard
B)   data model
C)   rules-based integration
D)   object-relationE) None of the above
F) A) and C)

Question 4

A data dictionary contains details about data. What term is used to describe this characteristic?

Accepted Answer

A)   omnidata
B)   maxidata
C)   metadata
D)   duplidataE) A) and D)
F) None of the above C

Question 5

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

Accepted Answer

A) True 
 B)False

Question 6

In a database which of the following is a connection within the data?

Accepted Answer

A)   table
B)   column
C)   row
D)   relationshipE) None of the above
F) A) and B)

Question 7

Machine language is the only language the computer directly recognizes.

Accepted Answer

A) True 
 B)False

Question 8

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Accepted Answer

A) True 
 B)False

Question 9

All DBMSs have built-in backup utilities.

Accepted Answer

A) True 
 B)False

Question 10

Each higher level of data consists of one or more items from the lower level.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is a request for specific data from a database?

Accepted Answer

A)   query
B)   index
C)   ask
D)   inquiryE) A) and B)
F) C) and D)

Question 12

A web database for an organization usually resides on a(n) ____________________.

Accepted Answer

database server

Question 13

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Accepted Answer

A)   database
B)   server
C)   spreadsheet
D)   webbaseE) C) and D)
F) B) and C)

Question 14

A relational database typically processes and summarizes large numbers of records efficiently.

Accepted Answer

A) True 
 B)False

Question 15

Most data items are stored in only one file, which greatly reduces _____.

Accepted Answer

A)   duplicate redundancy
B)   duplicate data
C)   hypertext redundancy
D)   data relationshipsE) B) and C)
F) All of the above

Question 16

Which of the following statements best describes a form?

Accepted Answer

A)   a window on the screen that provides areas for entering or modifying data in a database
B)   a formatted, printable retrieval of specific data
C)   a screen that enables a database user to add or delete tables
D)   the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve dataE) A) and C)
F) A) and B)

Question 17

Which term does a user of a relational database use to refer to a record?

Accepted Answer

A)   row
B)   table
C)   column
D)   attributeE) None of the above
F) All of the above

Question 18

Which of the following is true about the database approach?

Accepted Answer

A)   Data in a database is less vulnerable than data in file processing systems.
B)   Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data.
C)   Business and home users often work with databases because of their numerous advantages.
D)   A database is never more complex than a file processing system.E) C) and D)
F) All of the above

Question 19

A DBMS uses which of the following to perform validation checks?

Accepted Answer

A)   data server
B)   data mart
C)   data warehouse
D)   data dictionaryE) All of the above
F) None of the above

Question 20

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Accepted Answer

A)   data stockyard
B)   data warehouse
C)   data storehouse
D)   data storage unitE) A) and C)
F) All of the above

Exam 11: Building Solutions

A compiler is a separate program that converts the entire source program into machine language before executing it.

Correct AnswerverifiedShow Answer

What is data redundancy?

Correct AnswerverifiedB

Which of the following consists of rules and standards that define how a database organizes data?

Correct AnswerverifiedShow Answer

A data dictionary contains details about data. What term is used to describe this characteristic?

Correct AnswerverifiedC

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

Correct AnswerverifiedShow Answer

In a database which of the following is a connection within the data?

Correct AnswerverifiedShow Answer

Machine language is the only language the computer directly recognizes.

Correct AnswerverifiedShow Answer

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Correct AnswerverifiedShow Answer

All DBMSs have built-in backup utilities.

Correct AnswerverifiedShow Answer

Each higher level of data consists of one or more items from the lower level.

Correct AnswerverifiedShow Answer

Which of the following is a request for specific data from a database?

Correct AnswerverifiedShow Answer

A web database for an organization usually resides on a(n) ____________________.

Correct Answerverifieddatabase server

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Correct AnswerverifiedShow Answer

A relational database typically processes and summarizes large numbers of records efficiently.

Correct AnswerverifiedShow Answer

Most data items are stored in only one file, which greatly reduces _____.

Correct AnswerverifiedShow Answer

Which of the following statements best describes a form?

Correct AnswerverifiedShow Answer

Which term does a user of a relational database use to refer to a record?

Correct AnswerverifiedShow Answer

Which of the following is true about the database approach?

Correct AnswerverifiedShow Answer

A DBMS uses which of the following to perform validation checks?

Correct AnswerverifiedShow Answer

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
database server

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified