최신EnterpriseDB PostgreSQL Essentials Certification v13 - PostgreSQL-Essentials무료샘플문제
문제1
What is the purpose of the checkpoint_timeout configuration parameter in PostgreSQL?
What is the purpose of the checkpoint_timeout configuration parameter in PostgreSQL?
정답: D
문제2
In PostgreSQL 13, which command is used to switch your connection to a different database in psql?
In PostgreSQL 13, which command is used to switch your connection to a different database in psql?
정답: C
문제3
You need to take a backup of only the edbuser schema from the edbstore database. Which pg_dump option should you use?
You need to take a backup of only the edbuser schema from the edbstore database. Which pg_dump option should you use?
정답: C
문제4
In PostgreSQL, which view provides information about currently running queries?
In PostgreSQL, which view provides information about currently running queries?
정답: A
문제5
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?
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?
정답: D
문제6
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
정답: B
문제7
Which of the following directories store symbolic links for user-defined tablespaces in PostgreSQL?
Which of the following directories store symbolic links for user-defined tablespaces in PostgreSQL?
정답: B
문제8
You want to configure your cluster to run in archive mode for Point-in-Time Recovery. Which parameter must you set in postgresql.conf?
You want to configure your cluster to run in archive mode for Point-in-Time Recovery. Which parameter must you set in postgresql.conf?
정답: A
문제9
You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?
You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?
정답: D