ExamVeda
Login
Home
This question belongs to Database Introduction To SQL
Introduction to SQL
?

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

Answer & Solution
Correct Answer: Option A
Option A: all columns of the table are to be returned. - According to the SQL-92 standard, using the asterisk () in an SQL SELECT statement querying a single table means that all columns of the table are to be returned.
Option B: all records meeting the full criteria are to be returned. - This option is incorrect. The asterisk () refers to columns, not records.
Option C: all records with even partial criteria met are to be returned. - This option is incorrect. The asterisk () does not relate to criteria or records but to columns.
Option D: None of the above is correct. - This option is incorrect because Option A correctly describes the meaning of the asterisk () in SQL-92 standard.
Conclusion:
In SQL-92 standard, using the asterisk (*) in an SQL SELECT statement querying a single table means that all columns of the table are to be returned. Therefore, the correct answer is Option A: all columns of the table are to be returned.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.