Where Clause


  1. In the following query “person_id” can be
    SELECT Emp_id, fname,Lname, Birth_date FROM Employee
    WHERE Emp_id=101;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    Primary Key or any other Attribute


  1. Which Clause is used to select a particular row from the set of row in an existing table?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    WHERE


  1. What will be the output of the query given below?
    SELECT emp_id, fname, lname
    FROM employee
    WHERE title='Manager’ AND start_date > 2016-03-20;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    Columns mention with “SELECT” clause and only those rows which contain ‘Manager’ as a “title” and start_date > 2016-03-20


  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;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    “WHERE” clause is used to filter out unwanted rows and “SELECT” clause is used to select columns from table.


  1. What will be the output of the query given below?
    SELECT Id, FirstName, LastName
    FROM Student
    WHERE title=’Monitor’;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    “WHERE” clause is used to filter out unwanted rows and “SELECT” clause is used to select columns from table.