PostgreSQL RDBMS, Databases

Question: While creating a trigger, the function it will call may be created after it and attached to it.
A
True

B
False

Note: Not available
1. Report
Question: On a UNIX system, what is the best way to prevent all non-local connections to the postmaster?
A
Using ipfilte

B
Using UNIX sockets

C
Using TCP port 0

D
Using an empty pg_hba.conf

E
None of these above

Note: Not available
1. Report
Question: After a PostgreSQL installation, how will you create the database cluster?
A
With created

B
With initd

C
With createdbs

D
With postmaste

E
None of these above

Note: Not available
1. Report
Question: How will you change the TCP port which PostgreSQL will listen to?
A
PostgreSQL does not support TCP

B
By changing "port" in postgresql.conf

C
By issuing UPDATE config SET port = <newvalue

D
TCP port cannot be changed

E
None of these above

Note: Not available
1. Report
Question: Which of the following queries will create a table with two fields, "id" and "name" with "id" as an auto incrementing primary key?
A
create table foo (id int serial primary key auto, name varchar(255));

B
create table foo (id int auto_increment primary key, name varchar(255));

C
create table foo (id auto_increment primary key, name varchar(255));

D
create table foo (id serial primary key, name varchar(255));

E
None of these above

Note: Not available
1. Report
Question: How will you list the available functions from psql?
A
select * from pg_functions;

B
\df

C
\? functions

D
select * from pg_procedures;

E
None of these above

Note: Not available
1. Report
Question: Consider the following query: Create table foo (bar varchar); What will be the size limit of the bar?
A
256

B
1024

C
1

D
No limit (It will be equivalent to the text)

E
None of these above

Note: Not available
1. Report
Question: What is the well known port number for the postgresql database service?
A
5000

B
541

C
5432

D
63

E
None of these above

Note: Not available
1. Report
Question: What is true regarding file system backup?
A
It can only be used to backup the whole database

B
The database must be running for the backup to take place

C
To restore a file system backup, pg_restore should be used

D
None of these above

E
All of these above

Note: Not available
1. Report
Question: Which one of the following text search functions does not exist?
A
to_tsvecto

B
plainto_tsquery

C
to_tsquery

D
strip

E
ts_rewrite

F
plainto_tsvecto

Note: Not available
1. Report

First Prev 1 2 3 4 5 Next Last

Question: While creating a trigger, the function it will call may be created after it and attached to it.

Question: On a UNIX system, what is the best way to prevent all non-local connections to the postmaster?

Question: After a PostgreSQL installation, how will you create the database cluster?

Question: How will you change the TCP port which PostgreSQL will listen to?

Question: Which of the following queries will create a table with two fields, "id" and "name" with "id" as an auto incrementing primary key?

Question: How will you list the available functions from psql?

Question: Consider the following query: Create table foo (bar varchar); What will be the size limit of the bar?

Question: What is the well known port number for the postgresql database service?

Question: What is true regarding file system backup?

Question: Which one of the following text search functions does not exist?