Q.1

Locking may cause which of the following problems?

  • Erroneous updates
  • Deadlock
  • Versioning
  • All of the above.
Q.2

Performance analysis and tuning is which of the following?

  • Undertaken one time at the time of a DBMS installation
  • Undertaken one time at the time of the implementation of a new application
  • Undertaken as an ongoing part of the backup of a database
  • Undertaken as an ongoing part of managing a database
Q.3

The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.

  • True
  • False
Q.4

The greatest threat to business security is often internal rather than external.

  • True
  • False
Q.5

Incorrect data is easy to detect.

  • True
  • False
Q.6

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

  • Rollback
  • Rollforward
  • Switch to duplicate database
  • Reprocess transactions
Q.7

Poor data administration can lead to which of the following?

  • A single definition of the same data entity
  • Familiarity with existing data
  • Missing data elements
  • All of the above.
Q.8

Which of the following is true concerning open-source DBMS?

  • Is free or nearly free database software whose source code is publicly available
  • Is free or nearly free database software whose source code is not publicly available
  • Is not competitive against PC-oriented packages and is fully SQL compliant
  • Is competitive against PC-oriented packages and is not fully SQL compliant
Q.9

A traditional data administrator performs which of the following roles?

  • Tune database performance
  • Establish backup and recovery procedures
  • Resolve data ownership issues
  • Protect the security of the database.
Q.10

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

  • Data modeling
  • Database design
  • Metadata
  • All of the above.
Q.11

Concurrency control is important for which of the following reasons?

  • To ensure data integrity when updates occur to the database in a multiuser environment
  • To ensure data integrity when updates occur to the database in a single-user environment
  • To ensure data integrity while reading data occurs to the database in a multiuser environment
  • To ensure data integrity while reading data occurs to the database in a single-user environment
Q.12

Which of the following is the preferred way to recover a database after a system failure?

  • Rollback
  • Rollforward
  • Switch to duplicate database
  • Reprocess transactions
Q.13

Which of the following is part of an administrative policy to secure a database?

  • Authentication policies
  • Limiting particular areas within a building to only authorized people
  • Ensure appropriate responses rates are in external maintenance agreements
  • All of the above.
Q.14

A data warehouse administrator is concerned with which of the following?

  • The time to make a decision but not the typical roles of a database administrator
  • The time to make a decision and the typical roles of a database administrator
  • The typical roles of a data administrator and redesigning existing applications
  • The typical roles of a database administrator and redesigning existing applications
Q.15

Backward recovery is which of the following?

  • Where the before-images are applied to the database
  • Where the after-images are applied to the database
  • Where the after-images and before-images are applied to the database
  • Switching to an existing copy of the database
0 h : 0 m : 1 s