Introduction to SQL

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.



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.