21. Which command is used to create “Temporary tables” in Mysql?
    

1. 1. CREATE DATABASE;

   
   
   

   2. CREATE TABLE;

   
   
   

   3. CREATE VIEW

   
   
   

   4. Both CREATE TABLE; and CREATE VIEW

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: E

   “Temporary Tables” are output format of any query.

---

22. “CREATE VIEW …” command is used to create which type of table in Mysql?
    

1. 1. Temporary tables

   
   
   

   2. Permanent Tables

   
   
   

   3. Virtual tables

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   CREATE VIEW is used to create Virtual tables.

---

---

23. What is the meaning of “Temporary Tables” in Mysql?
    

1. 1. Permanent tables

   
   
   

   2. Virtual tables

   
   
   

   3. Rows returned by sub query

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “Temporary Tables” are output format of any query on Mysql.

---

24. “SELECT” clause cannot be used without which clause in Mysql?
    

1. 1. WHERE

   
   
   

   2. ORDER BY

   
   
   

   3. FROM

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “FROM” clause is necessary to point out tables in database.

---

---

25. “CREATE TABLE …” command is used to create which type of table in Mysql?
    

1. 1. Virtual tables

   
   
   

   2. Temporary tables

   
   
   

   3. Permanent Tables

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   CREATE table is used to create permanent tables in database.

---