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.
Explanation
Quick AnswerThe correct answer is Value for phoneno is missing. because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.