MCQOPTIONS
Bookmark
Saved Bookmarks
→
Mysql
→
Data Types in Mysql
→
Which among the following operators is/are belongs..
1.
Which among the following operators is/are belongs to Range conditions ?
A.
>/<
B.
=
C.
<>
D.
!=
E.
None of these
Answer» B. =
Show Answer
Discussion
No Comment Found
Post Comment
Related MCQs
What will be the result of the following query?<br><pre class="prettyprint lang-c">WHERE TITLE= teller OR start_date= 2008-02-02 <br></pre>
What will be the result of the following query?<br><pre class="prettyprint lang-c">WHERE TITLE= teller AND start_date < 2007-01-01 <br></pre>
The following query belongs to which condition types?<br><pre class="prettyprint lang-c">SELECT firstname<br>FROM Employee<br>WHERE fed_id= 333-33-333 ;<br></pre>
The following query belongs to which condition types?<br><pre class="prettyprint lang-c">SELECT firstname<br>FROM Employee<br>WHERE title= Engineer ;<br></pre>
Does the following query belong to the Inequality condition ?<br><pre class="prettyprint lang-c">SELECT product_type.name, product.name<br>FROM product_type INNER JOIN Product<br>ON product_type.dept=Product.dept<br>WHERE product_type.name<> customers_accounts ;<br></pre>
Is the following query belongs to the Equality condition ?<br><pre class="prettyprint lang-c">SELECT product_type.name, product.name<br>FROM product_type INNER JOIN Product<br>ON product_type.dept=Product.dept<br>WHERE product_type.name= customers_accounts ;<br></pre>
What will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT *<br>FROM Student<br>WHERE start_date BETWEEN 2009-05-05 AND 2010-05-05 ;<br></pre>
What will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT accountid, productid, custid<br>FROM account<br>WHERE productid IN ( sav , chd , mm );<br></pre>
Find the error in the following query?<br><pre class="prettyprint lang-c">SELECT custid, fedid<br>FROM customer<br>WHERE custid = I <br>AND fedid BETWEEN 6000-00-000 AND 8888-888-000;<br></pre>
Consider a database name interviewmania whose attributes are intern_id (primary key), subject.<br>Internid = {1, 2, 3, 4, 5, 6}<br>Subject = {sql, oop, sql, oop, c, c++}<br>If these are one to one relation then what will be the output of the following query?<br><pre class="prettyprint lang-c">SELECT internid<br>FROM interviewmania<br>WHERE subject IN (c, c++, oop);<br></pre>
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply