General Questions on Structured Query Language (SQL) related Questions and Answers

Question :   In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: 1. all columns of the table are to be returned. 2. all records meeting the full criteria are to be returned. 3. all records with even partial criteria met are to be returned. 4. None of the above is correct. Answer :   1 - all columns of the table are to be returned.