Databases - Upwork

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
Question: How do you alter a column to forbid null values?
A
alter table foo alter bar set not null;

B
alter table foo alter bar avoid null;

C
alter table foo alter bar forbid null;

D
alter table foo alter bar add not null;

E
None of these above

Note: Not available
1. Report
Question: What is the difference between to_tsvector() and ::tsvector ?
A
to_tsvector () normalizes the string while ::tsvector does not

B
to_tsvector () can be used in select statements, while ::tsvector cannot

C
They are equivalent

D
None of these above

Note: Not available
1. Report
Question: What is the storage size of an integer on a 64bit system?
A
8bytes

B
2bytes

C
16bytes

D
4bytes

E
64bytes

Note: Not available
1. Report
Question: Which function should be used to highlight the results?
A
ts_highlight

B
ts_tag

C
ts_headline

D
ts_select

E
None of these above

Note: Not available
1. Report
Question: Which PostgreSQL version added the enum datatype?
A
8.0

B
8.1

C
7.4

D
8.3

E
PostgreSQL doesn't have an enum type.

Note: Not available
1. Report

First Prev 46 47 48 49 50 Next Last

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?

Question: How do you alter a column to forbid null values?

Question: What is the difference between to_tsvector() and ::tsvector ?

Question: What is the storage size of an integer on a 64bit system?

Question: Which function should be used to highlight the results?

Question: Which PostgreSQL version added the enum datatype?