Question

Insert into employee ____ (1002, Joey, 2000); In the given query which of the keyword has to be inserted?

a) Table
b) Values
c) Relation
d) Field

Answer 1

The keyword that needs to be inserted in the given SQL query is 'VALUES'. This keyword is used in SQL syntax to specify the values that are being inserted into a table.

Step-by-step explanation:

In the given query, the keyword that needs to be inserted is VALUES. The correct syntax to insert a record into a SQL table is INSERT INTO table_name VALUES (value1, value2, value3, ...);. So, the complete correct SQL statement to insert the values (1002, Joey, 2000) into the table 'employee' should be INSERT INTO employee VALUES (1002, 'Joey', 2000);