You have a table named "Employees" with columns "EmployeeID", "FirstName", "LastName", and "Salary". You need to retrieve the full names of employees who have a salary greater than $50,000. Which SQL query would you use?

SELECT FirstName, LastName FROM Employees WHERE Salary > 50000;

SELECT EmployeeID, FirstName, LastName FROM Employees HAVING Salary > 50000;

SELECT EmployeeID, FirstName, LastName FROM Employees WHERE Salary > 50000;

SELECT FirstName, LastName FROM Employees HAVING Salary > 50000;

You have two tables named "Customers" and "Orders". The "Customers" table has columns "CustomerID" and "CustomerName", while the "Orders" table has columns "OrderID", "CustomerID", and "OrderDate". You need to retrieve the names of customers who have placed an order. Which SQL query would you use?

SELECT CustomerName FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

SELECT CustomerName FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders);

SELECT CustomerName FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

SELECT CustomerName FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

You have a table named "Products" with columns "ProductID", "ProductName", and "CategoryID". You need to retrieve the names of products along with their category names. Which SQL query would you use?

SELECT p.ProductName, c.CategoryName FROM Products p INNER JOIN Category c ON p.CategoryID = c.CategoryID

SELECT p.ProductName, c.CategoryName FROM Products p INNER JOIN Category c ON p.ProductID = c.CategoryID

SELECT p.ProductName, c.CategoryName FROM Products p JOIN Category c ON p.CategoryID = c.CategoryID

SELECT p.ProductName, c.CategoryName FROM Products p LEFT JOIN Category c ON p.CategoryID = c.CategoryID

You have a table named "Books" with columns "BookID", "Title", "Author", and "PublicationYear". You need to retrieve the count of books published in each year. Which SQL query would you use?

SELECT PublicationYear, COUNT(*) FROM Books GROUP BY PublicationYear;

SELECT PublicationYear, COUNT(BookID) FROM Books GROUP BY PublicationYear;

SELECT PublicationYear, COUNT(DISTINCT BookID) FROM Books GROUP BY PublicationYear;

SELECT PublicationYear, COUNT(*) FROM Books HAVING COUNT(*) > 1 GROUP BY PublicationYear;

You have a table named "Products" with columns "ProductID", "ProductName", "UnitPrice", and "UnitsInStock". You need to retrieve the products that are out of stock. Which SQL query would you use?

SELECT ProductID, ProductName FROM Products WHERE UnitsInStock = 0;

SELECT ProductID, ProductName FROM Products WHERE UnitsInStock < 1;

SELECT ProductID, ProductName FROM Products WHERE UnitsInStock <= 0;

SELECT ProductID, ProductName FROM Products WHERE UnitsInStock IS NULL;

You want to retrieve the top 5 highest-paid employees from a table named "employees". Which SQL query would you use?

SELECT * FROM employees ORDER BY salary DESC LIMIT 5;

SELECT * FROM employees ORDER BY salary ASC LIMIT 5;

SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

SELECT * FROM employees WHERE salary < (SELECT AVG(salary) FROM employees);

You want to retrieve all orders placed by customers whose names start with "J". Which SQL query would you use?

SELECT * FROM orders WHERE customer_name LIKE 'J%';

SELECT * FROM orders WHERE customer_name LIKE '%J';

SELECT * FROM orders WHERE customer_name = 'J_';

SELECT * FROM orders WHERE customer_name LIKE '_J';

You want to retrieve the top 3 most frequent product categories from a table named "products". Which SQL query would you use?

SELECT category, COUNT() AS count FROM products GROUP BY category ORDER BY count DESC LIMIT 3;

SELECT category, COUNT() AS count FROM products GROUP BY category ORDER BY count ASC LIMIT 3;

SELECT category, SUM(quantity) AS count FROM products GROUP BY category ORDER BY count DESC LIMIT 3;

SELECT category, AVG(quantity) AS count FROM products GROUP BY category ORDER BY count DESC LIMIT 3;

You have a table named "Orders" with columns "OrderID", "CustomerID", and "OrderDate". You want to retrieve the orders placed by customers who have placed more than 5 orders. Which SQL query would you use?

SELECT FROM Orders WHERE CustomerID IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT( ) > 5)

SELECT FROM Orders WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT( ) > 5)

SELECT FROM Orders WHERE CustomerID IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT( ) < 5)

SELECT FROM Orders WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT( ) < 5)

You have a table named "Employees" with columns "Name", "Salary", and "DepartmentID". You want to retrieve the names of employees who have a salary greater than the highest salary in their department. Which SQL query would you use?

SELECT Name FROM Employees WHERE Salary > (SELECT MAX(Salary) FROM Employees GROUP BY DepartmentID)

SELECT Name FROM Employees WHERE Salary > (SELECT MAX(Salary) FROM Employees)

SELECT Name FROM Employees WHERE Salary > (SELECT MAX(Salary) FROM Employees WHERE DepartmentID = Employees.DepartmentID)

SELECT Name FROM Employees WHERE Salary > (SELECT MAX(Salary) FROM Employees WHERE DepartmentID = Employees.DepartmentID GROUP BY DepartmentID)

SQL Test

Quiz

•

Computers

•

University

•

Practice Problem

•

Hard

Team Bootup

Used 3+ times

FREE Resource

SYSDATE()

CURRENT_TIMESTAMP()

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

DATABASE MANAGEMENT CT-1

Quiz

•

University

20 questions

Assignment -2

Quiz

•

University

20 questions

Programming2

Quiz

•

University

20 questions

js DOM

Quiz

•

12th Grade - Professi...

20 questions

MOC 20744C-Securing Windows Server 2016 - Part 1

Quiz

•

University

20 questions

FRAMING,Bit Stuffing, PPP,HDLC,

Quiz

•

University

20 questions

Email Server

Quiz

•

University

20 questions

Information Management - QUIZ

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

University

SQL Test

25 questions

Which SQL keyword is used to retrieve a subset of records from a table?

Which SQL statement is used to add a new row to a table?

Which SQL statement is used to delete a table from the database?

Which SQL join type returns only the matching records between two tables?

Which SQL statement is used to modify existing data in a table?

Which SQL clause is used to sort the result set in ascending or descending order?

Which SQL function is used to return the current date and time?

Which SQL statement is used to rename a column in a table?

Which SQL function is used to return the length of a string?

Which SQL function is used to convert a string to uppercase?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers