PostgreSQL, Databases

Question: Which of the following holds true when you have defined a function with "isstrict" attribute?
A
This will allow you to pre-evaluate a call to a function

B
This will not allow you to pre-evaluate a call to a function if one of its arguments is NULL

C
The function will always return a NULL value if more than one of its arguments is NULL

D
The function will always return a NULL value whenever any of its arguments is NULL

Note: Not available
1. Report
Question: Which of the following is true about PostgreSQL clients?
A
The graphical client application is psql

B
The command line driven client is PgAccess

C
psql client is installed by default

D
PgAccess installation requires specification of the with-pgtcl option

Note: Not available
1. Report
Question: Will the following function compile and execute? DECLARE intValue int4; BEGIN intValue := 20 * 20; return intValue; END;
A
It will not compile

B
It will compile but will give a runtime error

C
It will compile but will not produce any output

D
It will compile and will produce 400 as output

Note: Not available
1. Report
Question: In which order are primary queries and their sub-queries interpreted:
A
prime query followed by sub query followed by sub sub query and so on

B
lowest sub query followed by sub query followed by prime query

C
The whole query is interpreted at one time

D
There is no fixed sequence of interpretation of a query

Note: Not available
1. Report
Question: Which of the following copy commands will work in PostgreSQL?
A
COPY

B
\copy

C
COPY .. TO

D
All of these above

Note: Not available
1. Report
Question: A wholesale merchant shop needs a report about the sale where total sale of the day is more than $50,000. Which of the following will fulfill this requirement?
A
select * from orders where sum(amount) > 50000

B
select * from orders where sum(amount) > 50000 order by OrderDate

C
select * from orders group by OrderDate where sum(amount) > 50000

D
select * from orders group by OrderDate having sum(amount)>50000

Note: Not available
1. Report
Question: Which of the following trigger function variables is not defined?
A
TG_NARGS

B
NEW

C
TG_NAME

D
TG_WHERE

E
OLD

F
None of these above

Note: Not available
1. Report
Question: Is function overloading available in PL/pgSQL?
A
True

B
False

Note: Not available
1. Report
Question: Can you define variables in PostgreSQL pl/pgSQL whose value cannot be null?
A
No, you cannot

B
Yes, you can use 'NOT NULL' after datatype

C
Yes, you can use 'NON NULLABLE' after datatype

D
Yes, that is the default case, for setting it to hold null values 'NULLABLE' is used after datatype

Note: Not available
1. Report
Question: What is the error in the following query if the students table contains several records? select name from students where name = (select name from students order by name);
A
= should be replaced by in operator

B
Order by clause in the subquery should be preceded with a group by clause

C
Order by clause in the subquery can be used only if the where and group by clauses have been applied

D
Group by clause should be applied to the outer query

E
An order by clause is not allowed in a subquery

F
There is no error

Note: Not available
1. Report

First Prev 3 4 5 6 7 Next Last

Question: Which of the following holds true when you have defined a function with "isstrict" attribute?

Question: Which of the following is true about PostgreSQL clients?

Question: Will the following function compile and execute? DECLARE intValue int4; BEGIN intValue := 20 * 20; return intValue; END;

Question: In which order are primary queries and their sub-queries interpreted:

Question: Which of the following copy commands will work in PostgreSQL?

Question: A wholesale merchant shop needs a report about the sale where total sale of the day is more than $50,000. Which of the following will fulfill this requirement?

Question: Which of the following trigger function variables is not defined?

Question: Is function overloading available in PL/pgSQL?

Question: Can you define variables in PostgreSQL pl/pgSQL whose value cannot be null?

Question: What is the error in the following query if the students table contains several records? select name from students where name = (select name from students order by name);