MENU
What word is missing from the following SQL statement?
__________ count(*) from tablename;
(Please specify the missing word using lower-case letters only.)
Suggested Answer: B, E
Get Premium 102-500 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
35 comments · newest first
CH
Charlette
11 months ago
Are you sure it's not "get"?
TE
Teri
11 months ago
Yup, "select" is the right one!
JO
Josephine
11 months ago
I thought it was "fetch" for a second.
ED
Edelmira
12 months ago
Definitely "select"!
TA
Tamera
12 months ago
select
NO
Noel
12 months ago
Definitely "select." I recall it being the standard way to start a SQL statement for retrieving data.
KI
Kina
1 year ago
I’m a bit confused. Is it "select" or could it be "from"? I feel like I’ve seen both used in different contexts.
IR
Ira
1 year ago
I remember practicing a similar question where we had to fill in the blanks for SQL queries. "Select" seems right here.
GE
Gertude
1 year ago
I think the missing word is "select," but I’m not entirely sure if it could be something else.
HO
Honey
1 year ago
Select! That's gotta be it. I'm pretty confident that's the missing word in this SQL statement to get the row count. Feels like a straightforward question.
SA
Sage
1 year ago
Okay, I think I know the answer, but I want to double-check my work. The missing word is "select", right? That's the standard way to start a SQL statement and get a count of the rows.
ON
Onita
1 year ago
Hmm, let me think about this... I know the basic SQL query structure, but I'm not totally sure what the missing word is here. I'll have to think it through carefully.
DE
Delisa
1 year ago
I've got this one! The missing word is "select" - that's the standard way to start a SQL query and get the count of rows in a table.
GL
Glory
1 year ago
Hmm, I'm a bit unsure about this one. The distance requirement of over 300 miles is throwing me off. I'll need to review the Data Guard options and their capabilities for long-distance replication.
FA
Fabiola
1 year ago
The missing word is 'abracadabra'. You know, for those SQL statements that require a little bit of magic.
JO
Jonelle
1 year ago
I got this! The missing word is 'select'. Anyone who's been around SQL for more than a day should know that.
NA
Narcisa
1 year ago
Definitely 'select'. This is a basic SQL query, and 'select' is the keyword that initiates the data retrieval process.
SH
Sheron
1 year ago
Yes, the missing word is 'select'.
WA
Wayne
1 year ago
from
VI
Vicki
1 year ago
No, the missing word is 'select', not 'count'.
DA
Daniela
1 year ago
count
EL
Ellsworth
1 year ago
That's correct! 'select' is the missing word in the SQL statement.
DA
Dana
1 year ago
select
EV
Evangelina
1 year ago
Hmm, 'select' seems too obvious. Maybe it's something more obscure like 'calculate' or 'enumerate'? I'll give it a shot.
RO
Ronny
1 year ago
I'll go with 'calculate'.
AL
Alisha
1 year ago
I think it might be 'enumerate'.
HY
Hyman
1 year ago
Maybe it's 'calculate'?
LE
Leanna
2 years ago
I think the missing word is 'select'. It's a pretty standard SQL statement to get the count of rows in a table.
ER
Ernie
1 year ago
You got it! 'select' is the missing word.
CA
Carlton
1 year ago
Definitely 'select'. Good job!
KI
King
1 year ago
That's right, it should be 'select'.
BE
Belen
1 year ago
Yes, you're correct. The missing word is 'select'.
CO
Cornell
2 years ago
Yes, 'select' is the missing word because it is used to retrieve data from a database.
MA
Mabelle
2 years ago
I agree with Esteban, it should be 'select'.
ES
Esteban
2 years ago
The missing word is 'select'.