16. Which is the correct format to store date in the SQL?
    

1. 1. 1991-11-01

   
   
   

   2. 01-DEC-12

   
   
   

   3. 01-1991-11

   
   
   

   4. DEC-01-1991

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   1991-11-01

---

17. Which of the following are the valid “database datatypes” in Mysql?
    

1. 1. Temporal

   
   
   

   2. Text

   
   
   

   3. Numerical

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   Temporal, Text and Numerical are the valid “database datatypes” in Mysql.

---

---

18. Find the error?
    

    CREATE TABLE Employee
    ( Employee_id SMALLINT, name VARCHAR, LAST VARCHAR
      CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));
      INSERT INTO Employee
      VALUES( Employee_id, name, LAST)
      (1, ’s’, ’p’);
      INSERT INTO person
      ( Employee_id, name, LAST)
      VALUES(1,’s’,’p’);
    

1. 1. Error, Duplicate value

   
   
   

   2. Any other error

   
   
   

   3. No error

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   Primary can never have same value.

---

19. Find the error
    

    CREATE TABLE Employee
      (Employee_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE
      CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));
      INSERT INTO Employee
      VALUES(Employee_id, name, LAST, Birth_date)
      (1,’s’,’p’, 24-1991-01);
    

1. 1. No error

   
   
   

   2. Any other error

   
   
   

   3. In correct data value

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Format for DATE datatype is YYYY-MM-DD.

---

---

20. Which Key is used to link two tables in Mysql?
    

1. 1. Foreign Key

   
   
   

   2. Primary Key

   
   
   

   3. Both Primary and Foreign Key

   
   
   

   4. Undefined Key

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   Foreign Key is only the Key which can link two tables.

---