Oracle 11g New Features_15 March

14 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

Oracle 11g New Features


Questions and Answers
  • 1. 
     Which of the following is a type of segment in Oracle?
    • A. 

      Views

    • B. 

      Tables

    • C. 

      Procedures

    • D. 

      Partitions

  • 2. 
    During any database operation DBMS fetches information from?
    • A. 

      Disk

    • B. 

      Memory

    • C. 

      Logs

    • D. 

      None of these

  • 3. 
    Which of the will be impacted when you implement partitioning on a table?
    • A. 

      Select Operation

    • B. 

      Insert Operation

    • C. 

      Update Operation

    • D. 

      None of these

  • 4. 
    How is data integrity ensured during DML operations in Oracle?
    • A. 

      Through constraints

    • B. 

      Through latches

    • C. 

      Through locks

    • D. 

      The responsibility lies with the code

  • 5. 
    DDL operations require which of the following locks?
    • A. 

      Table Exclusive

    • B. 

      Row Exclusive

    • C. 

      Row Shared

    • D. 

      User Lock

  • 6. 
    Oracle optimizer determines execution plans based on?
    • A. 

      The way query is written

    • B. 

      There is a set plan based on types of objects

    • C. 

      Filter criteria

    • D. 

      Expected Result set

  • 7. 
    Optimizer can choose to share plans based on the use of bind variables?
    • A. 

      True

    • B. 

      False

  • 8. 
    Which of the following will be impacted after Table compression?
    • A. 

      Views

    • B. 

      Indexes

    • C. 

      Triggers

    • D. 

      Partitions

  • 9. 
    You are the owner of an application that is shared by global users. The underlying database stores the sensitive data that is to be restricted based on a set of conditions. The best place to restrict the access is
    • A. 

      Client

    • B. 

      Application

    • C. 

      Database

    • D. 

      Not possible

  • 10. 
    The database code for your application generates a huge amount of log which needs to be cleared regularly. What is the best way to achieve that?
    • A. 

      A chron job on server

    • B. 

      A database job

    • C. 

      An autosys job

    • D. 

      All of these

  • 11. 
    Which one of these is most preferred in OLTP?
    • A. 

      1NF

    • B. 

      2NF

    • C. 

      3NF

    • D. 

      4NF

  • 12. 
    Use of virtual columns is against transitive dependency principles related to Normalization?
    • A. 

      True

    • B. 

      False

  • 13. 
    Which of the following is not a part of SGA?
    • A. 

      Shared pool

    • B. 

      Java pool

    • C. 

      Redo log buffer

    • D. 

      Private SQL Area

  • 14. 
    The best way to tune an application is?
    • A. 

      Modify database parameters

    • B. 

      Tune query

    • C. 

      Tune application

    • D. 

      None of these