ADBM_Quiz_2_Section_A

pg_dump outputs in which formats?

• JSON

• XML

• Custom, Plain SQL, Tar, Directory

• Only plain text

What does replication in PostgreSQL allow?

• Backing up indexes only

• Rebuilding schemas

• Syncing data between servers

• Compressing large tables

A benefit of logical replication is:

• Fastest sync

• Complete environment duplication

• Granular control

• Uses fewer WAL files

Which type of procedure does not return a value directly?

• Anonymous

• Stored

• Local

• All procedures

Which section of a procedure handles runtime errors?

• Execution

• Logging

• Exception

• Output

FETCH in a cursor is used to

• Execute a new query

• Retrieve next row

• End cursor

• Display all rows

Implicit cursors are:

• Created manually

• Always visible

• Automatic

• Unsupported

How are individual rows accessed with a cursor?

• FETCH INTO record

• SELECT all
  

• DUMP file

• JOIN indexes

To stop fetching from cursor when done:

• CLOSE

• EXIT WHEN NOT FOUND

• BREAK

• END

Triggers are used to:

• Backup data

• Clean tables

• Automate actions on events

• Compress indexes