ISYS6892003

What is a subquery?

• A type of join

• A query within another query

• A view definition

• A sequence generator

• A synonym

Which query finds names that end with 'son'?

• SELECT * FROM employees WHERE name LIKE '%son%';

• SELECT * FROM employees WHERE name LIKE 'son%';

• SELECT * FROM employees WHERE name REGEXP_LIKE(name, 'son$');

• SELECT * FROM employees WHERE name LIKE '%son';

• SELECT * FROM employees WHERE name IN 'son';

Which of the following best defines a view?

• A virtual table based on a query

• A physical copy of a table

• A stored procedure

• A trigger function

• A synonym for a column

Which query performs an inner join between orders and customers on customer_id?

• SELECT * FROM orders JOIN customers ON orders.id = customers.id;

• SELECT * FROM orders FULL JOIN customers;

• SELECT * FROM orders NATURAL JOIN customers;

• SELECT * FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;

• SELECT * FROM orders, customers WHERE orders.id = customers.id;

What does the UPPER function do in SQL?

• Converts all characters to lowercase

• Capitalizes the first letter of each word

• Removes spaces from a string

• Converts all characters to uppercase

• Replaces NULL values

Which query creates a sequence starting at 100 and incrementing by 10?

• CREATE SYNONYM seq_id FOR 100 INCREMENT 10;

• CREATE SEQUENCE seq_id START WITH 100 INCREMENT BY 10;

• SEQUENCE seq_id BEGIN 100 STEP 10;

• CREATE SEQUENCE seq_id VALUES 100 TO 1000;

• START SEQUENCE seq_id AT 100 BY 10;

Which group function returns the highest value in a column?

• MIN

• AVG

• SUM

• MAX

• COUNT

Which query calculates the average salary per department?

• SELECT department_id, AVG(salary) FROM employees GROUP BY department_id;

• SELECT AVG(salary) FROM employees;

• SELECT department_id, AVG(salary) FROM employees;

• SELECT department_id, salary FROM employees GROUP BY salary;

• SELECT AVG(salary) GROUP BY department_id FROM employees;

Which function is used to search a string with a pattern?

• SUBSTR

• REGEXP_LIKE

• TO_CHAR

• UPPER

• NVL

Which query returns employees who earn more than the average salary?

• SELECT * FROM employees WHERE salary = AVG(salary);

• SELECT AVG(salary) FROM employees WHERE salary > 5000;

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

• SELECT salary FROM employees HAVING salary > AVG(salary);

• SELECT * FROM employees JOIN (SELECT AVG(salary) FROM employees);