Oracle SQL Fundamentals Quiz! Test

10 Questions | Total Attempts: 112

SettingsSettingsSettings
Oracle SQL Fundamentals Quiz! Test - Quiz

.


Questions and Answers
  • 1. 
    Which operator will be evaluated first in the following SELECT statement? SELECT (2+3*4/2-5) FROM dual;
    • A. 

      +

    • B. 

      *

    • C. 

      /

    • D. 

      -

  • 2. 
    Oracle Database 11g offers extensive features across the following focus areas except 
    • A. 

      Manageability    

    • B. 

      Search Option

    • C. 

      High availability    

    • D. 

      Security

  • 3. 
    Each row of data in a table is uniquely identified by a:
    • A. 

      Unique key

    • B. 

      Foreign keys

    • C. 

      Primary key

    • D. 

      Universal key

  • 4. 
    _________ identifies the columns to be displayed and ______________ identifies the table containing  columns.
    • A. 

      From and select

    • B. 

      Where and select

    • C. 

      Select    from

    • D. 

      From and table

    • E. 

      Option 5

  • 5. 
    Which of this is not correct about Column Alias?
    • A. 

      Renames a column heading

    • B. 

      Is useful with calculations    

    • C. 

      Requires double quotation marks if it contains spaces or special characters or if it is case-sensitive

    • D. 

      Is Oracle vendor specific

  • 6. 
    Which of the clauses restricts the query to rows that meet a condition?
    • A. 

      Where    

    • B. 

      Order by

    • C. 

      Distinct

    • D. 

      Describe

  • 7. 
    Which statement is true regarding operators used with subqueries?
    • A. 

      The NOT IN operator is equivalent to IS NULL.    

    • B. 

      The <ANY operator means less than the maximum.     

    • C. 

      =ANY and =ALL operators have the same functionality.    

    • D. 

      The IN operator cannot be used in single-row subqueries.

  • 8. 
    The relational model consists of the following except:
    • A. 

      Collection of objects or relations

    • B. 

      Data integrity for accuracy and consistency

    • C. 

      Coding java with Oracle easily    

    • D. 

      Set of operators to act on the relations

  • 9. 
    Grant and revoke belongs to?
    • A. 

      Data manipulation language (DML)    

    • B. 

      Data definition language (DDL)

    • C. 

      Data control language (DCL)

    • D. 

      Transaction control

  • 10. 
    Keywords cannot be abbreviated or split across lines.    
    • A. 

      True

    • B. 

      False