Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

PostgreSQL Essentials Certification v13

Last Update 16 hours ago Total Questions : 116

The PostgreSQL Essentials Certification v13 content is now fully updated, with all current exam questions added 16 hours ago. Deciding to include PostgreSQL-Essentials practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our PostgreSQL-Essentials exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these PostgreSQL-Essentials sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any PostgreSQL Essentials Certification v13 practice test comfortably within the allotted time.

Question # 4

Which of the following options can be used to view a Query Plan in pgAdmin4?

A.

Right Click on the database and Click View Query Plan

B.

Right Click on the database and Click Explain button

C.

Open Query Tool, Copy/Paste the query and Click Debug Plan button

D.

Open Query Tool, Copy/Paste the query and press F7

Question # 5

Which psql command displays the command history?

A.

\h

B.

\s

C.

\history

D.

\log

Question # 6

Which command can be used to display all roles and their attributes in PostgreSQL using psql?

A.

\du

B.

\dr

C.

LIST ROLES;

D.

SHOW ROLES;

Question # 7

Which of the following system functions can be used to track the status of the vacuum process?

A.

pg_stat_vacuum

B.

pg_stat_vacuumdb

C.

pg_stat_user_vacuum

D.

pg_stat_progress_vacuum

Question # 8

Which configuration parameter limits the total number of connections available for your database cluster?

A.

log_connection

B.

max_connections

C.

tcp_keepalives_count

D.

superuser_reserved_connection

Question # 9

Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?

A.

work_mem

B.

shared_buffers

C.

maintenance_work_mem

D.

autovacuum_work_mem

Question # 10

You are connected to a database in PostgreSQL using the psql tool. Which of the following commands can be used to view the cluster data directory?

A.

SELECT data_dir FROM pg_settings;

B.

SHOW DIRECTORY;

C.

SELECT server_dir FROM pg_settings;

D.

SHOW DATA_DIRECTORY;

Go to page: