Filters
Question type

Study Flashcards

The data in a database is independent of programs that access that data.

Correct Answer

verifed

verified

Which of the following is NOT considered a part of file maintenance?


A) adding a record to a database
B) modifying data in a record
C) the creation of a new database
D) deleting records from a database

Correct Answer

verifed

verified

Which of the following kind of checks is a validity check performed on data, which ensures users enter only alphabetic data into a field?


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

Correct Answer

verifed

verified

Which of the following statements is NOT true about object-oriented databases (OODBs) ?


A) A voice mail system is an example of a groupware database.
B) An object is an item that contains data, as well as the actions that read or process the data.
C) An OODB stores unstructured data more efficiently than a relational database.
D) OODBs can store more types of data and access it faster than relational databases.

Correct Answer

verifed

verified

Your database was damaged due to hardware failure. What can you use to restore it?


A) a backup
B) imaging software
C) restoration hardware
D) a wizard

Correct Answer

verifed

verified

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


A) instant
B) baseline
C) integrated
D) forward

Correct Answer

verifed

verified

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, blank space, punctuation mark, or other symbol.

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.

Correct Answer

verifed

verified

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?


A) check digit
B) index
C) insertion ordinal
D) integer

Correct Answer

verifed

verified

Data integrity is important because computers and people use information to make decisions and take actions.

Correct Answer

verifed

verified

Which of the following is a window on the screen that provides areas for entering or modifying data in a database?


A) form
B) report
C) change screen
D) recovery screen

Correct Answer

verifed

verified

A(n) ____________________ verifies that a required field contains data.

Correct Answer

verifed

verified

Like a form, a report generator is used to maintain and retrieve data.

Correct Answer

verifed

verified

Which of the following statements is NOT true about multidimensional databases?


A) The number of dimensions in a multidimensional database varies.
B) Most multidimensional databases use a standard query language.
C) Nearly every multidimensional database has a dimension of time.
D) A multidimensional database can consolidate data much faster than a relational database.

Correct Answer

verifed

verified

What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?


A) query
B) verification
C) procedure
D) validation

Correct Answer

verifed

verified

  A user of a database such as that pictured in the accompanying figure refers to a file as what? A)  table B)  column C)  row D)  relationship A user of a database such as that pictured in the accompanying figure refers to a file as what?


A) table
B) column
C) row
D) relationship

Correct Answer

verifed

verified

Who was the inventor of the relational database model?


A) E. L. Coff
B) E. G. Cott
C) E. F. Codd
D) E. L. Codd

Correct Answer

verifed

verified

____________________ is a common data type that consists of an email address or a web address that links to a webpage on the Internet, for example.

Correct Answer

verifed

verified

In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. A quick scan of the data in the First Name field in the database yields the numbers 3 and 7 and an asterisk. What kind of check should you run on this field?


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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

Showing 21 - 40 of 180

Related Exams

Show Answer