LX0-104 Exam QuestionsBrowse all questions from this exam

LX0-104 Exam - Question 6


SIMULATION -

What word is missing from the following SQL statement? insert into tablename ________(909, 'text');

(Please specify the missing word using lower-case letters only.)

Show Answer
Correct Answer:

The missing word in the SQL statement is 'values'. The correct SQL syntax for inserting a new row into a table is 'insert into tablename values (909, 'text');'. The 'values' keyword specifies the data to be inserted into the corresponding columns of the table.

Discussion

1 comment
Sign in to comment
linux_admin
Feb 12, 2023

The word missing from the following SQL statement is values. The complete SQL statement would be: insert into tablename values (909, 'text'); This statement inserts a new row into the table tablename with two columns, the first with the value 909 and the second with the value 'text'. The values keyword is used to specify the values to be inserted into the table.