IT認証試験問題集
GOWUKAKU｜IT認定資格の最新の試験問題集（PDF版・無料サンプル問題）を提供しています
 ホームページ / EnterpriseDB 問題集 / PostgreSQL Essentials 問題集  / PostgreSQL Essentials 問題練習

EnterpriseDB PostgreSQL Essentials 問題練習

PostgreSQL Essentials Certification v13 試験

最終更新日: 2026/10/12　 収録内容確認済　｜　PDF問題集: 全 71 問収録

【仕様案内】：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