MENU
What word is missing from the following SQL statement?
insert into tablename ________(909, 'text');
(Please specify the missing word using lower-case letters only.)
Suggested Answer: C
Get Premium LFCS Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
ST
Stefania
11 months ago
I disagree, it should be "insert" instead!
AN
Antonette
12 months ago
Wait, is it really "values"? Seems too simple.
BR
Britt
12 months ago
I thought it could be "value" too, but I guess not.
CA
Cassi
1 year ago
Yup, it's values for sure.
LE
Leota
1 year ago
Definitely "values"!
IL
Ilona
1 year ago
I’m pretty certain it’s "values," but I just hope I remember the syntax correctly during the exam!
MA
Malcolm
1 year ago
I feel like it could also be "value," but that doesn't seem right for multiple entries.
SH
Shasta
1 year ago
I remember practicing a similar question where we had to use "values" in an insert statement.
HE
Herminia
1 year ago
I think the missing word is "values," but I'm not 100% sure if it should be in lowercase.
SH
Sherly
1 year ago
I think the Service Cloud license could also work, since it includes case management functionality. But the Partner Community license seems more tailored to the partner-focused requirements described.
LA
Laura
1 year ago
I recall doing a similar question on income tax last week, but I think we didn't include the surcharge and cess. I'm a bit confused.
VE
Veda
1 year ago
The question is asking for 3 correct statements, so I'll need to carefully consider each option and make sure I select the best ones.
TR
Trina
2 years ago
I'm just imagining someone staring at this question, scratching their head, and thinking, 'Hmm, I wonder if it's 'insert' or 'delete' or maybe even 'update'? Spoiler alert: it's 'values', my friend. Time to 'insert' some SQL basics into that noggin of yours.
KA
Kanisha
1 year ago
values
CH
Chana
1 year ago
values
NI
Nieves
1 year ago
values
SH
Shanda
2 years ago
Seriously, if you didn't nail this one, you might need to 'insert' some more SQL knowledge into that brain of yours. 'values' is the way to go, and I'm not 'inserting' any doubt about that.
CO
Coral
1 year ago
values
JA
Jackie
1 year ago
values
MO
Mollie
1 year ago
values
JU
Jutta
1 year ago
values
LA
Lazaro
1 year ago
values
EZ
Ezekiel
1 year ago
values
IS
Isreal
2 years ago
Well, well, well, look at this tricky little SQL statement. 'values' is the missing word, and if you didn't get that, I'm starting to question your 'table' manners in the database world.
AL
Alaine
2 years ago
Okay, let's be real here. If you don't know the answer to this one, you might as well just pack up and go home. 'values' is the only option that doesn't make me want to 'insert' my head into a wall.
MA
Man
2 years ago
I agree with Garry, values is the missing word in the SQL statement.
RO
Rodolfo
2 years ago
Ah, the classic missing word conundrum! I think we all know the answer is 'values' - it's the only one that makes sense grammatically. Let's hope the exam doesn't get too 'value-less' from here on out.
DE
Desirae
1 year ago
'Values' is the only option that makes sense in that SQL statement.
SA
Santos
1 year ago
I think we can all safely say that 'values' is the missing word here.
JE
Jesusa
1 year ago
Yes, 'values' is the correct answer. It fits perfectly in the statement.
ES
Estrella
2 years ago
I agree, 'values' is definitely the missing word in the SQL statement.
GA
Garry
2 years ago
I think the missing word is values because it is used to specify the data to be inserted into the table.
SE
Serina
2 years ago
values