16. What will be the output of a query given below?
    

    SELECT Employee_id, FirstName, LastName
    FROM Employee
    WHERE Employee_id=1;
    

1. 1. Show all columns and rows

   
   
   

   2. Shows only columns Employee_id

   
   
   

   3. Show only columns(Employee_id, FirstName, LastName) but only those rows which belongs to Employee_id=1

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

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.

---

17. What will be the output of a query given below?
    

    SELECT  * FROM Employee
    WHERE Employee_id=1;
    

1. 1. Show all columns and rows

   
   
   

   2. Shows only columns Employee_id

   
   
   

   3. Show all columns but only those rows which belongs to Employee_id=1

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

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.

---

18. Find the error?
    

    SELECT *;
    

1. 1. No table mentioned

   
   
   

   2. Depends

   
   
   

   3. No Error

   
   
   

   4. All of these

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

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

---

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

1. 1. DEPENDS

   
   
   

   2. YES

   
   
   

   3. NO

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

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.

---

20. What will be the output of a query given below?
    

    SELECT Employee_id, FirstName, LastName
    FROM person;
    

1. 1. Show all columns except (Employee_id, FirstName, LastName)

   
   
   

   2. Show all rows

   
   
   

   3. Show only columns (Employee_id, FirstName, LastName)

   
   
   

   4. Show only columns (Employee_id, FirstName, LastName) and rows related to these columns

   
   
   

   5. None of these

   
   
   

---

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.

---