SQL Query Quiz

Which SQL query is used to select all columns from a table named Students where the Age is greater than 18?

• SELECT * FROM Students WHERE Age > 18;

• SELECT * FROM Students WHERE Age = 18;

• SELECT Students FROM Age > 18;

• SELECT * FROM Students WHERE Age >= 18;

Which SQL query is used to count the total number of employees in the Employee table?

• SELECT COUNT(*) FROM Employee;

• SELECT TOTAL(Employee) FROM Employee;

• SELECT NUM(Employee) FROM Employee;

• SELECT EMPLOYEE COUNT FROM Employee;

Which SQL query is used to retrieve the maximum salary from the Salaries table?

• SELECT MAX(Salary) FROM Salaries;

• SELECT HIGH(Salary) FROM Salaries;

• SELECT SALARY MAX FROM Salaries;

• SELECT MAXIMUM(Salary) FROM Salaries;

What is the result of the following query? SELECT Name, Age FROM Students WHERE Age BETWEEN 18 AND 25;

• Selects names and ages of students between 18 and 25 years old

• Selects names and ages of students who are exactly 18 and 25 years old

• Selects only students older than 25

• Selects all students with names and ages

Which SQL query is used to select the first name, last name, and age of all employees from the Employee table, and sort them in ascending order of age?

• SELECT FirstName, LastName, Age FROM Employee ORDER BY Age ASC;

• SELECT * FROM Employee ORDER BY Age;

• SELECT FirstName, LastName, Age FROM Employee ORDER BY Age DESC;

• SELECT FirstName, LastName, Age FROM Employee WHERE Age > 30;

Which SQL query is used to find all unique cities from the Customers table?

• SELECT DISTINCT City FROM Customers;

• SELECT UNIQUE City FROM Customers;

• SELECT City FROM Customers GROUP BY City;

• SELECT City FROM Customers WHERE DISTINCT;

Which SQL query would be used to update the Salary of an employee with EmployeeID 102 to 50000 in the Employees table?

• UPDATE Employees SET Salary = 50000 WHERE EmployeeID = 102;

• UPDATE Salary SET Employees = 50000 WHERE EmployeeID = 102;

• UPDATE Employees SET Salary = 50000;

• UPDATE Employees SET Salary = 50000 WHERE EmployeeID = 101;

What is the result of the following SQL query? SELECT * FROM Products WHERE Price BETWEEN 100 AND 200;

• Selects products with prices exactly between 100 and 200

• Selects products with prices greater than 100 and less than 200

• Selects products with prices greater than or equal to 100 and less than or equal to 200

• Selects all products

Which SQL query is used to remove all rows from the Orders table without deleting the table structure?

• DELETE FROM Orders;

• REMOVE FROM Orders;

• TRUNCATE TABLE Orders;

• DROP TABLE Orders;

Which SQL query will display the names of all employees whose names start with 'J' in the Employee table?

• SELECT Name FROM Employee WHERE Name LIKE 'J%';

• SELECT Name FROM Employee WHERE Name = 'J';

• SELECT Name FROM Employee WHERE Name STARTSWITH 'J';

• SELECT Name FROM Employee WHERE Name LIKE '%J';