Basic SQL Quiz For School Learners!

10 Questions | Total Attempts: 3342

SettingsSettingsSettings
Please wait...
SQL Quizzes & Trivia

This is a quiz on the SQL system. Needed for learning at school


Related Topics
Questions and Answers
  • 1. 
    When did SQL appear
    • A. 

      1974

    • B. 

      1922

    • C. 

      1977

    • D. 

      1987

  • 2. 
    Who developed SQL
    • A. 

      IBM

    • B. 

      DELL

    • C. 

      SQL

    • D. 

      Microsoft

    • E. 

      Apple

  • 3. 
    Who designed the SQL system
    • A. 

      Donald D. Chamberlin

    • B. 

      Raymond F. Boyce

    • C. 

      Jerron Q. Refter

    • D. 

      Both A & B

    • E. 

      Both A & C

  • 4. 
    What is a query?
    • A. 

      A question

    • B. 

      Desire results

  • 5. 
    What is null
    • A. 

      Add

    • B. 

      Rule out

  • 6. 
    What does SQL Lack
    • A. 

      The complexity and size of the SQL standard means that most databases DO NOT implement the entire standard.

    • B. 

      The simplicity and size of the SQL standard means that most databases DO implement the entire standard.

    • C. 

      The simplicity and size of the SQL standard means that most databases DO NOT implement the entire standard.

    • D. 

      The complexity and size of the SQL standard means that most databases DO implement the entire standard.

  • 7. 
    • A. 

      The join condition is not separated from other search conditions in a query

    • B. 

      The ON clause makes code difficult to understand

    • C. 

      The join condition for natural join is basically an equijoin of all columns with same name.

    • D. 

      None of the above.

  • 8. 
    • A. 

      COUNT

    • B. 

      AVG

    • C. 

      STDDEV

    • D. 

      VARIANCE

  • 9. 
    • A. 

      COUNT(*) returns the number of rows in the table.

    • B. 

      COUNT(DISTINCT exp) returns the number of unique, non-null values in the column

    • C. 

      COUNT(DISTINCT exp) returns the number of unique, non-null values in the column

    • D. 

      All are true.

  • 10. 
     Which of the following is not true about inserting news rows to a table?
    • A. 

      The INSERT INTO statement is used for inserting new rows to a table

    • B. 

      You cannot insert rows with NULL values to a table.

    • C. 

      You may insert a new row containing values for each column.

    • D. 

      All of the above.