PGCONF.EU 2017 #2

What is returned with:
SELECT NULL = NULL AND TRUE;

True

False

NULL

Exception is raised

What is returned with:
SELECT 2 ORDER BY 0 LIMIT 2;

No rows

One row with 3

Two rows with 1,2

Exception is raised

Which catalog view contains information about each column:

Pg_class

Pg_column

Pg_attribute

Pg_collation

To copy the structure of the table with all indexes and constraints you invoke:

Create table copy_table as select * from original_table where false;

Copy copy_table from original_table with indexes, constraints;

Create table copy_table inherits original_table;

Create table copy_table (like original_table including all);

Which trigger is best to archive old records:

Before update

Before insert

After update

After insert

Which is true:

Table can be in multiple tablespaces

Tablespace can be in multiple clusters

Only superuser can own a tablespace

You can set random_page_cost to each tablespace separately

Which does not reload PostgreSQL config without restart:

Sudo systemctl reload postgresql

SELECT pg_reload_conf();

/usr/bin/pg_ctl reload

RELOAD;

Is there any way to get rid of safepoint?

Yes, DROP SAVEPOINT

Yes, DELETE SAVEPOINT

Yes, RELEASE SAVEPOINT

Which lock is not conflicting with ROW EXCLUSIVE:

ROW EXCLUSIVE

SHARE ROW EXCLUSIVE

EXCLUSIVE

Where you can check about query cancels due to conflict with recovery on standby servers:

Pg_stat_database_conflicts

Pg_stat_database

Pg_stat_archiver

Pg_stat_replication

Is there cascade replication in PostgreSQL?

Yes

Yes, only for streaming replication

Yes, only for logical replication

Which is not a parameter of ANALYZE:

VERBOSE

FULL

Table_name

Column_name

Which is not an auth method in pg_hba.conf file?

Reject

Peer

Allow

Cert

Which version of PostgreSQL introduces CREATE INDEX CONCURRENTLY:

9.0

9.4

9.6

8.2

If you create trigger which is incorrect specify of when?

BEFORE

AFTER

INSTEAD OF

ASYNC

To which you cannot grant privilege:

SELECT

ALTER

TRUNCATE

CONNECT

Where is stored info about free space inside index structure?

Free Space Map

Visibility Map

In the header of index file

In pg_class

Which is not a vacuum setting?

Vacuum_cost_delay

Vacuum_cost_nap

Vacuum_cost_page_dirty

Vacuum_cost_limit

PGCONF.EU 2017 #2

More Quizzes