최신EnterpriseDB PostgreSQL Essentials Certification v13 - PostgreSQL-Essentials무료샘플문제
문제1
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?
정답: A
문제2
PostgreSQL supports SQL dump backup. You have configured a nightly backup of a database in plain SQL dump format. Due to database corruption, you need to restore your database using the SQL dump backup.
Which of the following commands can be used to restore a SQL dump?
PostgreSQL supports SQL dump backup. You have configured a nightly backup of a database in plain SQL dump format. Due to database corruption, you need to restore your database using the SQL dump backup.
Which of the following commands can be used to restore a SQL dump?
정답: B
문제3
Which configuration parameter controls the amount of memory allocated for shared buffers?
Which configuration parameter controls the amount of memory allocated for shared buffers?
정답: C
문제4
You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?
You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?
정답: B
문제5
Which psql meta-command is used to display all roles and their attributes?
Which psql meta-command is used to display all roles and their attributes?
정답: C
문제6
Which command in psql toggles between aligned and unaligned output mode?
Which command in psql toggles between aligned and unaligned output mode?
정답: D
문제7
You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?
You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?
정답: C
문제8
You want to take a data-only dump of the edbstore database, disable all triggers for faster restore, and use the INSERT command instead of COPY. Which pg_dump command options should you use?
You want to take a data-only dump of the edbstore database, disable all triggers for faster restore, and use the INSERT command instead of COPY. Which pg_dump command options should you use?
정답: C
문제9
You want to set temporary memory to 8MB. Which parameter should you configure?
You want to set temporary memory to 8MB. Which parameter should you configure?
정답: D