Examine the structure of the emp table:
Examine the structure of the emp_vu1 view based on the emp table:
Now, examine this statement:
mysq1> INSERT INTO emp_vul VALUES ('Alice',20000) ;
What is true about executing the statement?
It inserts a row in the emp table.
It returns an error because an insert operation is not allowed on views.
It inserts a row in the view only.
It returns an error because the PRIMARY ACCOUNT column is not selected for the view definition.
Submit