PostgreSQL, Databases

Question: What is the default variable for the PROMPT3?
A
'>>> '

B
'>> '

C
'%/%R%# '

D
'%/%R%# '

Note: Not available
1. Report
Question: What does the following update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10
A
It increases OrderDiscount of the first row by 10%

B
It increases OrderDiscount of all rows by 10%

C
It does nothing without the where clause

D
It generates an error due to the lack of a where clause

Note: Not available
1. Report
Question: Which of the following files controls the host based authentication in PostgreSQL?
A
pg_host_auth.conf

B
pghba.conf

C
pg_hba.conf

D
pghostauth.conf

Note: Not available
1. Report
Question: A PL/pgSQL code block is defined with DECLARE, BEGIN and END. How many such sub blocks can be nested within a block?
A
None

B
2

C
8

D
Unlimited

Note: Not available
1. Report
Question: What is a cluster?
A
A group of users

B
A group of indexes

C
A method of storing tables that are intimately related and often stored together into the same area of the disk

D
A compressed datafile

E
A segment of a partitioned table

F
A group of constraints

G
A group of databases

H
A group of roles

Note: Not available
1. Report
Question: Which of the following security features is inbuilt in PostgreSQL?
A
Stunnel

B
SSL on compiling with -with-ssl

C
SSH/OpenSSH

D
None of these above

Note: Not available
1. Report
Question: Choose the correct statement:
A
All PL/pgSQL expressions in a function, except dynamic queries, are only prepared once during the lifetime of the PostgreSQL backend process

B
All PL/pgSQL expressions in a function are only prepared once during the lifetime of the PostgreSQL backend process

C
All PL/pgSQL expressions in a function are prepared for each execution time during the lifetime of the PostgreSQL backend process

D
None of these above is correct

Note: Not available
1. Report
Question: If entity x is existence-dependent on entity y, then what is x called?
A
Dominant entity

B
Subordinate entity

C
Primary entity

D
Secondary entity

Note: Not available
1. Report
Question: What do you infer from the following two lines? 1. host all 192.168.1.10 255.255.255.255 reject 2. host all 127.0.0.1 255.255.255.255 trust
A
Line 1 is a valid host based client config entry

B
Line 2 is a valid host based client config entry

C
Line 1 and Line 2 both are valid host based client config entries

D
Both Line 1 and Line 2 are invalid host based client config entries

Note: Not available
1. Report
Question: Which of the following statements are true for views?
A
A view is stored in the data dictionary

B
Views provide a more secure way of data retrieval

C
Views are actual tables and store data at another location

D
All of these above are true

Note: Not available
1. Report

First Prev 5 6 7 8 9 Next Last

Question: What is the default variable for the PROMPT3?

Question: What does the following update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10

Question: Which of the following files controls the host based authentication in PostgreSQL?

Question: A PL/pgSQL code block is defined with DECLARE, BEGIN and END. How many such sub blocks can be nested within a block?

Question: What is a cluster?

Question: Which of the following security features is inbuilt in PostgreSQL?

Question: Choose the correct statement:

Question: If entity x is existence-dependent on entity y, then what is x called?

Question: What do you infer from the following two lines? 1. host all 192.168.1.10 255.255.255.255 reject 2. host all 127.0.0.1 255.255.255.255 trust

Question: Which of the following statements are true for views?