What is the main purpose of creating backups in a database system?

• Increase speed

• Prevent data loss

• Reduce data size

• Block replication

Backups help in restoring the system after which of the following events?

• Data export

• UI redesign

• Disk failure

• Normal shutdown

Physical backups copy:

• Only one schema

• Data directory files

• Just table structures

• User roles only

In pg_basebackup, what does -F tar do?

• Fetches tables

• Formats as TAR file

• Finds tables

• Forces full backup

Which of the following includes conditionals and loops?

• SQL

• PLShell

• PL/pgSQL

• JSON

Which type of procedure does not return a value directly?

• Anonymous

• Stored

• Local

• All procedures

Triggers are used to:

• Backup data

• Clean tables

• Automate actions on events

• Compress indexes

To ensure accurate changes, triggers

• Use indexes

• Use pg_restore

• Run silently

• Log and validate data

What is a cursor in SQL?

• Keyboard pointer

• Temporary memory area for rows

• Disk partition

• Data directory

FETCH in a cursor is used to

• Execute a new query

• Retrieve next row

• End cursor
  

• Display all rows