Consider a database name interviewmania 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 interviewmaniaWHERE subject IN (SELECT subject FROM interviewmania WHERE subjectvalue IN (3, 2));

Consider a database name interviewmania whose attributes are interni

1.	Consider a database name interviewmania 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 interviewmania WHERE subject IN (SELECT subject FROM interviewmania WHERE subjectvalue IN (3, 2));
A.	{1, 2, 3, 4, 5, 6}
B.	{3, 4}
C.	{1, 2, 3}
D.	{5, 6}
E.	None of these
Answer» B. {3, 4}

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