Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & Security

PGCONF.EU 2017 #3

What is returned with:
SELECT NULL = NULL;
True
False
NULL
Exception is raised
What is returned with:
SELECT 3 ORDER BY 1 LIMIT 2 OFFSET 1;
No rows
One row with 3
Two rows with 1,2
Exception is raised
What is the default value of default_statistics_target (>= 8.4):
10
100
1000
1000000
What is returned with:
SELECT pg_typeof(relname) from pg_class limit 1;
Text
Varchar
Oid
Name
What is the max size of single file for table chunk:
10MB
1GB
4GB
256GB
What is the default ON COMMIT for temporary tables:
PRESERVE ROWS
DELETE ROWS
DROP
There is no default, you must always specify it
How to cancel trigger operation on current row:
Return empty
Return null
Return void
Break
Which is not query planner setting:
Constraint_exclusion
Cpu_tuple_cost
Enable_sort
Distinct_limit
Which does not end current transaction:
COMMIT;
ROLLBACK;
ABORT;
CANCEL;
Which lock is not conflicting with SHARE ROW EXCLUSIVE:
SHARE UPDATE EXCLUSIVE
ROW SHARE
SHARE ROW EXCLUSIVE
ROW EXCLUSIVE
Which lock is acquired by the DROP TABLE, TRUNCATE, REINDEX, CLUSTER, VACUUM FULL, and REFRESH MATERIALIZED VIEW:
SHARE UPDATE EXCLUSIVE
EXCLUSIVE
ACCESS EXCLUSIVE
ROW EXCLUSIVE
Where you can check about bgwriter statistics:
Pg_stat_database
Pg_stat_bgwriter
Pg_stat_archiver
Pg_stat_replication
Which is not a phase of VACUUM?
Initializing
Scanning heap
Running analyze
Truncating heap
CREATE SERVER:
Creates foreign server
Creates local database
Creates local cluster
Creates foreign cluster
Which is not an auth method in pg_hba.conf file?
Scram-sha-256
Shadow
Md5
Ldap
Which version of PostgreSQL introduces CREATE MATERIALIZED VIEW:
8.2
8.6
9.0
9.3
Which version of PostgreSQL introduces CREATE RECURSIVE VIEW:
8.0
8.4
9.0
9.3
Which you cannot DISCARD?
PLANS
SETTINGS
SEQUENCES
TEMPORARY
Where is stored info about free space inside table structure?
Free Space Map
Visibility Map
In the header of index file
In pg_class
What does CLOSE do?
Closes connection
Closes cursor
This is spatial operator
There is no such command in PostgreSQL
{"name":"PGCONF.EU 2017 #3", "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"}

More Quizzes

How well do you know cats?
1050
How Well Do Y'all Know Me! (Just to clarify me=Juliet for y'all who don't know)
1477
Welcome to Igrane
13626
SKU Mastermind 2
15812
���ა იცით და ვინჩის "საიდუმლო სერობის" შესახებ?
1050
DOT Men's Room - Who said it?
12634
SENIOR SCHOOL (LEXIS AND STRUCTURE 8) (www.tklesson.com)
50250
Тест на эрудицию: если сможете набрать 10/10, то вы умнее 90% людей
1050
Famous engineers
100
Apostolstvo I apostolsko narugivanje
1586
Do you have any recommendations in new papers today?
100
Wekelijkse GamerNL Nieuwsquiz
52216
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker