Basic SQL Quiz By - M Khan

5 Questions | Total Attempts: 84

SettingsSettingsSettings
Please wait...
Basic SQL Quiz By - M Khan


Questions and Answers
  • 1. 
    Sorts are Alphabetical in SQL, not Logical.
    • A. 

      True

    • B. 

      False

  • 2. 
    Which one is wrong Alias syntax ?
    • A. 

      First_name AS Fname

    • B. 

      Last_name Lname

    • C. 

      Class_Code "Class Code"

    • D. 

      Grade_pt AS AVG

  • 3. 
    SELECT * FROM Student_table WHERE Grade_pt = 3.0 OR 4.0; What will be the result ?
    • A. 

      Display students from Grade_pt 3.0 or 4.0

    • B. 

      Will show syntax error

    • C. 

      Display only students from Grade_pt 3.0

    • D. 

      Not Sure

  • 4. 
    What is the order of Precedence in SQL ?
    • A. 

      ( ) NOT OR AND

    • B. 

      AND OR NOT ( )

    • C. 

      NOT OR ( ) AND

    • D. 

      ( ) NOT AND OR

  • 5. 
    LIKE Keyword uses which two special character ?
    • A. 

      # and @

    • B. 

      $ and %

    • C. 

      % and &

    • D. 

      % and _ (underscore)

Related Topics
Back to Top Back to top