Oracle SQL Exam Trivia Quiz!

30 Questions | Total Attempts: 53

SettingsSettingsSettings
Please wait...
Oracle Quizzes & Trivia

Questions and Answers
  • 1. 
    Group functions cannot be nested
    • A. 

      True

    • B. 

      False

  • 2. 
    Only two tables can be JOINed in each SELECT statement
    • A. 

      True

    • B. 

      False

  • 3. 
    NONEQUIJOINS are JOINs used to SELECT data between ranges of values.
    • A. 

      True

    • B. 

      False

  • 4. 
    The main query executes before the subquery.
    • A. 

      True

    • B. 

      False

  • 5. 
    The expression in SELECT list may not match in number when doing operations involving SET operators.
    • A. 

      True

    • B. 

      False

  • 6. 
    Duplicate rows are eliminated in UNIONALL
    • A. 

      True

    • B. 

      False

  • 7. 
    In SET operations, the ORDER BY clause can appear only once at the end of compound query.
    • A. 

      True

    • B. 

      False

  • 8. 
    You can remove existing rows by using DELETE statement.
    • A. 

      True

    • B. 

      False

  • 9. 
    TRUNCATE statement removes all rows from a table, leaving the table empty and the table structure intact.
    • A. 

      True

    • B. 

      False

  • 10. 
    An automatic rollback occurs when there is abnormal termination of SQL Developer or System failure.
    • A. 

      True

    • B. 

      False

  • 11. 
    A SEQUENCE logically represents subsets of data from one or more tables
    • A. 

      False

    • B. 

      True

  • 12. 
    Table and Column names must begin with a letter.
    • A. 

      True

    • B. 

      False

  • 13. 
    You cannot remove a view without losing data because a view is based on underlying tables in the database.
    • A. 

      False

    • B. 

      True

  • 14. 
    A unique index is created automatically when you define a PRIMARY KEY or UNIQUE KEY constraints in a table definition.
    • A. 

      True

    • B. 

      False

  • 15. 
    Contraints can still be added even if the table is already created.
    • A. 

      True

    • B. 

      False

  • 16. 
    Remove INDEX by using DROP INDEX command.
    • A. 

      True

    • B. 

      False

  • 17. 
    A table cannot be created from the result of a subquery.
    • A. 

      False

    • B. 

      True

  • 18. 
    A column can be added even the table is already created.
    • A. 

      True

    • B. 

      False

  • 19. 
    Regular Expressions cannot be used on CHECK Constraints.
    • A. 

      False

    • B. 

      True

  • 20. 
    SQL statements are case sensitive
    • A. 

      False

    • B. 

      True

  • 21. 
    Date and character literal values should be enclose within single quotation marks
    • A. 

      True

    • B. 

      False

  • 22. 
    A SELECT statement always requires the presence of WHERE clause
    • A. 

      False

    • B. 

      True

  • 23. 
    The default order provided by the ORDER BY clause is descending order
    • A. 

      False

    • B. 

      True

  • 24. 
    You cannot use case-conversion function on the WHERE clause
    • A. 

      False

    • B. 

      True

  • 25. 
    The MOD function returns the remainder of division
    • A. 

      True

    • B. 

      False

Back to Top Back to top