Test: SQL Operators - 2 - Software Development MCQ
15 Questions MCQ Test - Test: SQL Operators - 2
Which SQL operator is used to combine the result of two or more SELECT statements into a single result set?
Which SQL operator is used to select all values that satisfy multiple conditions?
Which SQL operator is used to perform arithmetic operations?
Consider the following SQL query:
SELECT name
FROM employees
WHERE salary > 50000;
What would be the output of this query?
Consider the following SQL query:
SELECT COUNT(*)
FROM orders
WHERE order_date BETWEEN '2022-01-01' AND '2022-12-31';
What would be the output of this query?
Consider the following SQL query:
SELECT city
FROM customers
WHERE country = 'USA' AND city LIKE 'New%';
What would be the output of this query?
Consider the following SQL query:
SELECT product_id
FROM inventory
WHERE quantity IN (10, 20, 30);
What would be the output of this query?
Consider the following SQL query:
SELECT *
FROM employees
WHERE employee_id = ANY (SELECT manager_id FROM employees);
What does this query return?
Consider the following SQL query:
SELECT customer_id
FROM orders
WHERE EXISTS (SELECT 1 FROM order_items WHERE order_items.order_id = orders.order_id);
What does this query return?
Consider the following SQL query:
SELECT *
FROM products
WHERE price BETWEEN 10 AND 20;
What does this query return?
Consider the following SQL query:
SELECT supplier_id
FROM suppliers
WHERE supplier_id = ALL (SELECT supplier_id FROM products WHERE price > 100);
What does this query return?
Consider the following SQL query:
SELECT product_id
FROM products
WHERE product_id IN (SELECT product_id FROM orders);
What does this query return?
Consider the following SQL query:
SELECT employee_id
FROM employees
WHERE employee_id <> ALL (SELECT manager_id FROM employees);
What does this query return?
Important Questions for SQL Operators - 2
SQL Operators - 2 MCQs with Answers
Online Tests for SQL Operators - 2
|
© EduRev
|
Education Revolution
|
|
