What will be the output of the query given below?SELECT Student_id, FirstName, LastNameFROM StudentWHERE title= Monitor AND start_date=2017-02-25;

Only those columns which are mention with SELECT clause

Columns mention with SELECT clause and only those rows which contain Monitor as a title and start_date as 2017-02-25

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

1.	What will be the output of the query given below? SELECT Student_id, FirstName, LastName FROM Student WHERE 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 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 Student_id, FirstName, LastNameFROM StudentWHERE title= Monitor AND start_date=2017-02-25;

Discussion

No Comment Found

Related MCQs

Reply to Comment

What will be the output of the query given below?
SELECT Student_id, FirstName, LastName
FROM Student
WHERE title= Monitor AND start_date=2017-02-25;