PostgreSQL-Essentials問題集、EnterpriseDB実際の試験問題

質問 1

You are connected to a PostgreSQL database. After executing a complex query an error message is displayed.
You want to edit and rerun the previously executed query. Which command can be used to edit the query buffer?

A. e

B. \l

C. \e

D. \r

正解: C

質問 2

What is the purpose of the checkpoint_timeout configuration parameter in PostgreSQL?

A. To define connection timeout

B. To set backup timeout interval

C. To control the maximum time between automatic WAL checkpoints

D. To set the time limit for query execution

正解: C

質問 3

You need to restore only the schema from a custom format backup file. Which pg_restore option should you use?

A. Both B and C

B. --schema-only

C. -s

D. --data-only

正解: A

質問 4

Which psql command displays the command history?

A. \h

B. \log

C. \s

D. \history

正解: C

質問 5

You want to set the effective cache size for indexes to 512MB. Which parameter should you configure?

A. effective_cache_size = 512MB

B. shared_cache = 512MB

C. index_cache = 512MB

D. cache_size = 512MB

正解: A

質問 6

SERIAL and IDENTITY columns can be used to add an auto-incrementing column in a Postgres table. Which of these two column types are SQL standard compliant?

A. Serial

B. Identity

C. None

正解: B

質問 7

Which parameter sets the number of autovacuum worker processes?

A. vacuum_workers

B. autovacuum_workers

C. autovacuum_max_workers

D. max_autovacuum_workers

正解: C

質問 8

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

A. \functions

B. \fn

C. \f

D. \df

正解: D

質問 9

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

A. ALWAYS prevents manual value insertion, BY DEFAULT allows it

B. BY DEFAULT prevents manual insertion

C. ALWAYS uses UUID, BY DEFAULT uses serial

D. They are identical

正解: A

EnterpriseDB PostgreSQL Essentials Certification v13 - PostgreSQL-Essentials 模擬練習