1. Which Clause is used to select a particular table in Mysql?
   

1. 1. ALTER

   
   
   

   2. FROM

   
   
   

   3. WHERE

   
   
   

   4. SELECT

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   FROM

---

2. 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

---

3. 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

---

4. 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

---

5. Which among the following is an optional Keyword?
   

1. 1. AS

   
   
   

   2. ALL

   
   
   

   3. Both AS and ALL

   
   
   

   4. DISTINICTS

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “AS” and “ALL” are optional.

---