21. Which statement is used to select columns and rows from the table?
    

1. 1. ALTER

   
   
   

   2. FROM

   
   
   

   3. SELECT

   
   
   

   4. MODIFY

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   SELECT

---

22. In the following query “Employee” stands for
    

    SELECT Emp_id, fname, lname, Birth_date
       FROM Employee;
    

1. 1. Attribute

   
   
   

   2. Multivalued attribute

   
   
   

   3. Table name

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   Table name

---

---

23. In the following query “*” stands for
    

     SELECT * FROM Employee;
    

1. 1. Retrieve data of primary key only

   
   
   

   2. Retrieve NULL data

   
   
   

   3. Retrieve all data from the table

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Retrieve all data from the table

---