Home / CSE MCQs / Oracle Database MCQs :: Oracle Database 11g Architecture Options

CSE MCQs :: Oracle Database MCQs

  1. What do the schema objects comprise of?
  2. A.
    Table
    B.
    Index
    C.
    Cluster
    D.
    All of the Mentioned

  3. Modification schema of oracle database in one level without affecting the schema in high level is called as _______
  4. A.
    Data Migration
    B.
    Data Isolation
    C.
    Data Independence
    D.
    Data Abstraction

  5. Which operations can be performed using the Data Recovery Ad-visor?
  6. A.
    Diagnosing data failure
    B.
    It is a percentage of rows in which the statistics are collected incrementally for partitions
    C.
    Presenting appropriate repair options
    D.
    Generating reports for possible causes of failure

  7. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.
  8. A.
    Set the TRACE_ENABLED parameter to TRUE
    B.
    Set the threshold for the Current Logons Count metric
    C.
    Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE
    D.
    Set the SESSIONS_PER_USER limit in the profiles used by users

  9. Which of the following segment is destroyed when the SQL statement is finished?
  10. A.
    Data Segment
    B.
    Object Segment
    C.
    Temporary Segment
    D.
    All of the Mentioned

  11. What is the use of an index?
  12. A.
    Retrieve data more quickly and efficiently
    B.
    Related data requires much less I/O overhead if accessed simultaneously
    C.
    Simplify the user's perception of data access
    D.
    All of the Mentioned

  13. Which of the following statement is false ?
  14. A.
    Any procedure can raise a error and return an user message and error number
    B.
    Error number is ranging from 20000 to 20999 are reserved for user defined messages
    C.
    Oracle checks Uniqueness of User defined errors
    D.
    Raise_Application_error is used for raising an user defined error

  15. What is the result of the following 'PAN'NULL'KAJ'?
  16. A.
    Error
    B.
    PAN KAJ
    C.
    PANKAJ
    D.
    NULL

  17. Which of the following object types below cannot be replicated?
  18. A.
    Data
    B.
    Trigger
    C.
    View
    D.
    Sequence

  19. The ORDER BY clause can only be used in ___________
  20. A.
    SELECT queries
    B.
    INSERT queries
    C.
    GROUP BY queries
    D.
    HAVING queries