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 1 of 2.
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...
M.VINOTHKUMAR said:   1 decade ago
A) is correct . because, all columns values will be returned.
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....
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.
Bhavika said:   1 decade ago
Ya I agree with sundar.
Purnendra kushwaha said:   1 decade ago
Yes I m also agree with bhavika.
Vijay said:   1 decade ago
Yes I agree with Sundar.
Basha said:   1 decade ago
Yes I Agree with Vijay....
Pavan Kumar said:   1 decade ago
In SQL, we can use the asterik mark(*) to retrive all the table data instead of giving all attribute names in the Query!
SELECT * FROM EMP;
Pooja said:   1 decade ago
Can anyone explain me which are the SQL standards?
Post your comments here:

Your comments will be displayed after verification.

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