Select two correct statements from below concerning the ANALYZE command.
psql generated the following error message: psql: could not connect to server: Connection was
refused Is the server running on host "server.example.com" and accepting TCP/IP connections on
port 5432? Select two reasons that are NOT the cause of this error.
Select a correct SQL command to change existing user "george"'s password to "foobar".
Select two suitable statements regarding a postmaster process.
A pg_hba.conf file is set up as follows. local all all md5 host all all 127.0.0.1/32 md5 host all all
172.16.1.0/24 md5 When user foo connects to database bar from host IP address 172.16.1.2, I would
like password verification to not be performed. Select one appropriate line for the new pg_hba.conf
Select two statements that the command below DOES NOT do.
Note: $ is the command prompt. $ pg_dump -b -F c b > d
Select one SQL statement that will cause an error.
Select one incorrect statement from the below about a database cluster.
Select two commands used to check the syntax of the ALTER TABLE statement in psql.
Select two correct statements about the command shown below. Note: $ is the command prompt. $