Create Tables


  1. What is the default value of column?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    When table is defined in Mysql then each column related to table will contain NULL Value as default.


  1. Will this query produce any error?
    INSERT INTO Employee
    (Emp_id, fname,lname)
    VALUES (101,’Sujit’,'Gupta'),
    VALUES (102,’Ajit’,’Gupta’);
    /* where person_id is a primary key */











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    No Error


  1. Will this query produce any error?
    INSERT INTO Employee
    (Emp_id, fname,lname)
    VALUES (101,’Sujit’,’Gupta’),
    VALUES (101,’Ajit’,’Gupta’);
    /* where person_id is a primary key */











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    Emp_id declared as a primary key therefore it never contain same value.


  1. Which feature is used for automatic increment of the column?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    AUTO_INCREMENT


  1. Which statement can be used for modifying the definition for an existing table?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    ALTER