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. True or False: The DISTINCT keyword removes NULL values from query results.

True

False

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

ASC

DESC

REVERSE

DOWN

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

==

=

=>

>>

5. 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

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;

Submit

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

SUM

AVG

COUNT

MAX

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

True

False

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

True

False

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

True

False

Submit

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

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

%

_

*

?

16. 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

17. 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

18. 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

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. True or False: The DISTINCT keyword removes NULL values from query results.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?