問題1
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?
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?
正確答案: B
問題2
Which PostgreSQL backup utility can create backups in custom compressed format?
Which PostgreSQL backup utility can create backups in custom compressed format?
正確答案: A
問題3
Which command reclaims all obsolete row space and compacts the customers table for reuse?
Which command reclaims all obsolete row space and compacts the customers table for reuse?
正確答案: A
問題4
In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?
In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?
正確答案: C
問題5
Which parameter specifies the number of connections reserved for superusers in PostgreSQL?
Which parameter specifies the number of connections reserved for superusers in PostgreSQL?
正確答案: D
問題6
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?
正確答案: A
問題7
You want to execute SQL commands from a file using psql. Which command should you use?
You want to execute SQL commands from a file using psql. Which command should you use?
正確答案: A
問題8
You have created a database user named edbuser with password 'password'. Which command grants connection rights to the edbstore database for user edbuser?
You have created a database user named edbuser with password 'password'. Which command grants connection rights to the edbstore database for user edbuser?
正確答案: A
問題9
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