Select Query


  1. What will be the output of a query given below?
    SELECT Employee_id, FirstName, LastName
    FROM Employee
    WHERE Employee_id=1;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    Clause “WHERE” is also used, which tell the compiler to show only that rows which are belong to Employee_id=1.


  1. What will be the output of a query given below?
    SELECT  * FROM Employee
    WHERE Employee_id=1;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    Clause “WHERE” is also used, which tell the compiler to show only that rows which belong to Employee_id=1.


  1. Find the error?
    SELECT *;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    “SELECT” clause cannot be used without clause “FROM”.


  1. Can “SELECT” clause be used without the clause “FROM”?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    “SELECT” clause is used to show rows and columns of a particular table and clause “from” is used to denote a table name.


  1. What will be the output of a query given below?
    SELECT Employee_id, FirstName, LastName
    FROM person;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    “SELECT” clause is used to show all rows and columns that are mention with the query.