Test: Oracle SQL - Software Development MCQ

A programming language for web development

A relational database management system

A scripting language for data analysis

A markup language for creating web pages

It is case-sensitive for all keywords and identifiers

It is case-insensitive for all keywords and identifiers

It is case-sensitive for keywords but case-insensitive for identifiers

It is case-insensitive for keywords but case-sensitive for identifiers

To insert data into a table

To delete data from a table

To update data in a table

To retrieve data from a table

It is used to specify the columns to be retrieved from a table

It is used to filter data based on a specified condition

It is used to sort the result set in ascending or descending order

It is used to join multiple tables in a single query

To specify the columns to be retrieved from a table

To filter data based on a specified condition

To sort the result set in ascending or descending order

To group rows based on a specified column or columns

SELECT * FROM employees;

SELECT emp_name FROM employees;

SELECT emp_id, emp_name FROM employees;

SELECT emp_salary FROM employees;

SELECT * FROM products WHERE product_price > 100;

SELECT product_name FROM products WHERE product_price > 100;

SELECT product_id, product_name FROM products WHERE product_price > 100;

SELECT product_price FROM products WHERE product_price > 100;

SELECT * FROM students WHERE student_grade = 'A';

SELECT student_name FROM students WHERE student_grade = 'A';

SELECT student_id, student_name FROM students WHERE student_grade = 'A';

SELECT student_grade FROM students WHERE student_grade = 'A';

SELECT * FROM orders WHERE order_date LIKE '%2022%';

SELECT order_total FROM orders WHERE order_date LIKE '%2022%';

SELECT order_id, order_total FROM orders WHERE order_date LIKE '%2022%';

SELECT SUM(order_total) FROM orders WHERE order_date LIKE '%2022%';

SELECT * FROM employees ORDER BY emp_salary DESC LIMIT 5;

SELECT emp_name FROM employees ORDER BY emp_salary DESC LIMIT 5;

SELECT emp_id, emp_name FROM employees ORDER BY emp_salary DESC LIMIT 5;

SELECT emp_salary FROM employees ORDER BY emp_salary DESC LIMIT 5;

SELECT COUNT(student_id), student_grade FROM students GROUP BY student_grade;

SELECT COUNT(student_grade), student_grade FROM students GROUP BY student_id;

SELECT COUNT(student_id), student_grade FROM students ORDER BY student_grade;

SELECT COUNT(student_grade), student_grade FROM students ORDER BY student_id;

SELECT AVG(order_total), EXTRACT(YEAR FROM order_date) FROM orders GROUP BY EXTRACT(YEAR FROM order_date);

SELECT AVG(order_total), order_date FROM orders GROUP BY order_total;

SELECT AVG(order_total), EXTRACT(YEAR FROM order_date) FROM orders ORDER BY EXTRACT(YEAR FROM order_date);

SELECT AVG(order_total), order_date FROM orders ORDER BY order_total;

SELECT SUM(emp_salary) FROM employees;

SELECT AVG(emp_salary) FROM employees;

SELECT COUNT(emp_salary) FROM employees;

SELECT MAX(emp_salary) FROM employees;

SELECT AVG(product_price) FROM products;

SELECT SUM(product_price) FROM products;

SELECT COUNT(product_price) FROM products;

SELECT MAX(product_price) FROM products;

SELECT * FROM orders WHERE TO_CHAR(order_date, 'DAY') IN ('SATURDAY', 'SUNDAY');

SELECT order_id FROM orders WHERE TO_CHAR(order_date, 'DAY') IN ('SATURDAY', 'SUNDAY');

SELECT order_id, order_date FROM orders WHERE TO_CHAR(order_date, 'DAY') IN ('SATURDAY', 'SUNDAY');

SELECT order_total FROM orders WHERE TO_CHAR(order_date, 'DAY') IN ('SATURDAY', 'SUNDAY');