Data And Database Administration MCQ

Test your knowledge with important Data And Database Administration MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Data And Database Administration MCQs at Bissoy

• Incorrect data is easy to detect.
  ক

  True

  খ

  False
• Data modeling and database design are key responsibilities of data and data base administration.
  ক

  True

  খ

  False
• With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.
  ক

  True

  খ

  False
• A disaster recovery plan does not need to include the shipment of database backups to other sites.
  ক

  True

  খ

  False
• Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
  ক

  True

  খ

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

  True

  খ

  False
• Queries that do full table scans should be avoided.
  ক

  True

  খ

  False
• Databases are not the property of a single function or individual within the organization.
  ক

  True

  খ

  False
• Mirrored databases are almost always provided in high-availability systems.
  ক

  True

  খ

  False
• Information repositories are replacing data dictionaries in many organizations.
  ক

  True

  খ

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

  True

  খ

  False
• A transaction log shows before and after images of records that have been modified by transactions.
  ক

  True

  খ

  False
• Authorization tables contain highly sensitive data and should be protected by stringent security rules.
  ক

  True

  খ

  False
• Failure to control confidentiality may lead to loss of competitiveness.
  ক

  True

  খ

  False
• To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.
  ক

  True

  খ

  False
• 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
• Which of the following is the preferred way to recover a database after a system failure?
  ক

  Rollback

  খ

  Rollforward

  গ

  Switch to duplicate database

  ঘ

  Reprocess transactions
• 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
• 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
• 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
• 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
• Locking may cause which of the following problems?
  ক

  Erroneous updates

  খ

  Deadlock

  গ

  Versioning

  ঘ

  All of the above
• Which of the following could cause data to be unavailable?
  ক

  Data becoming lost or inaccurate

  খ

  The database server

  গ

  Planned database maintenance activities

  ঘ

  All of the above
• The transaction log includes which of the following?
  ক

  The before-image of a record

  খ

  The after-image of a record

  গ

  The before and after-image of a record

  ঘ

  The essential data of the record
• 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
• 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
• 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
• 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
• 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