MENU
What SQL command will return a list of all files in a stage?
Suggested Answer: B
Get Premium SOL-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
LIST @stage_name displays all files present in a stage (internal or external).
PUT uploads local files to an internal stage.
GET downloads files from an internal stage.
COPY INTO loads or unloads data but does not list files.
==================
27 comments · newest first
MA
Margart
4 days ago
I feel confident about that too.
BR
Brock
9 days ago
Yeah, LIST makes sense for files.
DO
Dorthy
14 days ago
I think it's B) LIST.
WI
Willodean
19 days ago
LIST is definitely the right choice!
CH
Chana
24 days ago
COPY INTO is for loading data, not listing.
CU
Curtis
30 days ago
PUT seems wrong for this.
LA
Laquanda
1 month ago
I feel confident about that too.
TY
Ty
1 month ago
Yeah, LIST makes sense for files.
LO
Louis
2 months ago
I think it's B) LIST.
AM
Amie
2 months ago
Surprised that people mix this up!
PA
Paulene
2 months ago
Nope, LIST is definitely right.
CA
Carla
2 months ago
Wait, are you sure? I thought it was GET.
TI
Tiera
2 months ago
Totally agree, LIST is the way to go!
SK
Skye
2 months ago
The correct command is B) LIST.
BO
Bong
3 months ago
Surprised that people mix this up!
SH
Shanice
3 months ago
Nope, LIST is definitely right.
AH
Ahmed
3 months ago
Wait, are you sure? I thought it was GET.
AD
Adela
3 months ago
Totally agree, LIST is the way to go!
DU
Dulce
3 months ago
The correct command is B) LIST.
BO
Boris
3 months ago
I’m pretty confident that LIST is the correct answer, but I should double-check my notes just in case.
DA
Darci
4 months ago
I’m confused between LIST and GET. I feel like GET is for downloading files, but I can't recall clearly.
MA
Mayra
4 months ago
I remember practicing a question about file management in SQL, and LIST seemed to be the right choice there too.
HA
Hassie
4 months ago
I think the command to list files in a stage is LIST, but I’m not entirely sure.
DE
Devora
4 months ago
I feel like COPY INTO is related to data loading, so it can't be the right answer here.
AR
Aron
4 months ago
I’m a bit confused; I thought PUT was for uploading files, not listing them.
VE
Venita
4 months ago
I remember practicing a similar question, and I think LIST was the answer.
LE
Lenita
6 months ago
I think the command to list files in a stage is LIST, but I’m not completely sure.