🎴 Flashcard Mode
Oracle SQL Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
With SQL, how do you select all the columns from a table named "Persons"?
AnswerClick to flip back
A
SELECT * FROM Persons
💡 Explanation:
To select all columns from a table in SQL, use the asterisk (*) wildcard with 'SELECT * FROM table_name'. Option A '[all]' is invalid SQL syntax. Option B 'SELECT Persons' would cause an error - it's interpreted as selecting a column named 'Persons', not the table. Option C 'SELECT *.Persons' is invalid syntax. Option D correctly uses the standard SQL wildcard syntax.