1. Which of the following is a correct SQL statement to select all records from a table named ‘Customers’?
EXTRACT * FROM Customers;
SELECT ALL RECORDS Customers;
✔ SELECT * FROM Customers;
2. Which comparison operator checks if text matches a pattern?
IN
✔ LIKE
BETWEEN
3. Which comparison operator is used to check for one value being greater than the other value?
<>
✔ >
==
4. Which SQL keyword is used to create an alias for a column or table?
✔ AS
ALIAS
ALIAS COLUMN
Leave a comment