S
PostgreSQL PGCES-02 Practice Questions
Prepare PostgreSQL PGCES-02 Exam Questions
Question No 1:
Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();
A. It is defining a trigger "trigger_1".
B. Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
C. The "write_log" function is called before 'UPDATE' takes place.
D. 'UPDATE' is not executed if "write_log" returns NULL.
E. 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.
Answer: A, E
See More Questions
Question No 1:
Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();
A. It is defining a trigger "trigger_1".
B. Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
C. The "write_log" function is called before 'UPDATE' takes place.
D. 'UPDATE' is not executed if "write_log" returns NULL.
E. 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.
Answer: A, E
See More Questions
Information About PostgreSQL PGCES-02 Exam
Vender: PostgreSQL
Exam Code: PGCES-02
Exam Name: PostgreSQL CE 8 Silver
Number Of Questions: 142
Certification Name: PostgreSQL Certified Engineer
Exam Language: English
Questions Type: MCQs
Material Format: PDF & Web Practice Test Software