🎴 Flashcard Mode

Oracle Database Administration Fundamentals

Card1 / 20
Mastered0
Review0
QuestionClick to flip
  1. With SQL, how can you return the number of records in the "Persons" table?
AnswerClick to flip back
A
SELECT COUNT(*) FROM Persons
💡 Explanation:

To count records in SQL, use the COUNT(*) aggregate function. Option B shows the correct syntax. COUNT() without asterisk (option C) is incomplete, and SELECT COLUMNS() is not valid for counting records.

Change Mode