PostgreSQL-Essentials 무료 덤프문제 온라인 액세스

Which PostgreSQL backup utility can create backups in custom compressed format?

• A.psql
• B.pg_basebackup
• C.pg_dump with -Fc option
• D.pg_restore

You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?

• A.-o directory
• B.-D directory
• C.--output directory
• D.-d directory

You want to reload the PostgreSQL configuration without restarting the server. Which function should you execute?

• A.pg_restart_conf()
• B.reload_configuration()
• C.pg_reload_conf()
• D.pg_refresh_conf()

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';

In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED BY DEFAULT AS IDENTITY?

• A.BY DEFAULT prevents manual insertion
• B.They are identical
• C.ALWAYS uses UUID, BY DEFAULT uses serial
• D.ALWAYS prevents manual value insertion, BY DEFAULT allows it