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
What is relkind value in pg_class for TOAST object:
T
O
A
S
Which catalog view contains information about each column:
Pg_class
Pg_column
Pg_attribute
Pg_collation
What is the default page size in postgres:
4kB
8kB
64kB
2MB
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
No
Which lock is not conflicting with ROW EXCLUSIVE:
ROW EXCLUSIVE
SHARE
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
No
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
{"name":"PGCONF.EU 2017 #2", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is returned with: SELECT NULL = NULL OR TRUE;","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Powered by: Quiz Maker