IT認証試験問題集
GOWUKAKU｜IT認定資格の試験問題集（PDF版）およびオンライン模擬練習を提供しています
 ホームページ / PostgreSQL Essentials 問題集  / PostgreSQL Essentials 問題練習

EnterpriseDB PostgreSQL Essentials 問題練習

PostgreSQL Essentials Certification v13 試験

最新更新時間: 2026/10/11

【仕様案内】：PostgreSQL Essentials 問題集（PDF版）には、日本語版と英語版の2言語セットが含まれています。

問題集のサンプル問題を練習し、出題範囲のポイントと現在の理解度を確認することができます。

全71問を収録したPDF版は、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