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
Quick AnswerThe correct answer is Value for phoneno is missing., empid value should be given without single quotes. because it directly addresses the core logic of Database Management.
phoneno has a NOT NULL constraint so it must be provided. The statement fails because phoneno is missing.