Consider a database name interveiwmania whose attributes are internid (primary key), subject, subjectvalue.Internid = {1, 2, 3, 4, 5, 6}Subject = {sql, oop, sql, oop, c, c++}Subjectvalue = {0, 0, 1, 1, 2, 2, 3, 3}If these are one to one relation then what will be the output of the following query?SELECT internidFROM interveiwmaniaWHERE subject IN (SELECT subject FROM interveiwmania WHERE subjectvalue = 3);

Consider a database name interveiwmania whose attributes are interni

1.	Consider a database name interveiwmania whose attributes are internid (primary key), subject, subjectvalue. Internid = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} Subjectvalue = {0, 0, 1, 1, 2, 2, 3, 3} If these are one to one relation then what will be the output of the following query? SELECT internid FROM interveiwmania WHERE subject IN (SELECT subject FROM interveiwmania WHERE subjectvalue = 3);
A.	{1, 2, 3}
B.	{3, 4}
C.	{5, 6}
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>

Discussion

No Comment Found

Related MCQs

Reply to Comment