PostgreSQL-Essentials試験無料問題集（90題）「EnterpriseDB PostgreSQL Essentials Certification v13 認定」

出題：1

You need to determine the names and definitions of all views in the edbuser schema. Which query should you use?

A. SELECT * FROM pg_views WHERE schemaname='edbuser';

B. SELECT * FROM pg_views;

C. Both B and C

D. SELECT * FROM information_schema.views WHERE table_schema='edbuser';

正解：C 解答を投票する

出題：2

You want to create a backup of all databases in a PostgreSQL cluster. Which utility should you use?

A. pg_backup

B. pg_dump

C. pg_dumpall

D. pg_clusterbackup

正解：C 解答を投票する

出題：3

You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?

A. REINDEX emp, dept;

B. ANALYZE emp; ANALYZE dept;

C. VACUUM emp, dept;

D. UPDATE STATISTICS emp, dept;

正解：B 解答を投票する

出題：4

Which configuration file controls client authentication in PostgreSQL?

A. pg_hba.conf

B. auth.conf

C. pg_ident.conf

D. postgresql.conf

正解：A 解答を投票する

出題：5

Which query displays the name and size of all databases in your cluster using a meaningful unit?

A. SHOW DATABASE SIZE;

B. SELECT datname, pg_database_size(datname) FROM pg_database;

C. SELECT name, size FROM pg_database;

D. SELECT datname, pg_size_pretty(pg_database_size(datname)) AS size FROM pg_database;

正解：D 解答を投票する

出題：6

Which command rebuilds an index that is performing slowly for better performance?

A. REINDEX INDEX indexname;

B. VACUUM INDEX indexname;

C. REBUILD INDEX indexname;

D. ANALYZE INDEX indexname;

正解：A 解答を投票する

出題：7

You want to export query results to a CSV file from psql. Which command should you use?

A. EXPORT TO 'filename.csv'

B. \export filename.csv

C. SAVE AS 'filename.csv'

D. \copy tablename TO 'filename.csv' CSV

正解：D 解答を投票する

出題：8

Which command displays the current search path in PostgreSQL?

A. GET search_path;

B. SELECT search_path;

C. SHOW search_path;

D. \path

正解：C 解答を投票する

出題：9

You want to set temporary memory to 8MB. Which parameter should you configure?

A. temp_memory = 8MB

B. temporary_memory = 8MB

C. work_mem = 8MB

D. temp_buffers = 8MB

正解：D 解答を投票する

PostgreSQL-Essentials試験無料問題集「EnterpriseDB PostgreSQL Essentials Certification v13 認定」