Practice Test GeeksOracle SQL Practice Test
← All Oracle SQL Flashcard Decks

Oracle SQL SELECT Statements Flashcards

6 cards from real Oracle SQL practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Oracle SQL SELECT Statements flashcards as text

  1. Which Oracle SQL clause must appear in every SELECT statement?

    Answer: FROM

    Every SELECT statement in Oracle must include a FROM clause (or use DUAL), as Oracle requires a table source.

  2. What is the default sort order when ORDER BY is used in Oracle SQL?

    Answer: ASC

    By default, ORDER BY sorts in ascending order (ASC), placing the smallest or earliest values first.

  3. Which Oracle SQL syntax correctly uses a column alias in ORDER BY?

    Answer: SELECT salary * 12 annual_sal FROM emp ORDER BY annual_sal

    In Oracle SQL, column aliases defined in the SELECT list can be referenced in the ORDER BY clause.

  4. Which Oracle SQL operator is used for pattern matching in a WHERE clause?

    Answer: LIKE

    The LIKE operator enables wildcard pattern matching using % (any sequence of characters) and _ (any single character).

  5. What does SELECT * FROM employees WHERE manager_id IS NULL return?

    Answer: Rows where manager_id has no value stored

    IS NULL checks for the absence of a value; rows where manager_id has never been set (top-level managers) are returned.

  6. Which Oracle SQL feature allows you to give a table a shorter name within a query?

    Answer: Table alias

    A table alias provides a short alternative name for a table within the query, improving readability and required for self-joins.