Filters
Question type

Study Flashcards

COGNITIVE ASSESSMENT Which of the following statements is NOT true about the database approach?


A) The database approach allows nontechnical users to access and maintain data.
B) Databases require more memory, storage, and processing power than file processing systems.
C) A disadvantage to the database approach is isolated data.
D) The database approach increases the data's integrity.

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

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data?


A) a database
B) information
C) a DBMS
D) access

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

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?


A) recovery disk
B) backup
C) index
D) log

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

Correct Answer

verifed

verified

  Which of the following kind of checks is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers? A)  group B)  numeric C)  range D)  integer Which of the following kind of checks is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers?


A) group
B) numeric
C) range
D) integer

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

Correct Answer

verifed

verified

Which of the following is an item that contains data, as well as the actions that read or process the data?


A) object
B) hyperlink
C) action link
D) event

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

Correct Answer

verifed

verified

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


A) query
B) index
C) ask
D) inquiry

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

Correct Answer

verifed

verified

Discuss at least four strengths of the database approach.

Correct Answer

verifed

verified

Student responses will vary, but should ...

View Answer

COGNITIVE ASSESSMENT You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?


A) object-oriented
B) object-relational
C) relational
D) multi-dimensional

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

Correct Answer

verifed

verified

CAE aids in the development and testing of product designs, and often includes CAD.

A) True
B) False

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT If you are running a check that applies a formula to the primary key, what kind of check are you running?


A) completeness
B) alphabetic
C) range
D) check digit

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

Correct Answer

verifed

verified

  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? A)  range B)  numeric C)  completeness D)  consistency 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?


A) range
B) numeric
C) completeness
D) consistency

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

Correct Answer

verifed

verified

____________________ information is arranged to suit the needs and requirements of a decision maker.

Correct Answer

verifed

verified

DBMSs will process flagged records unless an instruction is issued to ignore them.

A) True
B) False

Correct Answer

verifed

verified

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

A) True
B) False

Correct Answer

verifed

verified

DBMSs that maintain inactive data for an extended period of time seldom flag records.

A) True
B) False

Correct Answer

verifed

verified

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

A) True
B) False

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. Once you have worked with the data entry team to make sure that they are getting the monthly sales data into the database in a timely fashion, your next challenge is to change the method of disseminating this information from a printed report that is snail-mailed to all sales managers across the country, to an online dissemination strategy that emails the reports to the managers. What kind of information is at issue in this instance?


A) cost-effective information
B) organized information
C) useful information
D) verifiable information

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

Correct Answer

verifed

verified

Object-oriented and object-relational databases often use a query language to manipulate and retrieve data. What is the name of this query language?


A) OQL
B) SQL
C) TQL
D) AQL

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

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Which of the following is not a way that a DBMS deals with deleting records from a database?


A) remove the record from the file immediately
B) records cannot be deleted from a DBMS
C) flags the record so that the DBMS will not process it again
D) running a program to remove records that have been marked as deleted

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

Correct Answer

verifed

verified

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?


A) viewing
B) writing
C) reading
D) access

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

Correct Answer

verifed

verified

Showing 61 - 80 of 181

Related Exams

Show Answer