ADBM_Quiz_2_C

Which of the following is an example of data corruption spreading across replicas?

• Server crash

• Index rebuild

• Wrong update applied to all copies

• Schema mismatch

Logical backups are typically created using:

• pg_basebackup

• filesystem copy

• pg_dump

• tar command

Physical replication is best described as:

• Table-level copy

• Byte-for-byte copy of entire database

• Exporting rows to CSV

• Copying only indexes

What keyword is used to create a procedure?

• MAKE

• SETUP

• CREATE PROCEDURE
  

• RUN PROC

Local procedures in PL/pgSQL are simulated using:

• psql.exe

• Anonymous blocks (DO $$)

• Triggers

• SELECT blocks

What does NEW.salary <> OLD.salary check for?

• Salary increase only

• If salary has changed

• Deletion

• Null values

What clause defines when a trigger fires?

• SELECT

• AFTER/BEFORE

• ON LOG

• DO NOW

What is the first step to using a cursor in PL/pgSQL?

• OPEN

• FETCH

• DECLARE

• PRINT

In PostgreSQL, what does FOUND indicate?

• If a trigger fired

• If a row was affected

• If cursor is running

• If backup is done

To stop fetching from cursor when done:

• CLOSE

• EXIT WHEN NOT FOUND

• BREAK

• END