IndiaBIX

Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 16)
Introduction to SQL
16.
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned.
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
16 comments Page 2 of 2.
Purnendra kushwaha said:   1 decade ago
Yes I m also agree with bhavika.
Bhavika said:   1 decade ago
Ya I agree with sundar.
Sundar said:   1 decade ago
The given answer is correct. Don't get confused. The questions is asked about only about *, not about whether the corresponding select query has any Where condition or any other limitations.
ANIKET said:   1 decade ago
SELECT * FROM STUDENT WHERE AGE=19;

Here when criteria get satisfied.
Those records get selected...
So i think option 2 is right....
M.VINOTHKUMAR said:   1 decade ago
A) is correct . because, all columns values will be returned.
Shruti Chouksey said:   1 decade ago
In this question 2nd and 3rd option is right because when we use * so we can all the Records with all coloums...
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers