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

Most of this kind of database products for servers and mainframes include SQL, an example of which is shown in the accompanying figure. What kind of database product is this?

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

COGNITIVE ASSESSMENT Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

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

You cannot maintain data in a database by importing data.

An object-oriented database stores unstructured data less efficiently than a relational database.

Query by example uses a graphical user interface that assists users with retrieving data.

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

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

Timely information has an age suited to its use.

COGNITIVE ASSESSMENT You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

A data model defines how the operating system actually arranges the data on the disk.

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?

COGNITIVE ASSESSMENT What is another name for a database analyst?

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

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?

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

Many database programs today have a webpage as their back end.