61. What is the use of “VIEW” in Mysql?
    

1. 1. To hide the complexity of the database

   
   
   

   2. To simplify complexity of database design

   
   
   

   3. To hide columns from the users

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   All of above

---

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

---

---

63. In the following query, “Employee_1” belongs to which category of table in Mysql?
    

    CREATE VIEW Employee_1 AS
    SELECT firstname, lastname, Employee_id FROM Employee;
    

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: A

   “CREATE VIEW” creates “Virtual tables” only.

---

64. Find the missing clause from the query?
    

    CREATE VIEW Emp_1 AS
    SELECT firstname, lastname, Emp_id
    _________Emp;
    

1. 1. WHERE

   
   
   

   2. SELECT

   
   
   

   3. FROM

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “CREATE VIEW” cannot be used without “FROM” clause.

---

---

65. Which of the following statements is/are correct with respect to “VIEW”?
    

1. 1. “VIEW” creates virtual tables in Database

   
   
   

   2. “VIEW” is a query that stored in the data dictionary

   
   
   

   3. There is no data associated with “VIEW”

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   All of above

---