What will be the output of the following query?SELECT stu_id, first_name, last_nameFROM studentWHERE LEFT (first_name, 1) = F OR LEFT (last_name, 1) = F ;

Only those student are selected whose first name started with F but last name can be starts with any other letter

Only those student are selected whose first name and last name started with any other letter except F

Only those student are selected whose first name and last name started with F

What will be the output of the following query?SELECT stu_id, first_na

1.	What will be the output of the following query? SELECT stu_id, first_name, last_name FROM student WHERE LEFT (first_name, 1) = F OR LEFT (last_name, 1) = F ;
A.	Only those student are selected whose first name and last name started with any other letter except F
B.	Only those student are selected whose first name and last name started with F
C.	Only those student are selected whose first name started with F but last name can be starts with any other letter
D.	All of above
E.	None of these
Answer» C. Only those student are selected whose first name started with F but last name can be starts with any other letter

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 stu_id, first_name, last_nameFROM studentWHERE LEFT (first_name, 1) = F OR LEFT (last_name, 1) = F ;

Discussion

No Comment Found

Related MCQs

Reply to Comment

What will be the output of the following query?
SELECT stu_id, first_name, last_name
FROM student
WHERE LEFT (first_name, 1) = F OR LEFT (last_name, 1) = F ;