Oracle SQL SELECT Statement Fundamentals

1. In Oracle SQL, what is the correct syntax to retrieve all columns from the EMPLOYEES table?

SELECT * FROM EMPLOYEES;

SELECT ALL FROM EMPLOYEES;

SELECT COLUMNS FROM EMPLOYEES;

SELECT ROWS FROM EMPLOYEES;

2. In Oracle SQL, which keyword sorts results in descending order?

ASC

DESC

REVERSE

DOWN

3. Which of the following is a valid comparison operator in a WHERE clause?

==

=

=>

>>

4. In Oracle SQL, what does the DISTINCT keyword do?

Removes duplicate rows from results

Sorts rows alphabetically

Limits the number of rows returned

Groups rows by column values

5. Which aggregate function returns the average of numeric values?

SUM

AVG

COUNT

MAX

6. What is the correct syntax for an INNER JOIN between EMPLOYEES and DEPARTMENTS tables?

SELECT * FROM EMPLOYEES JOIN DEPARTMENTS ON EMPLOYEES.DEPT_ID = DEPARTMENTS.DEPT_ID;

SELECT * FROM EMPLOYEES WHERE DEPARTMENTS.DEPT_ID;

SELECT * FROM EMPLOYEES AND DEPARTMENTS;

SELECT * FROM EMPLOYEES MERGE DEPARTMENTS;

7. True or False: In Oracle SQL, the FROM clause must appear before the WHERE clause in a SELECT statement.

True

False

8. True or False: The DISTINCT keyword removes NULL values from query results.

True

False

9. True or False: An INNER JOIN can return rows that don't have matching values in both tables.

True

False

Submit

11. What is the purpose of an INNER JOIN in SQL?

Returns all rows from the left table

Returns matching rows from both tables

Returns all rows from both tables

Returns rows that don't match

12. Which operator is used in a WHERE clause to filter rows based on multiple conditions?

OR and AND

IF and THEN

CASE and WHEN

FOR and WHILE

13. In Oracle SQL, which wildcard character matches any single character?

%

_

*

?

14. What does the LIKE operator with '%' do in a WHERE clause?

Matches exactly one character

Matches zero or more characters

Matches entire strings only

Performs numeric comparison

Submit

17. True or False: The ORDER BY clause must appear before the WHERE clause in a SELECT statement.

True

False

18. What does the ORDER BY clause do in a SELECT statement?

Filters rows based on a condition

Sorts the result set in ascending or descending order

Groups rows by specified columns

Joins two or more tables

19. Which clause is used to filter groups of rows in a SELECT statement?

WHERE

HAVING

ORDER BY

GROUP BY

20. Which clause in a SELECT statement specifies the columns to retrieve from a table?

FROM

WHERE

SELECT

ORDER BY

Oracle SQL Associate SELECT Statement Fundamentals Quiz

1. In Oracle SQL, what is the correct syntax to retrieve all columns from the EMPLOYEES table?

2.

What first name or nickname would you like us to use?

2. In Oracle SQL, which keyword sorts results in descending order?

3. Which of the following is a valid comparison operator in a WHERE clause?

4. In Oracle SQL, what does the DISTINCT keyword do?

5. Which aggregate function returns the average of numeric values?

6. What is the correct syntax for an INNER JOIN between EMPLOYEES and DEPARTMENTS tables?

7. True or False: In Oracle SQL, the FROM clause must appear before the WHERE clause in a SELECT statement.

8. True or False: The DISTINCT keyword removes NULL values from query results.

9. True or False: An INNER JOIN can return rows that don't have matching values in both tables.

10. A LEFT OUTER JOIN returns all rows from the _____ table and matching rows from the right table.

11. What is the purpose of an INNER JOIN in SQL?

12. Which operator is used in a WHERE clause to filter rows based on multiple conditions?

13. In Oracle SQL, which wildcard character matches any single character?

14. What does the LIKE operator with '%' do in a WHERE clause?

15. In Oracle SQL, the WHERE clause is evaluated _____ the SELECT clause.

16. The _____ clause is used to combine rows from multiple tables based on a related column.

17. True or False: The ORDER BY clause must appear before the WHERE clause in a SELECT statement.

18. What does the ORDER BY clause do in a SELECT statement?

19. Which clause is used to filter groups of rows in a SELECT statement?

20. Which clause in a SELECT statement specifies the columns to retrieve from a table?