What will be the output of the query given below?SELECT Student_id, Fi – McqOptions

MCQOPTIONS

1.	What will be the output of the query given below?SELECT Student_id, FirstName, LastNameFROM StudentWHERE title= Monitor AND start_date=2017-02-25;
A.	Only those columns which are mention with SELECT clause
B.	Columns mention with SELECT clause and only those rows which contain Monitor as a title and start_date as 2017-02-25
C.	All columns
D.	All of above
E.	None of these
Answer» C. All columns

Discussion

No Comment Found

Related MCQs

In the following query person_id can beSELECT Emp_id, fname,Lname, Birth_date FROM Employee WHERE Emp_id=101;
What will be the output of the query given below?SELECT emp_id, fname, lnameFROM employeeWHERE title='Manager AND start_date > 2016-03-20;
What will be the output of the query given below?SELECT *FROM ArmyWHERE (title= Sergeant ) OR (start_date=1995-03-20);
What will be the output of the query given below?SELECT *FROM StudentWHERE (title= Monitor ) AND (start_date=2019-01-25);
What will be the output of the query given below?SELECT *FROM StudentWHERE title= Monitor ;
What will be the output of the query given below?SELECT *FROM employeeWHERE (title= HEAD TELLER ) OR (start_date > 2013-01-24);
What will be the output of the query given below?SELECT *FROM ArmyWHERE (title= Sergeant ) AND (start_date > 1995-03-20);
What will be the output of the query given below?SELECT Student_id, FirstName, LastNameFROM StudentWHERE title= Monitor AND start_date=2017-02-25;
What will be the output of the query given below?SELECT Id, FirstName, LastNameFROM StudentWHERE title= Monitor ;
Which clause is used to filter out unwanted Groups ?