What will be the output of the following query?SELECT accountid, productid, custidFROM accountWHERE productid IN ( sav , chd , mm );

Only those values are selected whose productid is either sav

Only those values are selected whose productid is either sav , chd

Only those values are selected whose productid is either sav , chd , mm

What will be the output of the following query?SELECT accountid, produ

1.	What will be the output of the following query? SELECT accountid, productid, custid FROM account WHERE productid IN ( sav , chd , mm );
A.	Only those values are selected whose productid is either sav
B.	Only those values are selected whose productid is either sav , chd
C.	Only those values are selected whose productid is either sav , chd , mm
D.	All of above
E.	None of these
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

What will be the result of the following query? <pre class="prettyprint lang-c">WHERE TITLE= teller OR start_date= 2008-02-02 </pre>
What will be the result of the following query? <pre class="prettyprint lang-c">WHERE TITLE= teller AND start_date < 2007-01-01 </pre>
The following query belongs to which condition types? <pre class="prettyprint lang-c">SELECT firstname FROM Employee WHERE fed_id= 333-33-333 ; </pre>
The following query belongs to which condition types? <pre class="prettyprint lang-c">SELECT firstname FROM Employee WHERE title= Engineer ; </pre>
Does the following query belong to the Inequality condition ? <pre class="prettyprint lang-c">SELECT product_type.name, product.name FROM product_type INNER JOIN Product ON product_type.dept=Product.dept WHERE product_type.name<> customers_accounts ; </pre>
Is the following query belongs to the Equality condition ? <pre class="prettyprint lang-c">SELECT product_type.name, product.name FROM product_type INNER JOIN Product ON product_type.dept=Product.dept WHERE product_type.name= customers_accounts ; </pre>
What will be the output of the following query? <pre class="prettyprint lang-c">SELECT * FROM Student WHERE start_date BETWEEN 2009-05-05 AND 2010-05-05 ; </pre>
What will be the output of the following query? <pre class="prettyprint lang-c">SELECT accountid, productid, custid FROM account WHERE productid IN ( sav , chd , mm ); </pre>
Find the error in the following query? <pre class="prettyprint lang-c">SELECT custid, fedid FROM customer WHERE custid = I AND fedid BETWEEN 6000-00-000 AND 8888-888-000; </pre>
Consider a database name interviewmania whose attributes are intern_id (primary key), subject. Internid = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} If these are one to one relation then what will be the output of the following query? <pre class="prettyprint lang-c">SELECT internid FROM interviewmania WHERE subject IN (c, c++, oop); </pre>

What will be the output of the following query?SELECT accountid, productid, custidFROM accountWHERE productid IN ( sav , chd , mm );

Discussion

No Comment Found

Related MCQs

Reply to Comment

What will be the output of the following query?
SELECT accountid, productid, custid
FROM account
WHERE productid IN ( sav , chd , mm );