Sample Questions of OSS-DB Exam Gold "Advanced Server Administration"

[Advanced Server Administration - Commands for database administration]

1.11

Select all the statements that are accurate regarding the process architecture of PostgreSQL.

  1. A separate server process is spawned for each client connection to the database.

  2. A separate server process is started for each database within the database cluster.

  3. Several processes are running, including the WAL writer, autovacuum launcher, and statistics collector; all are created from the same "postgres" executable.

  4. When no clients are connected, typically only the "postmaster" process is running.

  5. A single "postmaster" process is running for each database cluster.


[Advanced Server Administration - Commands for database administration]

1.10

Choose the one statement that is NOT an accurate description of the data stored in each subdirectory under the database cluster.

  1. The "global" directory contains tables that are shared across the entire database cluster.

  2. The "pg_tblspc" directory contains tables managed by tablespaces.

  3. The "pg_xact" directory contains data related to transaction commit statuses.

  4. The "pg_wal" directory contains WAL files.

  5. The "pg_stat_tmp" directory contains temporary files used by the statistics collector to exchange information with backend processes.


[Advanced Server Administration - Commands for database administration]

1.09

Select all the statements that are correct regarding ANALYZE.

  1. If sorted data is loaded in ascending order, the optimal query plan is created without running ANALYZE.

  2. The autovacuum daemon may perform ANALYZE operations.

  3. Increasing the value of default_statistics_target will reduce the time required for ANALYZE, but may degrade the quality of the planner's estimates.

  4. A SHARE UPDATE EXCLUSIVE lock is acquired on the target table.

  5. The PostgreSQL ANALYZE statement is compliant with the SQL standard.


[Advanced Server Administration - Commands for database administration]

1.08

Select all the statements that are correct regarding VACUUM.

  1.  If the user executing VACUUM does not have the necessary privileges to perform VACUUM on the target table, an error will occur.

  2. VACUUM operations performed within a transaction block can be rolled back using ROLLBACK. 

  3. A standard VACUUM, even without specifying any options, might return unused space to the operating system.

  4. VACUUM ANALYZE should be executed after a significant number of rows have been added or deleted.


[Advanced Server Administration - Commands for database administration]

1.07

Choose two statements that accurately describe the drawbacks of long transactions.

  1. Online backups will no longer be available.

  2. Unused space cannot be recovered by VACUUM.

  3. Connection to the database will be disabled.

  4. New transaction cannot be started.

  5. A table is locked for a long time, and DDL operations on the table cannot be completed.


[Advanced Server Administration - Commands for database administration]

1.06

Select all the statements that are correct regarding VACUUM.

  1. Adding the FULL option reclaims unused space in the entire database.

  2. Adding the VERBOSE option allows you to obtain detailed information about the VACUUM process.

  3. Adding the AUTO option performs VACUUM using the autovacuum settings.

  4. Adding the ANALYZE option also updates statistics.

  5. You can specify multiple tables in a single VACUUM command.


[Advanced Server Administration - Commands for database administration]

1.05

Choose two statements that are NOT accurate descriptions of the pg_basebackup command.

  1. You can obtain a base backup of a PostgreSQL database cluster running on a separate server.

  2. The pg_start_backup command must be executed before the pg_basebackup command is executed.

  3. In the case of fetch method, the max_wal_senders parameter should be set to at least 1.

  4. WAL is included in the backup if the command is executed without explicitly specifying options.

  5. If an additional tablespace is created, the data within the tablespace is not included in the backup.


[Advanced Server Administration - Commands for database administration]

1.04

Choose the one statement that is NOT an accurate description of the CLUSTER command.

  1. The CLUSTER command physically reorganizes the table data and may improve read performance.

  2. Reads on tables for which the CLUSTER command is running will be held back.

  3. The CLUSTER command cannot be executed on a table for which a PRIMARY KEY does not exist.

  4. Increasing the value of maintenance_work_mem may improve the performance of the CLUSTER command.

  5. CLUSTER command may reduce table and index size.


[Advanced Server Administration - Commands for database administration]

1.03

When a log file with the same name exists during log rotation, which of the following settings determines whether to append or to overwrite the file?

  1.  log_min_error_statement

  2. log_rotation_age

  3. log_directory

  4. log_truncate_on_rotation

  5. log_connections


[Advanced Server Administration - Commands for database administration]

1.02

"I want to truncate updated/deleted rows for the ""mytable"" table only.
Which of the following is the correct use of the VACUUM command?"

  1. VACUUM mytable;

  2. VACUUM FULL mytable;

  3. VACUUM VERBOSE mytable;

  4. VACUUM FULL;

  5. VACUUM -f mytable;


[Advanced Server Administration - Setting up database server]

1.01

Which of the following is the correct definition of the crypt function?

  1. Encrypts data by specifying a symmetric key

  2. Calculates a binary hash of the data

  3. Performs password hashing

  4. Computes the hashed MAC of the data

  5. Creates a new random salt string to be used when hashing passwords