Consider the below table structure: Column Name DataType Constraint Empname Varchar(20) Not Null EmpId int(10) PK Phoneno bigint(10) Not Null insert into employee(empid,empname)values('123','John'); When we issue the above insert command and if the statement fails, what would be the reason.
Answer options
A
Value for phoneno is missing.
B
empid value should be given without single quotes.
C
The statement will execute successfully.
D
The empname value should be given without single quotes.
Correct answer: Value for phoneno is missing., empid value should be given without single quotes.
Explanation
phoneno has a NOT NULL constraint so it must be provided. empid is numeric so no quotes needed — that part is actually correct; the real issue is only the missing phoneno value.