[QUIZ] Test Your Understanding of SQL - Part 1

This article presents [QUIZ] Test Your Understanding of SQL - Part 1 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding [QUIZ] Test Your Understanding of SQL

• Question 1: What does SQL mean?
  • Structured Question Language
  • Structured Query Language
  • Strong Question Language
• Question 2: Which SQL statement is used to retrieve data from the database?
  • GET
  • OPEN
  • SELECT
  • EXTRACT
• Question 3: Which SQL statement is used to update data in the database?
  • MODIFY
  • SAVE AS
  • SAVE
  • UPDATE
• Question 4: Which SQL statement is used to delete data from the database?
  • REMOVE
  • DELETE
  • COLLAPSE
  • DROP
• Question 5: Which SQL statement is used to add new data to the database?
  • ADD RECORD
  • ADD NEW
  • INSERT INTO
  • NEW INSERT
• Question 6: In SQL, how to select a column named "FirstName" from the "Persons" table?
  • EXTRACT FirstName FROM Persons
  • SELECT FirstName FROM Persons
  • SELECT Persons. FirstName
• Question 7: In SQL, how to select all columns from the "Persons" table?
  • SELECT [all] FROM Persons
  • SELECT * FROM Persons
  • SELECT *. Persons
  • SELECT Persons
• Question 8: In SQL, how to select all records from the "Persons" table in which the value of "FirstName" column is "Peter"?
  • SELECT [all] FROM Persons WHERE FirstName = 'Peter'.
  • SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'.
  • SELECT * FROM Persons WHERE FirstName <> 'Peter'.
  • SELECT * FROM Persons WHERE FirstName = 'Peter'.
• Question 9: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column begins with "a"?
  • SELECT * FROM Persons WHERE FirstName LIKE '% a'.
  • SELECT * FROM Persons WHERE FirstName LIKE 'a%'.
  • SELECT * FROM Persons WHERE FirstName = '% a%'.
  • SELECT * FROM Persons WHERE FirstName = 'a'.
• Question 10: The OR operator displays a record if the retrieved data only needs to satisfy one of the listed conditions. The AND operator displays the record if the retrieved data satisfies all the listed conditions.
  • It's correct
  • False
• Question 11: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column is "Peter" and "LastName" is "Jackson"?
  • SELECT * FROM Persons WHERE FirstName = 'Peter' AND LastName = 'Jackson'.
  • SELECT * FROM Persons WHERE FirstName <> 'Peter' AND LastName <> 'Jackson'.
  • SELECT FirstName = 'Peter', LastName = 'Jackson' FROM Persons.
• Question 12: In SQL, how to select all records from the "Persons" table in which "LastName" is sorted alphabetically and is in "Hansen" and "Pettersen" (including 2 values). this)
  • SELECT * FROM Persons WHERE LastName> 'Hansen' AND LastName <'Pettersen'.
  • SELECT LastName> 'Hansen' AND LastName <'Pettersen' FROM Persons.
  • SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'.
• Question 13: Which SQL statement is used to return unique values in the table?
  • SELECT UNIQUE
  • SELECT DISTINCT
  • SELECT DIFFERENT
• Question 14: Which SQL command is used to sort the result set?
  • SORT BY
  • SORT
  • ORDER
  • ORDER BY
• Question 15: In SQL, how can I return all records from the "Persons" table sorted in descending order according to "FirstName"?
  • SELECT * FROM Persons SORT BY 'FirstName' DESC.
  • SELECT * FROM Persons ORDER BY FirstName DESC.
  • SELECT * FROM Persons SORT 'FirstName' DESC.
  • SELECT * FROM Persons ORDER FirstName DESC.