Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

EnterpriseDB PostgreSQL-Essentials Exam - Topic 3 Question 6 Discussion

Which query displays the name and size of all databases in your cluster using a meaningful unit?
B) SELECT datname, pg_size_pretty(pg_database_size(datname)) AS size FROM pg_database;
A) SELECT datname, pg_database_size(datname) FROM pg_database;
C) SELECT name, size FROM pg_database;
D) SHOW DATABASE SIZE;

EnterpriseDB PostgreSQL-Essentials Exam - Topic 3 Question 6 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam
Question #: 6
Topic #: 3
[All PostgreSQL-Essentials Questions]

Which query displays the name and size of all databases in your cluster using a meaningful unit?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Percy at Nov 22, 2025, 02:20 AM

Limited Time Offer

25%

Off

Get Premium PostgreSQL-Essentials Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
An
3 months ago
I feel confident with B. It's precise and informative.
upvoted 0 times
...
Elliot
3 months ago
B gives both name and size clearly.
upvoted 0 times
...
Helaine
4 months ago
D is too vague. It doesn't show names.
upvoted 0 times
...
Anna
4 months ago
Option A is okay, but not user-friendly.
upvoted 0 times
...
Dorian
4 months ago
I think option B is the best choice. It uses pg_size_pretty.
upvoted 0 times
...
Veta
5 months ago
I disagree, B is the only one that makes sense here.
upvoted 0 times
...
Denae
5 months ago
Wait, SHOW DATABASE SIZE? Is that even a valid query?
upvoted 0 times
...
Jestine
5 months ago
I think C is missing the right functions.
upvoted 0 times
...
Maybelle
5 months ago
Option B is the way to go. Keeps things simple and readable.
upvoted 0 times
...
Brandee
5 months ago
Haha, option D is just wishful thinking. Gotta love those candidates who try to guess the answer.
upvoted 0 times
...
Willis
5 months ago
SHOW DATABASE SIZE? Really? That's not even a valid PostgreSQL command.
upvoted 0 times
...
Princess
6 months ago
I like how option B gives the database name and size in a single query. Much easier than having to do the conversion manually.
upvoted 0 times
...
Avery
6 months ago
I don't recall seeing SHOW DATABASE SIZE in our practice, so I doubt it's the right choice.
upvoted 0 times
...
Nan
6 months ago
I feel like A could be close, but it doesn't format the size in a meaningful way like B does.
upvoted 0 times
...
Bernardine
6 months ago
I'm not entirely sure, but I remember something about pg_database_size being used in similar questions.
upvoted 0 times
...
Carlee
6 months ago
Okay, let me see here. I think option A might be the simplest approach, just getting the raw database size values. But B does sound like it would be more useful in the real world. I'll have to weigh the pros and cons.
upvoted 0 times
...
Annita
6 months ago
Easy peasy! Option B is definitely the correct answer. It gives you the database names and sizes in a nice, human-readable format. Can't go wrong with that.
upvoted 0 times
...
Nieves
7 months ago
Option B looks good, it uses the pg_size_pretty function to display the database size in a more readable format.
upvoted 0 times
...
Susana
7 months ago
Definitely B, it formats the size nicely!
upvoted 0 times
...
Lyndia
7 months ago
I think the answer might be B because it uses pg_size_pretty, which makes the size more readable.
upvoted 0 times
...
Freida
7 months ago
Agreed! It makes the size readable.
upvoted 0 times
...
Ming
7 months ago
A is close, but it doesn't pretty-print the size.
upvoted 0 times
...
Merissa
8 months ago
Hmm, I'm a bit unsure about this one. I know we need to get the database names and sizes, but I'm not sure which function to use. I'll have to think this through carefully.
upvoted 0 times
...
Frederick
8 months ago
I think option B is the way to go here. It uses the pg_size_pretty() function to display the database sizes in a more readable format.
upvoted 0 times
Allene
2 months ago
Good point, B really enhances readability!
upvoted 0 times
...
Jestine
3 months ago
Option D seems too simple. B gives more info.
upvoted 0 times
...
Ilene
3 months ago
I was leaning towards A, but B is more user-friendly.
upvoted 0 times
...
Harrison
3 months ago
Yeah, pg_size_pretty() makes it so much clearer!
upvoted 0 times
...
Tesha
3 months ago
I agree, option B is definitely the best choice.
upvoted 0 times
...
...

Save Cancel