Postgresql Mcqs
Q.1: True or False? To enable continuous archiving, all you have to do is set archive_mode to Y
A. True
B. False
C. No Option
D. No Option
Q.2: True or false: With table inheritance child tables inherit primary and foreign key definitions from their parentsr
A. False
B. True
C. No Option
D. No Option
Q.3: When identifying rows uniquely, we use__________keys.5
A. command
B. standard
C. surrogate
D. unique
Q.4: The __________ database model has the advantage of being able to quickly discover all of the records of one type that are related to a specific record of another type by following the pointers from the starting record.
A. hierarchical
B. structured
C. relational
D. network
Q.5: WAL segment size is determined:
A. It is statically set within the source code.,
B. By the administrator at runtime, or through the startup script.?
C. By the wal_segment_size configuration parameter in postgresql.confB
D. By the configure script at compile time'
Q.6: Which of the following is NOT a feature of user defined functions?B
A. Functions marked IMMUTABLE can have their output indexed8
B. They can be written in various different languages2
C. They can initiate subtransactions!
D. They can return multiple result sets via refcursors3
Q.7: True or False: PostgreSQL allows you to implement table inheritance. This should be defined with the special keyword INHERITIS in the table design.
A. False
B. True
C. No Option
D. No Option
Q.8: To create a database that supports UTF-8, the following command can be used:L
A. createdb -E UTF-8 -O user database_name'
B. createdb -C UTF8 database_name
C. createdb -C UTF8 -O user database_name&
D. createdb -E UTF8 -O user database_name&
Q.9: What is a TOAST file?
A. A file containining transactions which were unsuccessfully completed due to errors.S
B. A list of clients not allowed to connect to the database.9
C. A file containing values too wide to fit comfortably in the main tableF
D. A file storing data that was unable to be written to the database, and will be expunged once the server shuts down.s
Q.10: The extension used for data encryption/decryption within PostgreSQL is:G
A. pgcrypto
B. crypto
C. pgcrypt
D. pgencrypt

Related Mcqs

All Subject Mcqs