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 query returns employees who earn more than the average salary?

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

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

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

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

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

What is a sequence used for in Oracle SQL?

To generate unique numeric values

Which query creates a view showing employees with salary over 10000?

CREATE VIEW high_salary_employees AS SELECT * FROM employees WHERE salary > 10000;

VIEW high_salary_employees AS SELECT * FROM employees WHERE salary > 10000;

CREATE VIEW FROM employees WHERE salary > 10000;

SELECT * INTO high_salary_employees FROM employees WHERE salary > 10000;

CREATE VIEW high_salary_employees WHERE salary > 10000;

Which query returns the uppercase version of all employee names?

SELECT UPPER(name) FROM employees;

SELECT LOWER(name) FROM employees;

SELECT INITCAP(name) FROM employees;

SELECT REPLACE(name, 'a', 'A') FROM employees;

SELECT SUBSTR(name, 1) FROM employees;

Which query returns employees whose name starts with 'J'?

SELECT * FROM employees WHERE name LIKE '%J';

SELECT * FROM employees WHERE name = 'J%';

SELECT * FROM employees WHERE name CONTAINS 'J';

SELECT * FROM employees WHERE name STARTS WITH 'J';

What is the purpose of a synonym in Oracle?

To create an alias for a database object

Which query creates a synonym for the employees table?

CREATE SYNONYM emp FOR employees;

DEFINE SYNONYM employees AS emp;

Which query selects departments having more than 10 employees?

SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(*) > 10;

SELECT department_id FROM employees WHERE COUNT(*) > 10;

SELECT department_id GROUP BY COUNT(*) > 10;

SELECT department_id HAVING COUNT(*) > 10;

SELECT department_id FROM employees COUNT(*) > 10;

What is the purpose of the INITCAP function in SQL?

Capitalizes the first letter of each word in a string

Returns the number of characters

Which query creates a view of employees in department 10?

CREATE VIEW dept10_employees AS SELECT * FROM employees WHERE department_id = 10;

CREATE VIEW employees WHERE department_id = 10;

CREATE VIEW dept10_employees AS employees IN department 10;

VIEW dept10_employees FROM employees WHERE department_id = 10;

CREATE VIEW dept10_employees FROM employees WHERE department_id = 10;

Which query shows all employees who work in the same department as 'John'?

SELECT * FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE name = 'John');

SELECT * FROM employees WHERE name = 'John' AND department_id IS NOT NULL;

SELECT FROM employees WHERE EXISTS (SELECT FROM employees WHERE name = 'John');

SELECT * FROM employees JOIN departments ON employees.department_id = departments.id WHERE name = 'John';

SELECT * FROM employees WHERE department_id IN (name = 'John');

Which query joins the orders and customers tables using a natural join?

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

SELECT * FROM orders FULL JOIN customers ON orders.customer_id = customers.customer_id;

SELECT * FROM orders, customers WHERE orders.customer_id = customers.customer_id;

SELECT * FROM orders LEFT OUTER JOIN customers;

Which of the following is the correct use of the COALESCE function?

SELECT COALESCE(NULL, NULL, 'Hello') FROM dual;

SELECT COALESCE('Hello', NULL, NULL) AS greeting;

SELECT COALESCE FROM table_name;

SELECT * FROM COALESCE('x', 'y');

COALESCE('a', 'b') SELECT * FROM dual;

Which query counts the number of employees in each department?

SELECT department_id, COUNT(*) FROM employees GROUP BY department_id;

SELECT COUNT(department_id) FROM employees;

SELECT COUNT(*) GROUP BY department_id FROM employees;

SELECT department_id, COUNT(*) FROM employees;

SELECT COUNT(*) FROM employees WHERE department_id IS NOT NULL;

Which of the following statements about views is TRUE?

Views do not store data physically

Views can insert directly into sequences

Which function combines first and last name with a space in between?

SELECT first_name || ' ' || last_name FROM employees;

SELECT CONCAT(first_name, last_name) FROM employees;

SELECT first_name + last_name FROM employees;

SELECT CONCAT_WS(' ', first_name, last_name) FROM employees;

SELECT first_name & ' ' & last_name FROM employees;

What does the following subquery return? SELECT * FROM employees WHERE salary > (SELECT MAX(salary) FROM employees WHERE department_id = 30);

Employees earning more than the highest salary in department 30

Employees with the highest salary

Employees earning less than average

Which query returns all employees not in department 50?

SELECT * FROM employees WHERE department_id != 50;

SELECT * FROM employees WHERE department_id = 50;

SELECT * FROM employees WHERE department_id NOT IN 50;

SELECT * FROM employees EXCEPT department_id = 50;

SELECT * FROM employees WHERE department_id <> 50;

Which query creates a sequence that increments by 1 and starts at 1?

CREATE SEQUENCE seq1 START WITH 1 INCREMENT BY 1;

CREATE SEQUENCE seq1 BEGIN 1 STEP 1;

CREATE SEQUENCE seq1 VALUES (1, 1);

SEQUENCE seq1 START = 1 INCREMENT = 1;

CREATE NEW SEQUENCE seq1 STARTING AT 1;

What does the TO_CHAR function do in Oracle SQL?

Converts a number or date to a string

Changes the case of a character

Replaces characters in a string

Which query shows the highest salary in each department?

SELECT department_id, MAX(salary) FROM employees GROUP BY department_id;

SELECT department_id, salary FROM employees WHERE salary = MAX(salary);

SELECT MAX(salary) FROM employees;

SELECT department_id FROM employees GROUP BY MAX(salary);

SELECT * FROM employees GROUP BY department_id MAX(salary);

What is the result of this query? SELECT NVL(commission_pct, 0) FROM employees;

Replaces NULL commission values with 0

Shows only non-NULL commissions

What does the DISTINCT keyword do?

Removes duplicate rows from the result

What does this query do? SELECT * FROM employees WHERE REGEXP_LIKE(email, '^[a-zA-Z0-9._%+-]+@ oracle.com $');

Filters emails ending with @ oracle.com using regular expressions

Finds employees without email addresses

Changes email domain to oracle.com

Which query lists all departments that have no employees?

SELECT * FROM departments WHERE department_id NOT IN (SELECT DISTINCT department_id FROM employees);

SELECT FROM departments WHERE NOT EXISTS (SELECT FROM employees);

SELECT * FROM departments WHERE COUNT(employees) = 0;

SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(*) = 0;

SELECT * FROM departments WHERE department_id = 0;

ISYS6892003

Authored by nur anisa

Information Technology (IT)

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

40 questions

Show all answers

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is a subquery?

A type of join

A query within another query

A view definition

A sequence generator

A synonym

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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';

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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;

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which group function returns the highest value in a column?

MIN

AVG

SUM

MAX

COUNT

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

Microsoft Word Shortcut Keys Quiz

Quiz

•

University

40 questions

Encryption/Decryption

Quiz

•

University

39 questions

IT 306

Quiz

•

University

39 questions

Y10 revisionr

Quiz

•

9th Grade - University

35 questions

System Analysis and Design - Implementation

Quiz

•

12th Grade - University

45 questions

SAS GANJIL INFORMATIKA KELAS 7 TAHUN 2024-2025

Quiz

•

7th Grade - University

40 questions

QUIZ 3 - Data Design and Database Management

Quiz

•

University

40 questions

Final Test preparation and recap

Quiz

•

University

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

ISYS6892003

What is a subquery?

Which query finds names that end with 'son'?

Which of the following best defines a view?

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

What does the UPPER function do in SQL?

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

Which group function returns the highest value in a column?

Which query calculates the average salary per department?

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

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground