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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

Data Analytics Quiz

Quiz

•

University

35 questions

Dispute Resolution Exam

Quiz

•

University

40 questions

Quiz 3 - SAD

Quiz

•

University

35 questions

Internet of Things (IoT) Quiz

Quiz

•

University

40 questions

Revision Quiz

Quiz

•

University

40 questions

BTUI'24 - Inter-school ICT Quiz - Quarter Finals

Quiz

•

12th Grade - University

40 questions

ISD-topic 4

Quiz

•

University

35 questions

Legacy Round 1

Quiz

•

University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

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

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Information Technology (IT)

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

5 questions

What is Presidents' Day?

Interactive video

•

10th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

20 questions

Mardi Gras History

Quiz

•

6th Grade - University

10 questions

The Roaring 20's Crash Course US History

Interactive video

•

11th Grade - University

17 questions

Review9_TEACHER

Quiz

•

University

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

Discover more resources for Information Technology (IT)