What will be the output of the query given below?SELECT *FROM ArmyWHERE (title= Sergeant ) AND (start_date > 1995-03-20);

All rows belong to table employee

All columns but only those rows which contain Sergeant as a title and start_date are greater than 1995-03-20

All columns and rows belong to table employee

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

1.	What will be the output of the query given below? SELECT * FROM Army WHERE (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 be <pre class="prettyprint lang-c">SELECT Emp_id, fname,Lname, Birth_date FROM Employee WHERE Emp_id=101; </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT emp_id, fname, lname FROM employee WHERE title='Manager AND start_date > 2016-03-20; </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT * FROM Army WHERE (title= Sergeant ) OR (start_date=1995-03-20); </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT * FROM Student WHERE (title= Monitor ) AND (start_date=2019-01-25); </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT * FROM Student WHERE title= Monitor ; </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT * FROM employee WHERE (title= HEAD TELLER ) OR (start_date > 2013-01-24); </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT * FROM Army WHERE (title= Sergeant ) AND (start_date > 1995-03-20); </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT Student_id, FirstName, LastName FROM Student WHERE title= Monitor AND start_date=2017-02-25; </pre>
What will be the output of the query given below? <pre class="prettyprint lang-c">SELECT Id, FirstName, LastName FROM Student WHERE title= Monitor ; </pre>
Which clause is used to filter out unwanted Groups ?

What will be the output of the query given below?SELECT *FROM ArmyWHERE (title= Sergeant ) AND (start_date > 1995-03-20);

Discussion

No Comment Found

Related MCQs

Reply to Comment

What will be the output of the query given below?
SELECT *
FROM Army
WHERE (title= Sergeant ) AND (start_date > 1995-03-20);