Menu
Home / CSE MCQs / Oracle Database MCQs :: Oracle Database SQL Basics

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. In an SQL statement, which of the following parts states the conditions for row selection?
    2. A.
    Where
    B.
    From
    C.
    Order By
    D.
    Group By

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which of the following keyword is used with Data Control Language (DCL) statements?
    3. A.
    SELECT
    B.
    INSERT
    C.
    DELETE
    D.
    GRANT

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. In SQL, which of the following is not a data definition language commands?
    4. A.
    RENAME
    B.
    REVOKE
    C.
    GRANT
    D.
    UPDATE

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. SQL has how many main commands for DDL:
    5. A.
    1
    B.
    2
    C.
    3
    D.
    4

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. A type of query that is placed within a WHERE or HAVING clause of another query is called
    6. A.
    Master query
    B.
    Sub query
    C.
    Super query
    D.
    Multi-query

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Stack is also called __________
    7. A.
    First In First Out (FIFO)
    B.
    Last In First Out (LIFO)
    C.
    First In Last Out (FILO)
    D.
    First Come First Served (FCFS)

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. A command that lets you change one or more fields in a record is
    8. A.
    Insert
    B.
    Modify
    C.
    Look-up
    D.
    All of the Mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. The SQL statement 

    SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
    9. A.
    6789
    B.
    2345
    C.
    1234
    D.
    456789

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Which of the following is illegal?
    10. A.
    SELECT SYSDATE "“ SYSDATE FROM DUAL;
    B.
    SELECT SYSDATE "“ (SYSDATE "“ 2) FROM DUAL;
    C.
    SELECT SYSDATE "“ (SYSDATE + 2) FROM DUAL;
    D.
    None of the Mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. ________clause is an additional filter that is applied to the result.
    11. A.
    Select
    B.
    Group-by
    C.
    Having
    D.
    Order by

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers