Physical backups copy:

• Only one schema

• Data directory files

• Just table structures

• User roles only

What does pg_dumpall always output?

• Binary

• Directory

• Plain SQL

• TAR

A benefit of logical replication is:

• Fastest sync

• Complete environment duplication
  

• Granular control

• Uses fewer WAL files

A trigger runs:

• When called by user

• Automatically on a defined event

• Only after backup

• On schema creation

To ensure accurate changes, triggers:

• Use indexes

• Use pg_restore

• Run silently

• Log and validate data

What clause defines when a trigger fires?

• SELECT

• AFTER/BEFORE
  

• ON LOG
  

• DO NOW
  

What is a cursor in SQL?

• Keyboard pointer

• Temporary memory area for rows

• Disk partition

• Data directory

Which statement shows the loop for cursor?

• WHILE loop

• FOR EACH

• LOOP with FETCH

• WHILE NOT FOUND

To stop fetching from cursor when done:

• CLOSE

• EXIT WHEN NOT FOUND

• BREAK

• END

What clause defines the query behind a cursor?

• WHERE

• FOR

• CURSOR FOR SELECT

• TABLE