NEW
Font size
WorksheetsADBM_Quiz_2_C
Total questions: 10
Worksheet time: 5mins
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
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
