IT認証試験問題集
毎月、GOWUKAKUは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / PostgreSQL Essentials 問題集  / PostgreSQL Essentials 問題練習

EnterpriseDB PostgreSQL Essentials 問題練習

PostgreSQL Essentials Certification v13 試験

最新更新時間: 2026/09/21

【秋学習応援セール｜10月限定キャンペーン】：PostgreSQL Essentials 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35％を節約するには、PostgreSQL Essentials 問題集を使用してください。

 / 2

Question No : 1
In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED BY DEFAULT AS IDENTITY?

正解:

Question No : 2
Which psql meta-command lists all schemas in the current database?

正解:

Question No : 3
You need to reload the PostgreSQL configuration without restarting the server.
Which function should you use?

正解:

Question No : 4
Which command in psql toggles between aligned and unaligned output mode?

正解:

Question No : 5
What is the purpose of shared_buffers configuration parameter in PostgreSQL?

正解:

Question No : 6
In PostgreSQL, which view provides information about currently running queries?

正解:

Question No : 7
Which pg_restore option allows you to drop database objects before recreating them?

正解:

Question No : 8
You want to view all available functions in the current database using psql.
Which command should you use?

正解:

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

正解:

Question No : 10
In PostgreSQL, what does VACUUM do?

正解:

Question No : 11
Which configuration file controls client authentication in PostgreSQL?

正解:

Question No : 12
You want to create a backup of all databases in a PostgreSQL cluster.
Which utility should you use?

正解:

Question No : 13
Which psql command displays the command history?

正解:

Question No : 14
In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?

正解:

Question No : 15
Which of the following commands in psql will execute SQL commands from a file?

正解:

 / 2
EnterpriseDB