Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

Salesforce...

View Answer

____________________ is a common data type that includes letters, numbers, or special characters.

Correct Answer

verifed

verified

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?


A) dynamic
B) interactive
C) collaborative
D) continuous

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?


A) guides you through the steps of creating a database object
B) the database creator and administrator
C) a screen in which you enter or modify data
D) the instructions that control how the data in the database is connected

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?


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

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT What is another term for data dictionary?


A) index
B) repository
C) file
D) table

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

  Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called? A)  QBA B)  SQL C)  QBE D)  schema Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?


A) QBA
B) SQL
C) QBE
D) schema

E) B) and D)
F) All of the above

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?


A) rollforward
B) rollbackward
C) continuous backup
D) instant restoration

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

Critical Thinking Questions Case 11-1 In your new role as a DBA, you have inherited a database that has a lot of problems. Your first task, you decide, is to identify whether or not the information in your database contains the qualities of valuable information, and which quality may be missing. The manager for the eastern division sales force is upset because she wants to determine which members of her sales force need awards for high monthly sales, and which employees need remediation because they have not sold enough product during the past month. However, all of the sales information has not yet been entered into the database. What kind of information is at issue in this instance?


A) useful information
B) timely information
C) accessible information
D) verifiable information

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Which of the following statements is not true about report writers?


A) You use a report writer only to retrieve data.
B) Report writers usually allow you to format page numbers and dates; titles and column headings; subtotals and totals; and fonts, font sizes, color, and shading.
C) The capability of creating reports is rare in a DBMS.
D) Some report writers allow you to include images.

E) All of the above
F) C) and D)

Correct Answer

verifed

verified

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


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

E) C) and D)
F) A) and D)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?


A) accurate
B) verifiable
C) useful
D) expensive

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
Whether designed for a small or large computer, most DBMSs perform common ones.
A field that uniquely identifies each record in a file.
What is done to a record so the DBMS will not process it again.
Information that is error free.
Information that has meaning to the person who receives it.
In addition to storing data, a relational database also stores these.
What each byte represents in ASCII.
Phrase that points out the accuracy of a computer's output depends on the accuracy of the input.
The more errors the data contains, the lower this is.
Information that is arranged to suit the needs and requirements of the decision maker.
This type of information can lead to incorrect decisions.
Information that should give more value than it costs to produce.
Information that has an age suited to its use.
Eight bits grouped together in a unit comprise this.
Information that can be proven as correct or incorrect.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
Has special keywords and rules that users include in SQL statements.
This database capability is one of the more powerful database features.
A group of related fields.
While a user is working with the database, this resides in the memory of the computer.
Responses
flagged
inaccurate
functions
timely
integrity
validation
relationships
verifiable
primary key
accurate
byte
DBMS
querying
record
cost-effective
character
useful
SQL
GIGO
organized

Correct Answer

Whether designed for a small or large computer, most DBMSs perform common ones.
A field that uniquely identifies each record in a file.
What is done to a record so the DBMS will not process it again.
Information that is error free.
Information that has meaning to the person who receives it.
In addition to storing data, a relational database also stores these.
What each byte represents in ASCII.
Phrase that points out the accuracy of a computer's output depends on the accuracy of the input.
The more errors the data contains, the lower this is.
Information that is arranged to suit the needs and requirements of the decision maker.
This type of information can lead to incorrect decisions.
Information that should give more value than it costs to produce.
Information that has an age suited to its use.
Eight bits grouped together in a unit comprise this.
Information that can be proven as correct or incorrect.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
Has special keywords and rules that users include in SQL statements.
This database capability is one of the more powerful database features.
A group of related fields.
While a user is working with the database, this resides in the memory of the computer.

To assist with sound decision making, the information must have value.

A) True
B) False

Correct Answer

verifed

verified

Compared with relational databases, which of the following is NOT true of object-oriented databases?


A) They can store more types of data.
B) They access data faster.
C) They allow programmers to reuse objects.
D) They store unstructured information less efficiently.

E) None of the above
F) All of the above

Correct Answer

verifed

verified

Timely information has an age suited to its use.

A) True
B) False

Correct Answer

verifed

verified

____________________ information is available when a decision maker needs it.

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT What company did Larry Ellison help found?


A) Oracle
B) Sun Microsystems
C) Sybase
D) Microsoft

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

Which of the following, with regard to the entire database, should be made on a regular basis?


A) backup
B) baseline
C) after image
D) retread

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

Showing 21 - 40 of 181

Related Exams

Show Answer