PostgreSQL RDBMS, Databases

Question: Which authentication methods are supported by PostgreSQL?
A
Trust

B
PAM

C
LDAP

D
Radius

E
Password

Note: Not available
1. Report
Question: Which index types are supported by PostgreSQL?
A
A-tree

B
B-tree

C
GiST

D
Hash

E
GIN

F
None of these above

Note: Not available
1. Report
Question: Out of the following backup approaches, which ones are applicable to PostgreSQL?
A
SQL dump

B
File system level backup

C
Real cluste

D
Continuous archiving

E
None of these above

Note: Not available
1. Report
Question: In the following operation, which ones can trigger a trigger?
A
alte

B
insert

C
drop

D
update

E
delete

Note: Not available
1. Report
Question: Which index types support multicolumn indexes?
A
B-tree

B
GiST

C
GIN

D
Hash

E
None of these above

Note: Not available
1. Report
Question: What kind of triggers are offered by PostgreSQL?
A
Per-row triggers

B
Per-table triggers

C
Per-database triggers

D
Per-statement triggers

Note: Not available
1. Report
Question: Which of the following statements will cast the integer value 1 to type text?
A
SELECT text(1) AS cast_integer;

B
SELECT CAST(1, text) as cast_integer;

C
SELECT 1::text AS cast_integer;

D
SELECT 1 TO text AS cast_integer;

E
SELECT CAST(1 AS text) AS cast_integer;

Note: Not available
1. Report
Question: How can you configure PostgreSQL autovacuum?
A
With the ALTER autovacuum policy; query in psql

B
By editing pg_hba.conf

C
By editing postgresql.conf

D
By running the autovacuum command line tool

E
None of these above

Note: Not available
1. Report
Question: What library is used by PostgreSQL for encryption?
A
GnuTLS

B
OpenSSL

C
OpenLDAP

D
OpenTLS

E
None of these above

Note: Not available
1. Report
Question: Are the contents of the pg_autovacuum system catalog saved when pg_dumpall is used to backup the database?
A
Yes

B
No

Note: Not available
1. Report

First Prev 1 2 3 Next Last

Question: Which authentication methods are supported by PostgreSQL?

Question: Which index types are supported by PostgreSQL?

Question: Out of the following backup approaches, which ones are applicable to PostgreSQL?

Question: In the following operation, which ones can trigger a trigger?

Question: Which index types support multicolumn indexes?

Question: What kind of triggers are offered by PostgreSQL?

Question: Which of the following statements will cast the integer value 1 to type text?

Question: How can you configure PostgreSQL autovacuum?

Question: What library is used by PostgreSQL for encryption?

Question: Are the contents of the pg_autovacuum system catalog saved when pg_dumpall is used to backup the database?