SQL Technical Questionnaire

10 Questions
SQL Quizzes & Trivia

Test your SQL skills!

Sample Question

Which SQL statement is used to update data in a database?

Save As

Modify

Save

Update

Number of Questions:

More Options
Please wait...
Questions and Answers
  • 1. 
    Which SQL statement is used to update data in a database?
    • A. 

      Save As

    • B. 

      Modify

    • C. 

      Save

    • D. 

      Update

  • 2. 
    Which SQL statement is used to delete data from a database?
    • A. 

      Delete

    • B. 

      Remove

    • C. 

      Collapse

  • 3. 
    Which SQL statement is used to insert new data in a database?
    • A. 

      Insert New

    • B. 

      Insert Into

    • C. 

      Add Record

    • D. 

      Add New

  • 4. 
    With SQL, how do you select a column named "FirstName" from a table named "Persons"?
    • A. 

      EXTRACT FirstName FROM Persons

    • B. 

      SELECT FirstName FROM Persons

    • C. 

      SELECT Persons.FirstName

  • 5. 
    With SQL, how do you select all the columns from a table named "Persons"?
    • A. 

      SELECT Persons

    • B. 

      SELECT *.Persons

    • C. 

      SELECT [all] FROM Persons

    • D. 

      SELECT * FROM Persons

  • 6. 
    With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
    • A. 

      SELECT * FROM Persons WHERE FirstName='Peter'

    • B. 

      SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

    • C. 

      SELECT [all] FROM Persons WHERE FirstName='Peter'

    • D. 

      SELECT * FROM Persons WHERE FirstName'Peter'

  • 7. 
    With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
    • A. 

      SELECT * FROM Persons WHERE FirstName='%a%'

    • B. 

      SELECT * FROM Persons WHERE FirstName LIKE 'a%'

    • C. 

      SELECT * FROM Persons WHERE FirstName='a'

    • D. 

      SELECT * FROM Persons WHERE FirstName LIKE '%a'

  • 8. 
    The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
    • A. 

      False

    • B. 

      True

  • 9. 
    With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
    • A. 

      SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

    • B. 

      SELECT FirstName='Peter', LastName='Jackson' FROM Persons

    • C. 

      SELECT * FROM Persons WHERE FirstName'Peter' AND LastName'Jackson'

  • 10. 
    With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
    • A. 

      SELECT LastName>'Hansen' AND LastName

    • B. 

      SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

    • C. 

      SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName