DBMS Questions – Set 11

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
   
   Answer

   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
   
   Answer

   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
   
   Answer

   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
   
   Answer

   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
   
   Answer

   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
   
   Answer

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

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

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

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

    D. 3NF