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

All rows belong to table employee

All columns and rows belong to table employee

All columns but only those rows which contain Sergeant as a title or 1995-03-20 as a start_date

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 ) OR (start_date=1995-03-20);
A.	All rows belong to table employee
B.	All columns and rows belong to table employee
C.	All columns but only those rows which contain Sergeant as a title or 1995-03-20 as a start_date
D.	All of above
E.	None of these
Answer» D. All of above

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 ) OR (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 ) OR (start_date=1995-03-20);