PostgreSQL function, trigger và PL/pgSQL

Nội dung luyện tập

• strict null skips body
• perform discard and found
• into no row clears target
• before row modifies new
• into strict rejects multiple
• execute status not found
• exception variable versus database rollback
• return next does not exit
• foreach slice row arrays
• update of is mentioned column
• same kind trigger name order
• statement trigger zero affected rows
• transition table whole statement
• replace cannot change return type
• variable column ambiguity
• others does not catch cancellation
• definer execute publication window
• procedure commit caller transaction
• string body dependency not fully tracked
• set returning function buffering

Mỗi câu đúng 1 điểm. Mục tiêu 70%. Đáp án và giải thích mở sau khi nộp bài.