Question 1

Which of the following refers to the procedures that keep data current?

Accepted Answer

A)   file maintenance
B)   authentication integrity
C)   data validation
D)   information checkingE) C) and D)
F) None of the above

Question 2

Data warehouses often use a process called data ____________________ to find patterns and relationships among data.

Accepted Answer

The answer of Data warehouses often use a process called...

Question 3

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only numeric data into a field?

Accepted Answer

A)   range
B)   numeric
C)   completeness
D)   consistencyE) C) and D)
F) A) and D)

Question 4

COGNITIVE ASSESSMENT In your school's database, in which of the following is all of the information about a particular student stored?

Accepted Answer

A)   a field
B)   a character
C)   a record
D)   a reportE) All of the above
F) A) and B)

Question 5

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Accepted Answer

A)   restoration principle
B)   forward recovery
C)   continuous backup
D)   rollbackE) All of the above
F) B) and C)

Question 6

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

Accepted Answer

The answer of The ____________________ identifies users' access privileges, defines...

Question 7

The developer of a relational database refers to a file as which of the following?

Accepted Answer

A)   attribute
B)   record
C)   relation
D)   tupleE) A) and D)
F) All of the above

Question 8

Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?

Accepted Answer

A)   before image
B)   front end
C)   after image
D)   back endE) None of the above
F) A) and B)

Question 9

Which of the following stores data in objects?

Accepted Answer

A)   ADB
B)   OTDB
C)   EDB
D)   OODBE) B) and D)
F) B) and C)

Question 10

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?

Accepted Answer

A)   validator
B)   rubric
C)   set
D)   fileE) A) and B)
F) None of the above

Question 11

An application that supports a front-end program sometimes is called which of the following?

Accepted Answer

A)   back end
B)   RDBMS
C)   GUI
D)   collaborative databaseE) B) and D)
F) B) and C)

Question 12

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is an advantage of a multidimensional database?

Accepted Answer

A)   There is a common query language.
B)   The content of all dimensions is the same regardless of the subject.
C)   It can consolidate data much faster than a relational database.
D)   All multidimensional databases have a dimension of time.E) A) and B)
F) A) and C)

Question 14

A user of a database such as that pictured in the accompanying figure refers to a file as what?

Accepted Answer

A)   table
B)   column
C)   row
D)   relationshipE) A) and B)
F) A) and D)

Question 15

Most information is important to all people and groups of people.

Accepted Answer

A) True 
 B)False

Question 16

____________________ helps salespeople manage customer contacts, schedule customer meetings, log customer interactions, manage product information, and place customer orders.

Accepted Answer

Salesforce...

Question 17

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Accepted Answer

A)   completeness
B)   alphabetic
C)   range
D)   check digitE) A) and C)
F) None of the above

Question 18

COGNITIVE ASSESSMENT Which of the following statements is not true about relational databases?

Accepted Answer

A)   A relationship is a link within the data.
B)   To set up a relationship between tables, they must have a common field.
C)   Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing.
D)   Applications best suited for relational databases are those whose data can be organized into a three-dimensional table.E) B) and C)
F) A) and D)

Question 19

A user of a database such as that pictured in the accompanying figure refers to a record as what?

Accepted Answer

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

Question 20

The developer of a relational database refers to a record as which of the following?

Accepted Answer

A)   tuple
B)   field
C)   attribute
D)   relationE) All of the above
F) B) and D)

Exam 11: Information and Data Management: Organizing, Verifying, Maintaining, and Accessing

An application that supports a front-end program sometimes is called which of the following?

Correct AnswerverifiedShow Answer

Which of the following stores data in objects?

Correct AnswerverifiedShow Answer

Which of the following refers to the procedures that keep data current?

Correct AnswerverifiedShow Answer

Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?

Correct AnswerverifiedShow Answer

The developer of a relational database refers to a file as which of the following?

Correct AnswerverifiedShow Answer

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only numeric data into a field?

Correct AnswerverifiedShow Answer

____________________ helps salespeople manage customer contacts, schedule customer meetings, log customer interactions, manage product information, and place customer orders.

Correct AnswerverifiedSalesforce...View AnswerShow Answer

A user of a database such as that pictured in the accompanying figure refers to a record as what?

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT Which of the following statements is not true about relational databases?

Correct AnswerverifiedShow Answer

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

Correct AnswerverifiedShow Answer

The developer of a relational database refers to a record as which of the following?

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT In your school's database, in which of the following is all of the information about a particular student stored?

Correct AnswerverifiedShow Answer

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Correct AnswerverifiedShow Answer

A user of a database such as that pictured in the accompanying figure refers to a file as what?

Correct AnswerverifiedShow Answer

Most information is important to all people and groups of people.

Correct AnswerverifiedShow Answer

Data warehouses often use a process called data ____________________ to find patterns and relationships among data.

Correct AnswerverifiedShow Answer

Which of the following is an advantage of a multidimensional database?

Correct AnswerverifiedShow Answer

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Salesforce...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified