QUESTION: 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();

It is defining a trigger "trigger_1".
Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
The "write_log" function is called before 'UPDATE' takes place.
'UPDATE' is not executed if "write_log" returns NULL.
'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.

Answer(s): A,E

Reveal Solution Next Question

QUESTION: 2

Select two transaction isolation levels supported in PostgreSQL.

DIRTY READ
READ COMMITTED
REPEATABLE READ
PHANTOM READ
SERIALIZABLE

Answer(s): B,E

Reveal Solution Next Question

QUESTION: 3

PostgreSQL can use an index to access a table. Select two incorrect statements about indexes.

An index is created by 'CREATE INDEX', and deleted by 'DROP INDEX'.
By using an index effectively, searching and sorting performs faster.
There are B-tree, Hash, R-tree and GiST index types.
By creating an index, performance always improves.
Creating an unused index does not affect the performance of a database at all.

Answer(s): D,E

Reveal Solution Next Question

QUESTION: 4

Select two incorrect statements regarding 'DOMAIN'.

When defining a domain, you can add a default value and constraints to the original data.
Domain is a namespace existing between databases and objects such as tables.
A domain is created by 'CREATE DOMAIN'.
A domain can be used as a column type when defining a table.
To define a domain, both input and output functions are required.

Answer(s): B,E

Reveal Solution Next Question

Free PGCES-02 Exam Braindumps (page: 1)

Pass your PGCES-02 PostgreSQL CE 8 Silver exam with these free Actual Questions and Answers

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4