PostgreSQL-Essentials無料問題集「EnterpriseDB PostgreSQL Essentials Certification v13」

質問 1

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

（A）pg_stat_vacuumdb

（B）pg_stat_progress_vacuum

（C）pg_stat_vacuum

（D）pg_stat_user_vacuum

正解：B 解答を投票する

質問 2

Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?

（A）pg_dumpall

（B）pg_backup

（C）pg_clusterbackup

（D）pg_dump

正解：A 解答を投票する

質問 3

Which psql meta-command is used to describe a table including its structure, columns, and constraints?

（A）\describe tablename

（B）\dt tablename

（C）\show tablename

（D）\d tablename

正解：D 解答を投票する

質問 4

In PostgreSQL 13, which command is used to switch your connection to a different database in psql?

（A）SET DATABASE dbname;

（B）SWITCH dbname;

（C）\connect dbname

（D）USE dbname;

正解：C 解答を投票する

質問 5

Which psql meta-command is used to display all roles and their attributes?

（A）\users

（B）\dr

（C）\roles

（D）\du

正解：D 解答を投票する

質問 6

What is the purpose of shared_buffers configuration parameter in PostgreSQL?

（A）To control WAL buffer size

（B）To set connection pool size

（C）To determine memory for caching data from disk

（D）To set the amount of memory for sorting

正解：C 解答を投票する

質問 7

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

（A）They are identical

（B）BY DEFAULT prevents manual insertion

（C）ALWAYS uses UUID, BY DEFAULT uses serial

（D）ALWAYS prevents manual value insertion, BY DEFAULT allows it

正解：D 解答を投票する

質問 8

Which parameter specifies the number of connection slots reserved for superusers?

（A）superuser_connections

（B）reserved_connections

（C）superuser_reserved_connections

（D）admin_connections

正解：C 解答を投票する

質問 9

In PostgreSQL, archiving can be enabled for hot backups. During recovery, all the archive logs can be played on the restored backup and Point-in-Time Recovery can be performed. Which of the following parameters directly influences Mean Time to Recovery and is also used to control the size of the WAL area?

（A）wal_size

（B）checkpoint_timeout

（C）wal_level

（D）max_wal_size

正解：D 解答を投票する

PostgreSQL-Essentials 無料問題集「EnterpriseDB PostgreSQL Essentials Certification v13」

弊社を連絡する

関連リンク

トップ試験