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

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 information_schema.views WHERE table_schema='edbuser';
• C.SELECT * FROM pg_views;
• D.Both B and C

You want to view all available functions in the current database using psql. Which command should you use?

• A.\functions
• B.\fn
• C.\f
• D.\df

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

• A.temporary_memory = 8MB
• B.temp_buffers = 8MB
• C.temp_memory = 8MB
• D.work_mem = 8MB

Autocommit occurs in which of the following situations?

• A.All DML statements
• B.None of the above
• C.All DDL statements
• D.On DML and DDL statements

In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?

• A.backup_mode must be set to archive
• B.archive_level must be set to full
• C.wal_archiving must be set to on
• D.wal_level must be set to replica or higher