<< Prev Question Next Question >>

Question 6/38

You are writing an initialization script to help your team in creating a new database cluster. You want to ensure that a new database cluster is initialized with md5 as the default authentication method. Which of the following options of the initdb command can be used to specify the default authentication method?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (38q)
Question 1: You want to configure your cluster to run in archive mode fo...
Question 2: What is the purpose of the autovacuum parameter in PostgreSQ...
Question 3: Which PostgreSQL configuration parameter controls the amount...
Question 4: You want to allow up to 200 connected users in your PostgreS...
Question 5: You want to set the maximum time to complete client authenti...
Question 6: You are writing an initialization script to help your team i...
Question 7: Which psql meta-command lists all schemas in the current dat...
Question 8: You want to reload the PostgreSQL configuration without rest...
Question 9: You want to execute SQL commands from a file using psql. Whi...
Question 10: You are working as a Postgres DBA. You want to configure log...
Question 11: While connected to a PostgreSQL database using psql, you wan...
Question 12: Which psql meta-command is used to list all databases in the...
Question 13: Which command displays the current search path in PostgreSQL...
Question 14: Which parameter controls the amount of memory allocated for ...
Question 15: Which system view provides real-time information about curre...
Question 16: Which pg_dump option allows you to dump only the data withou...
Question 17: You want to set the effective cache size for indexes to 512M...
Question 18: You are working as a Postgres DBA. You want to configure log...
Question 19: You want to create a backup of all databases in a PostgreSQL...
Question 20: Which psql command quits the psql interface?...
Question 21: You want to update statistics for the emp and dept tables to...
Question 22: You are connected to a PostgreSQL database. After executing ...
Question 23: SERIAL and IDENTITY columns can be used to add an auto-incre...
Question 24: Which pg_restore option allows you to drop database objects ...
Question 25: Which configuration file controls client authentication in P...
Question 26: You need to reclaim storage occupied by dead tuples in the c...
Question 27: Which configuration parameter limits the total number of con...
Question 28: Which parameter must be set to enable WAL archiving for Poin...
Question 29: Which psql meta-command is used to describe a table includin...
Question 30: Which command rebuilds an index that is performing slowly fo...
Question 31: Which parameter controls the amount of memory allocated for ...
Question 32: Which parameter specifies the number of connections reserved...
Question 33: You want to gracefully terminate a user's connection to the ...
Question 34: You want to view all available functions in the current data...
Question 35: What is the purpose of the checkpoint_timeout configuration ...
Question 36: You need to take a full online base backup of your cluster u...
Question 37: Which parameter sets the number of autovacuum worker process...
Question 38: Which of the following commands in psql will execute SQL com...