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_nameFROM studentWHERE 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?WHERE TITLE= teller OR start_date= 2008-02-02
What will be the result of the following query?WHERE TITLE= teller AND start_date < 2007-01-01
The following query belongs to which condition types?SELECT firstnameFROM EmployeeWHERE fed_id= 333-33-333 ;
The following query belongs to which condition types?SELECT firstnameFROM EmployeeWHERE title= Engineer ;
Does the following query belong to the Inequality condition ?SELECT product_type.name, product.nameFROM product_type INNER JOIN ProductON product_type.dept=Product.deptWHERE product_type.name<> customers_accounts ;
Is the following query belongs to the Equality condition ?SELECT product_type.name, product.nameFROM product_type INNER JOIN ProductON product_type.dept=Product.deptWHERE product_type.name= customers_accounts ;
What will be the output of the following query?SELECT *FROM StudentWHERE start_date BETWEEN 2009-05-05 AND 2010-05-05 ;
What will be the output of the following query?SELECT accountid, productid, custidFROM accountWHERE productid IN ( sav , chd , mm );
Find the error in the following query?SELECT custid, fedidFROM customerWHERE custid = I AND fedid BETWEEN 6000-00-000 AND 8888-888-000;
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?SELECT internidFROM interviewmaniaWHERE subject IN (c, c++, oop);

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