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
The statement will execute successfully.
C
empid value should be given without single quotes.
D
empname value should be given without single quotes.
Correct answer: Value for phoneno is missing.
Explanation
Quick AnswerThe correct answer is Value for phoneno is missing. because it directly addresses the core logic of Database Management.
phoneno has a NOT NULL constraint so it must be provided; omitting it causes an error.