11. Which line of the following statements will produce error?
    

1. 1. SELECT Emp_name FROM Employee;

   
   
   

   2. SELECT Fname,Lname, Employee_id FROM Employee;

   
   
   

   3. SELECT * FROM Employee WHERE Employee_id=1;

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: E

   None of these

---

12. Which command is used to remove existing tables or database?
    

1. 1. DELETE

   
   
   

   2. Either DROP TABLE or DELETE

   
   
   

   3. DROP TABLE

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   DROP TABLE

---

---

13. Which command is used to display all the existing tables in a database?
    

1. 1. SHOW

   
   
   

   2. SHOW TABLES

   
   
   

   3. SHOW TABLE

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   SHOW TABLES

---

14. Is duplicate entry of primary key is allowed in SQL?
    

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

   Primary key are used to uniquely define attributed stored in the table.

---

---

15. Is duplicate entry of other attributes are allowed in SQL?
    

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

   Duplicate values are allowed but not for Primary Key attributes.

---