SQL-

1️⃣ What does SQL stand for?

• A) Simple Query Language
  

• B) Structured Query Language
  

• C) Standard Queue Language
  

• D) Sequential Query Language

2️⃣ What is the main purpose of SQL?

• A) To design web pages
  

• B) To encrypt network messages
  

• C) To manage and interact with databases
  

• D) To handle email servers

3️⃣ Which of these is NOT typically done using SQL?

• A) Store data
  

• B) Retrieve data
  

• C) Update data
  

• D) Draw graphics on a canvas

4️⃣ Which SQL operation would you use to remove old records from a database?

• A) SELECT
  

• B) DELETE
  

• C) INSERT
  

• D) JOIN

5️⃣ What does this query do?

SELECT * FROM Customers WHERE Country = 'Mexico';

• A) Deletes customers from Mexico
  

• B) Updates customers in Mexico
  

• C) Retrieves all customers from Mexico
  

• D) Creates a new table of Mexican customers

6️⃣ What does the ORDER BY clause do in SQL?

• A) Sorts the results by a specified column
  

• B) Deletes duplicate records
  

• C) Encrypts the output
  

• D) Creates a new table

7️⃣ What does this query do?

DELETE FROM Customers WHERE CustomerName = 'Alfreds Futterkiste';

• A) Selects all customers named Alfreds Futterkiste
  

• B) Updates Alfreds Futterkiste’s records
  

• C) Deletes the customer named Alfreds Futterkiste
  

• D) Orders customers by name

8️⃣ Which type of JOIN returns all records from the left table, and matched records from the right table?

• A) INNER JOIN
  

• B) LEFT JOIN
  

• C) RIGHT JOIN
  

• D) FULL OUTER JOIN

9️⃣ Which type of JOIN returns all records from both tables, matching them where possible?

• A) INNER JOIN
  

• B) LEFT JOIN
  

• C) RIGHT JOIN
  

• D) FULL OUTER JOIN

What does the UNION operator do in SQL?

• A) Merges rows from two SELECT statements into one result set
  

• B) Deletes duplicate data
  

• C) Encrypts multiple tables
  

• D) Updates several records at once