Introduction to SQL - Technical MCQs

Q1:

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

A all columns of the table are to be returned.

B all records meeting the full criteria are to be returned.

C all records with even partial criteria met are to be returned.

D None of the above is correct.

ANS:A - all columns of the table are to be returned.

Sql-92 was the third edition of SQL database query language. The later version of SQL is,

> SQL-99, SQL-2003, SQL-2008, SQL-2011.

And * means it will return all column of a table whether all record meets full criteria or not.