Sample Questions of OSS-DB Exam Silver "Operation and Management"

[Operation and Management - How to use standard attached tool]

1.20

As an explanation of createuser command, choose two things that are wrong.

  1. Behavior when database creation authority is not specified by option, behavior changed in PostgreSQL 9.2, new creation authority is not granted by default by default.
  2. It must be executed as the database administrator user.
  3. You can create a user in a database on a server other than the machine on which the createuser command is executed.
  4. It is possible to create new users as well as users of databases.
  5. The same thing can be realized by connecting to the database with psql and then using the CREATE ROLE command.

[Operation and Management - configuration file (postgresql.conf)]

1.19

Regarding postgresql.conf, choose the most appropriate description.

  1. After modifying the file, many parameters are reflected by execution of pg_ctl reload, but some of the parameters are effective immediately by file modification.
  2. Multiple parameters can be set on a single line by separating them with a semicolon (;).
  3. When you end the line with a backslash (\), it becomes a continuation line, and parameters can be set across multiple lines.
  4. You can place # at the beginning of a line to make that line a comment line, or you can put # in the middle of a line and make a description on the right side of it as a comment.
  5. By executing ALTER SYSTEM, the contents are rewritten.

[Operation and Management - configuration file (pg_hba.conf)]

1.18

The user test 1 on the client dbclient (192.168.1.12) connects to the database running on the host dbserver (192.168.1.11) using psql. Given the contents of pg_hba.conf as follows, choose two appropriate answer from the following description.

local all all peer
host test all 192.168.1.12/32 trust
host all all 192.168.1.0/24 md5

  1. When connecting with the user named test 1 to the database named test 1, it is authenticated without a password. 
  2. When connecting with the user named test 1 to the database named test1, it is authenticated without a password.

  3. When connecting with the user named test to the database named test 1, it is authenticated with the password.
  4. When connecting with the user named test to the database named test, it is authenticated with a password. 
  5. When connecting with the user named test 1 to the database named test 2, the connection is rejected. 

[Operation and Management - backup method (how to use various backup commands)]

1.17

Choose two correct explanations for the next command. pg_dump - s - U abc - f def ghi

  1. Connect to the database with super user abc. 
  2. Data in the database is not dumped. 
  3. Dump is output to standard output. 
  4. Table def is dumped.
  5. Connect to database ghi.

[Operation and Management - Backup Method (File System Level Backup and Restore)]

1.16

I want to create a backup by physically copying the file system that constitutes the database. Choose the most appropriate description.

  1. Database files are upward compatible, so you can restore files copied in PostgreSQL 9.1 environment to PostgreSQL 9.2 environment. 
  2. For example, if the name of the physical file that makes up the table called test is 10001, you can use the same table by copying this file to another database environment. 
  3. Compared with the logical backup acquired by pg_dump, backup by file system copy is generally fast. 
  4.  Compared with the logical backup acquired by pg_dump, backup by file system copy is generally smaller in size. 
  5. When acquiring a backup, the database can be kept running. 


[Operation and Management - Backup Method (Point-in-Time Recovery (PITR) Concept and Procedure)]

1.15

In the context of point-in-time recovery, choose the incorrect option.

  1. Configure postgresql.conf so that the WAL file is archived. 
  2. Use the pg_dump command to generate a base backup. 
  3. Restore the base backup for server recovery.
  4. Set recovery.conf so that the archived WAL file can be applied, and restart the server. 
  5. When the server is restored, change the file name of recovery.conf to recovery.done etc. 

[Operation and Management - How to use the backup method (COPY statement (SQL), copy command (psql))]

1.14

Choose two appropriate SQL commands to output the contents of table foo to standard output with comma separated values. It should be noted that processing of special characters and the like need not be considered.

  1. copy from foo to stdout (format csv); 
  2. copy foo to stdout (delimiter ','); 
  3. copy stdout from foo format = 'csv';
  4. copy foo to stdout (format csv);
  5. copy from foo to stdout (delimiter = 'csv'); 

[Operation and Management - Basic operation management task (method of adding, deleting, changing database user)]

1.13

Choose two appropriate methods to add a user ‘foo’ with authority to create a database. In the following options, $ is the command prompt of the OS, => is the command prompt of psql, and the user executing the command is given the necessary authority.

  1. $ createuser -c foo
  2. $ createuser -d foo
  3. $ createuser -D foo
  4. => create user foo with db;
  5. => create user foo createdb;

[Operation and Management - basic operation management task (VACUUM, purpose and usage of ANALYZE)]

1.12

Choose two statements that accurately describe the ANALYZE function.

  1. Obtains statistical information such as the frequency with which the table is accessed and the frequency with which it is updated. 
  2. ANALYZE of a huge table takes time because the whole table is analyzed by default. 
  3. With run-time parameters you can control the target of ANALYZE, such as the entire database, only certain tables in the database, only certain columns of a particular table.
  4. Since the target value of statistical information acquisition can be changed by parameters at the time of execution, it is possible to control the accuracy of statistical information and the time needed for ANALYZE. 
  5. It is executed automatically when automatic vacuum is executed.

