PostgreSQL, Databases

Question: Which of the following are supported by PostgreSQL?
A
Multi version concurrency control transactions

B
Multi-user support

C
Declarative SQL queries

D
Query optimization

Note: Not available
1. Report
Question: Point out the incorrect statement regarding group functions:
A
Group functions act on a group of rows

B
Group functions return one result for all the rows operated upon

C
Group functions ignore the null values

D
Stddev and variance are examples of group functions

E
One cannot combine group and single value functions in a query

F
Sum is not a group function

Note: Not available
1. Report
Question: Which of the following date function(s) are invalid?
A
NEXT_DAY

B
NEXT_MONTH

C
MONTHS_BETWEEN

D
DAYS_BETWEEN

Note: Not available
1. Report
Question: Which of the following functionalities is supported by the pg_ctl script?
A
status

B
start

C
stop

D
restart

E
invoke

F
all of these above

Note: Not available
1. Report
Question: In which of the following ways can a value in an array column be modified?
A
Element modification

B
Columnar modification

C
Slice modification

D
Complete modification

Note: Not available
1. Report
Question: Which of the following are valid in a declare block?
A
intCustomerId int4 := 67;

B
intCustomerId int4 = 67;

C
intCustomerId int4;

D
intCustomerId int4; intCustomerId:= 67

Note: Not available
1. Report
Question: For which of the following languages does PostgreSQL provide an API interface?
A
Python and Perl

B
C/C++ and Java

C
PHP and Ruby

D
Small talk

Note: Not available
1. Report
Question: Data validation can be implemented at the definition stage through:
A
Check constraints with specified values

B
Referential constraints, by creating a foreign key for another table

C
Default value of a column

D
Null constraints

Note: Not available
1. Report
Question: Which of the following statements is not correct about creating a new operator?
A
Name and functionname clause must be specified

B
LEFTARG or RIGHTARG must be defined

C
Overloading is not possible in operators

D
COMMUTATOR attribute must be specified

Note: Not available
1. Report
Question: Examine the following query: Create table Person (EmpNo Number(4) not null, EName Char not null, Join_dt Date not null, Pay Number) Which of the following field(s) are created correctly?
A
EmpNo

B
EName

C
Join_dt

D
Pay

Note: Not available
1. Report

First Prev 1 2 3 Next Last

Question: Which of the following are supported by PostgreSQL?

Question: Point out the incorrect statement regarding group functions:

Question: Which of the following date function(s) are invalid?

Question: Which of the following functionalities is supported by the pg_ctl script?

Question: In which of the following ways can a value in an array column be modified?

Question: Which of the following are valid in a declare block?

Question: For which of the following languages does PostgreSQL provide an API interface?

Question: Data validation can be implemented at the definition stage through:

Question: Which of the following statements is not correct about creating a new operator?

Question: Examine the following query: Create table Person (EmpNo Number(4) not null, EName Char not null, Join_dt Date not null, Pay Number) Which of the following field(s) are created correctly?