Databases - Upwork

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
Question: Can deferrable constraints be deferred by a trigger?
A
Yes

B
No

Note: Not available
1. Report
Question: SELECT 'infinity'::timestamp; Will this statement produce an error?
A
Yes

B
No

Note: Not available
1. Report
Question: Does PostgreSQL support SSL?
A
Yes

B
No

Note: Not available
1. Report
Question: PostgreSQL triggers can be written in C directly.
A
True

B
False

Note: Not available
1. Report
Question: A table can have only one primary key column.
A
True

B
False

Note: Not available
1. Report

First Prev 44 45 46 47 48 Next Last

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?

Question: Can deferrable constraints be deferred by a trigger?

Question: SELECT 'infinity'::timestamp; Will this statement produce an error?

Question: Does PostgreSQL support SSL?

Question: PostgreSQL triggers can be written in C directly.

Question: A table can have only one primary key column.