DBMS Questions (Oracle 9i) – Set 13

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. An important purpose of the shared pool is to cache the executable versions of _________ statements.
    A. SQL
    B. PL/SQL
    C. Both (A) and (B)
    D. None of the above
    Answer
    C. Both (A) and (B)
  2. Which of the following is/are main component(s) of the shared pool?
    A. library Cache
    B. dictionary Cache
    C. Both (A) and (B)
    D. None of the above
    Answer
    C. Both (A) and (B)
  3. Oracle Database segregates a small amount of the shared pool for large objects(Over 5KB).The segregated area of the shared pool is called ______
    A. Fixed Pool
    B. Reserved Pool
    C. Allocated Pool
    D. None of the above
    Answer
    B. Reserved Pool
  4. Which stores the executable(parsed) form of SQL cursors and PL/SQL programs?
    A. library Cache
    B. dictionary Cache
    C. Both (A) and (B)
    D. None of the above
    Answer
    A. library Cache
  5. Information stored in dictionary cache includes ______
    A. User names
    B. Profile data
    C. table space information
    D. All of the above
    Answer
    D. All of the above
  6. When a query is submitted to oracle server for execution, oracle checks if same query has been executed previously. If found the same then this event is known as ________
    A. Library cache hit
    B. soft parsing
    C. Both (A) and (B)
    D. None of the above
    Answer
    C. Both (A) and (B)
  7. If the parsed form of the statement is not found in the shared pool then new statement is parsed and its parsed version is stored in Shared SQL area. This is known as ________
    A. Library cache hit
    B. Soft parsing
    C. Hard parsing
    D. None of the above
    Answer
    C. Hard parsing
  8. Shared pool size is an important factor for ______ applications.
    A. On-line Transaction Processing (OLTP)
    B. Decision Support Systems (DSS)
    C. Both (A) and (B)
    D. None of the above
    Answer
    A. On-line Transaction Processing (OLTP)
  9. The shared pool is also able to support ________ in data warehousing applications.
    A. Shared SQL
    B. Stored SQL
    C. Unsorted SQL
    D. Unshared SQL
    Answer
    D. Unshared SQL
  10. Reuse of shared SQL for multiple users running the same application avoids ______
    A. Library cache hit
    B. Soft parsing
    C. Hard parsing
    D. None of the above
    Answer
    C. Hard parsing