What will be the output of the query given below?SELECT *FROM ArmyWHER – McqOptions

MCQOPTIONS

1.	What will be the output of the query given below?SELECT *FROM ArmyWHERE (title= Sergeant ) AND (start_date > 1995-03-20);
A.	All columns but only those rows which contain Sergeant as a title and start_date are greater than 1995-03-20
B.	All rows belong to table employee
C.	All columns and rows belong to table employee
D.	All of above
E.	None of these
Answer» B. All rows belong to table employee

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 ?