LPI Exam 102-500 Topic 11 Question 90 Discussion

Actual exam question for LPI's 102-500 exam

Question #: 90
Topic #: 11

[All 102-500 Questions]

What word is missing from the following SQL statement?

__________ count(*) from tablename;

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

Aselect

Show Suggested Answer

Suggested Answer: B, E

by Fallon at Sep 18, 2024, 05:57 AM

Limited Time Offer

25%

Off

Get Premium 102-500 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Fabiola

2 months ago

The missing word is 'abracadabra'. You know, for those SQL statements that require a little bit of magic.

upvoted 0 times

...

Jonelle

2 months ago

I got this! The missing word is 'select'. Anyone who's been around SQL for more than a day should know that.

upvoted 0 times

...

Narcisa

3 months ago

Definitely 'select'. This is a basic SQL query, and 'select' is the keyword that initiates the data retrieval process.

upvoted 0 times

Sheron

1 months ago

Yes, the missing word is 'select'.

upvoted 0 times

...

Wayne

2 months ago

from

upvoted 0 times

...

Vicki

2 months ago

No, the missing word is 'select', not 'count'.

upvoted 0 times

...

Daniela

2 months ago

count

upvoted 0 times

...

Ellsworth

2 months ago

That's correct! 'select' is the missing word in the SQL statement.

upvoted 0 times

...

Dana

2 months ago

select

upvoted 0 times

...

Evangelina

3 months ago

Hmm, 'select' seems too obvious. Maybe it's something more obscure like 'calculate' or 'enumerate'? I'll give it a shot.

upvoted 0 times

Ronny

2 months ago

I'll go with 'calculate'.

upvoted 0 times

...

Alisha

2 months ago

I think it might be 'enumerate'.

upvoted 0 times

...

Hyman

2 months ago

Maybe it's 'calculate'?

upvoted 0 times

...

Leanna

4 months ago

I think the missing word is 'select'. It's a pretty standard SQL statement to get the count of rows in a table.

upvoted 0 times

Ernie

3 months ago

You got it! 'select' is the missing word.

upvoted 0 times

...

Carlton

3 months ago

Definitely 'select'. Good job!

upvoted 0 times

...

King

3 months ago

That's right, it should be 'select'.

upvoted 0 times

...

Belen

3 months ago

Yes, you're correct. The missing word is 'select'.

upvoted 0 times

...

Cornell

4 months ago

Yes, 'select' is the missing word because it is used to retrieve data from a database.

upvoted 0 times

...

Mabelle

4 months ago

I agree with Esteban, it should be 'select'.

upvoted 0 times

...

Esteban

4 months ago

The missing word is 'select'.

upvoted 0 times

...