Question No : 1
In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED BY DEFAULT AS IDENTITY?
정답:
Question No : 2
Which psql meta-command lists all schemas in the current database?
정답:
Question No : 3
You need to reload the PostgreSQL configuration without restarting the server.
Which function should you use?
정답:
Question No : 4
Which command in psql toggles between aligned and unaligned output mode?
정답:
Question No : 5
What is the purpose of shared_buffers configuration parameter in PostgreSQL?
정답:
Question No : 6
In PostgreSQL, which view provides information about currently running queries?
정답:
Question No : 7
Which pg_restore option allows you to drop database objects before recreating them?
정답:
Question No : 8
You want to view all available functions in the current database using psql.
Which command should you use?
정답:
Question No : 9
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
정답:
Question No : 10
In PostgreSQL, what does VACUUM do?
정답:
Question No : 11
Which configuration file controls client authentication in PostgreSQL?
정답:
Question No : 12
You want to create a backup of all databases in a PostgreSQL cluster.
Which utility should you use?
정답:
Question No : 13
Which psql command displays the command history?
정답:
Question No : 14
In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?
정답:
Question No : 15
Which of the following commands in psql will execute SQL commands from a file?
정답: