Exam 11: Information and Data Management

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

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

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

Discuss at least four strengths of the database approach.

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

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

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

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?

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.

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

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

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

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?

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

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?

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?

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

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

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

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