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

CSE MCQs :: Oracle Database MCQs

Oracle Database MCQs - Oracle Database SQL Basics
Oracle Database MCQs - Oracle Database 11g Architecture Options
Oracle Database MCQs - Oracle Database Planning Oracle Applications
  1. What do the schema objects comprise of?
    2. A.
    Table
    B.
    Index
    C.
    Cluster
    D.
    All of the Mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Which operations can be performed using the Data Recovery Ad-visor?
    4. 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

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. 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.
    5. 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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. What is the use of an index?
    7. 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

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. Which of the following statement is false ?
    8. 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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers