[QUIZ] Check Your Understanding of SQL - Part 2

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

Understanding [QUIZ] Check Your Understanding of SQL

• Question 1: In SQL, how to insert a new record into the "Persons" table?
  • INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
  • INSERT VALUES ('Jimmy', 'Jackson') INTO Persons.
  • INSERT ('Jimmy', 'Jackson') INTO Persons
• Question 2: In SQL, how to insert the record "LastName" worth "Olsen" in the "Persons" table?
  • INSERT ('Olsen') INTO Persons (LastName)
  • INSERT INTO Persons ('Olsen') INTO LastName.
  • INSERT INTO Persons (LastName) VALUES ('Olsen')
• Question 3: How to change "Hansen" to "Nilsen" in the "LastName" column in the "Persons" table?
  • MODIFY Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'.
  • UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'.
  • MODIFY Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen.
  • UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'.
• Question 4: In SQL, how to delete the "Peter" record from the "FirstName" column in the "Persons" table?
  • DELETE FirstName = 'Peter' FROM Persons
  • DELETE ROW FirstName = 'Peter' FROM Persons.
  • DELETE FROM Persons WHERE FirstName = 'Peter'.
• Question 5: In SQL, how to return the number of records in the "Persons" table?
  • SELECT COLUMNS (*) FROM Persons
  • SELECT COUNT (*) FROM Persons
  • SELECT LEN (*) FROM Persons
  • SELECT NO (*) FROM Persons
• Question 6: Where is the most popular type of JOIN?
  • INNER JOIN
  • INSIDE JOIN
  • JOINED TABLE
  • JOINED
• Question 7: Which operator is used to retrieve data in a range?
  • RANGE
  • BETWEEN
  • WITHIN
• Question 8: The NOT NULL constraint does not accept a null value column.
  • It's correct
  • False
• Question 9: Which clauses are used to find values according to certain patterns?
  • LIKE
  • GET
  • FROM
• Question 10: Which SQL statement is used to create the table in the database?
  • CREATE DB
  • CREATE TABLE
  • CREATE DATABASE TAB
  • CREATE DATABASE TABLE