[Operation and Management - basic operation management work (concept and action of automatic vacuum)]

1.11

Choose two accurate statements about automatic vacuum.

  1. Vacuum is automatically executed at regular intervals.
  2. Vacuum is automatically executed when the system load is low.
  3. Vacuuming is automatically performed on the table where a large amount of data was inserted, updated, or deleted. 
  4. Vacuuming is executed automatically to avoid looping transaction ID.
  5. Since the timing at which the vacuum is executed can not be predicted, it is not executed by default.

[Operation and Management - Basic operation management task (system information function)]

1.10

An error occurs when the following statement is executed from psql trying to get the name of user who is currently executing the session.
SELECT current_user ();

What is the cause of the error?

  1. You must use session_user (), not current_user ().
  2. You must use user () instead of current_user ().
  3. Make the function an argument and call it SELECT current_user (*);
  4. Parentheses are not required, we have to call SELECT current_user;
  5. Since the command itself is correct, it is safe to assume that an abnormality has occurred in the server

[Operation and Management - Basic Operation Management Work (Information Schema and System Catalog)]

1.09

Choose the correct description for the system catalog which stores information about tables and columns in the database.

  1. The table information is stored in pg_tables, and the column information is stored in pg_columns.
  2. The table information is stored in pg_relations, and the column information is stored in pg_relcolumns.
  3. The table information is stored in pg_class, and the column information is stored in pg_attribute. 
  4. Table information is stored in pg_table_info, and column information is stored in pg_table_columns.
  5. The table information is stored in pg_rel_info, and the column information is stored in pg_col_info.

[Operation and Management - Basic operation management work (authority on table basis, GRANT / REVOKE)]

1.08

Please choose one that is wrong about the authority that you can allocate by the GRANT statement.

  1. Permission to search (SELECT) rows of a table
  2. The right to update (UPDATE) certain columns of the table
  3. Permission to delete (DELETE) all rows of a table
  4. Permission to delete (DROP) a table
  5. Permission to grant (GRANT) authority on tables to other users

[Operation and Management - Installation method
(How to use initdb command)]

1.07

Choose three correct statements regarding the
initdb command.

  1. It should be run as root user on Linux /UNIX.
  2. If the database cluster exists in the specified directory, it will be initialized,  so extra care is required when being executed.
  3. You can specify the default character set of the database.
  4. You can specify the default locale for the database.
  5. The password of the superuser for the database can be set.

[Operation and Management - Installation Method
(Concept and Structure of Database Cluster)]

1.06

Choose two appropriate statements about the
PostgreSQL database cluster.

  1. By default, there are two databases, template0 and postgres.
  2. By default, there are two databases, template 0 and template 1.
  3. By default, there are three databases, template 0, template 1, and postgres.
  4. Database template 0 can not be deleted.
  5. Database postgres can not be deleted. 

[Operation and Management - Installation Method
(Template Database)]

1.05

Choose one that is incorrect about database
templates.

  1. When you run CREATE DATABASE, internally one of the template databases is copied.
  2. If you do not specify a template database to use, template1 is used by default.
  3. By default, there are two template databases in the database cluster.

  4. Up to 5 template databases can be created in the database cluster.

  5. There is a flag to set whether the database is a template database, and you can not delete (DROP DATABASE) the database where the flag is set. 

     

[Operation and Management - installation method
(how to use database management command)]

1.04

Choose three correct statements about the pg_ctl
command.

  1. To create a new database cluster, execute pg_ctl initdb.
  2. Execute pg_ctl shutdown to stop the database.
  3. To restart the database, execute pg_ctl restart.
  4. Use the -D option to specify the name of the database to be started or stopped.
  5. Use the -m option to specify how to handle sessions during database connection when stopping. 

[Operation and Management - Configuration files
- How to use standard attached tool
(How to use database management command)]

1.03

Choose two correct statements regarding the
creation of new users utilizing the createuser
command.

  1. The createuser command must be run with the same user account as the user running the database server process.
  2. The createuser command must be executed with a user account on the same server on which the server process of the database is running.
  3. The createuser command must be run with a user account that has a CREATEROLE privilege on the database.
  4. The user name to be newly created must be the same as the user account name existing on the OS.
  5. The newly created user name can be determined regardless of the user account name on the OS.

[Operation and Management - Configuration files
- installation method (how to use database
management command)]

1.02

Information about the ALTER TABLE statement can
be found from the psql command-Prompt using
which of the following?

  1. man alter table
  2. howto alter table
  3. describe alter table

  4. help alter table


[Operation and Management - Configuration files -
error reporting and log acquisition]

1.01

Which two of the following are correct explanations of the parameters configured in postgresql.conf?

  1. log_destination specifies the file name to which the log will be output.
  2. When logging_collector is set to on, standard error log messages can be redirected to a log file.
  3. When log_connections is set to on, connection attempts from the client to server are recorded in the log.

  4. When log_statement is set to on, SQL statements are recorded to the log.

  5. When log_line_prefix is set to on, various additional information, such as log information output time, username, and process ID are included in the log file.

LPI-Japan
Platinum Sponsors