Create Tables
- What is the default value of column?
-
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.
- 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 */
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
No Error
- 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 */
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
Emp_id declared as a primary key therefore it never contain same value.
- Which feature is used for automatic increment of the column?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
AUTO_INCREMENT
- Which statement can be used for modifying the definition for an existing table?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
ALTER