New Year Sale 2026! 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

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
Veta
9 hours ago
I disagree, B is the only one that makes sense here.
upvoted 0 times
...
Denae
6 days ago
Wait, SHOW DATABASE SIZE? Is that even a valid query?
upvoted 0 times
...
Jestine
11 days ago
I think C is missing the right functions.
upvoted 0 times
...
Maybelle
16 days ago
Option B is the way to go. Keeps things simple and readable.
upvoted 0 times
...
Brandee
21 days ago
Haha, option D is just wishful thinking. Gotta love those candidates who try to guess the answer.
upvoted 0 times
...
Willis
26 days ago
SHOW DATABASE SIZE? Really? That's not even a valid PostgreSQL command.
upvoted 0 times
...
Princess
1 month 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
1 month ago
I don't recall seeing SHOW DATABASE SIZE in our practice, so I doubt it's the right choice.
upvoted 0 times
...
Nan
1 month 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
2 months ago
I'm not entirely sure, but I remember something about pg_database_size being used in similar questions.
upvoted 0 times
...
Carlee
2 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
2 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
2 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
2 months ago
Definitely B, it formats the size nicely!
upvoted 0 times
...
Lyndia
2 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
3 months ago
Agreed! It makes the size readable.
upvoted 0 times
...
Ming
3 months ago
A is close, but it doesn't pretty-print the size.
upvoted 0 times
...
Merissa
3 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
3 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
...

Save Cancel