Current Affairs PDF Sales

DBMS Questions – Set 11

AffairsCloud YouTube Channel - Click Here

Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in DBMS. It will be useful for the IBPS SO IT officer. We have also included some important questions that are repeatedly asked in previous exams.

  1. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
    A. Application failure
    B. Instance Failure
    C. Media Failure
    D. Roll back failure
    B. Instance Failure

  2. Which Oracle backup and recovery file contains user and system data?
    A. Control file
    B. Data file
    C. Offline Redo file
    D. None of the Above
    B. Data file

  3. When is the System Global Area (SGA) created in an Oracle database environment?
    A. When the database is created
    B. When a user process is started
    C. When the database is mounted
    D. When the instance is started
    D. When the instance is started

  4. What is the type of Oracle backup in which all uncommitted changes have been removed from the data files?
    A. Full backup
    B. Consistent backup
    C. Inconsistent backup
    D. Differential backup
    B. Consistent backup

  5. Which type of file is a part of the Oracle database?
    A. Control file
    B. Password file
    C. Parameter files
    D. log files
    A. Control file

  6. Which password management feature ensures a user cannot reuse a password for a specified time interval?
    A. Account Locking
    B. Password History
    C. Password Verification
    D. None of the Above
    B. Password History

  7. Which privilege is required to create a database?
    A. SYSDBA
    B. DBA
    C. SYSOPER
    D. RESOURCE
    A. SYSDBA

  8. The most open source DBMS is _______
    A. Oracle
    B. Microsoft Access
    C. MySQL
    D. None of the Above
    C. MySQL

  9. Which database level is the closest level to the users?
    A. Internal
    B. External
    C. Conceptual
    D. None of the Above
    B. External

  10. Which Normal Form(NF) is considered adequate for normal relational database design?
    A. 2NF
    B. 5NF
    C. 4NF
    D. 3NF
    D. 3NF