PostgreSQL, Databases

Question: Which of the following holds true for functions in PostgreSQL?
A
The parameters are positional

B
Functions may be overloaded

C
A variation of the SQL99 CREATE FUNCTION command is supported

D
All of these above

Note: Not available
1. Report
Question: Choose the correct statements for a trigger function:
A
It is created using the CREATE FUNCTION command

B
It should be defined as accepting single arguments

C
It returns a value of integer datatype

D
It returns a value of integer or opaque datatype

Note: Not available
1. Report
Question: Perfect Services provides financial services. You need to display data from the pers table for joining_date from #1/1/2005# to #31/12/2005# and the job should be for Analyst or Clerk or Salesman. Which select statement will you use?
A
select * from Pers where joining_date from #1/1/2005# to #31/12/2005#, job=Analyst or clerk or salesman

B
select * from Pers where joining_date between #1/1/2005# to #31/12/2005#, job=Analyst or job=clerk or job=salesman

C
select * from Pers where joining_date between #1/1/2005# and #31/12/2005# and (job=Analyst or clerk or salesman)

D
None of these above

Note: Not available
1. Report
Question: Which of the following is correct for the postmaster -n debugging option?
A
It stops the postmaster from re-initializing shared data structures

B
It allows a developer to collect a core dump from each backend process manually

C
It causes the postmaster to use the SIGSTOP signal to stop backend processes

D
None of these above

Note: Not available
1. Report
Question: There is a table t upon which a primary key constraint by the name pk is applied. What will be the correct syntax to drop the constraint?
A
Alter table t drop primary key

B
Alter table t drop constraint pk

C
Drop primary key constraint on table t

D
Alter table t delete primary key

Note: Not available
1. Report
Question: Which of the following variable declarations is not correct?
A
cust_id INTEGER;

B
meter_name VARCHAR(30);

C
net_amt FLOAT(2);

D
update_time timestamp;

Note: Not available
1. Report
Question: What do you understand by the following PL/pgSQL declaration? c_phone customer.contact_no%TYPE;
A
This is declaring a new variable c_phone with undefined type

B
This is declaring a new variable c_phone with same type as contact_no column

C
This is declaring a new variable c_phone with variable data type

D
None of these above is correct

Note: Not available
1. Report
Question: Which of the following date and time constants are not defined in PostgreSQL?
A
today

B
current

C
epoch

D
current_day

E
yesterday

Note: Not available
1. Report
Question: Select the appropriate query for the Products table when data should be primarily ordered by ProductGroup. ProductGroup should be displayed in ascending order and CurrentStock should be in descending order:
A
Select * from Products order by CurrentStock,ProductGroup

B
Select * from Products order by CurrentStock DESC,ProductGroup

C
Select * from Products order by ProductGroup,CurrentStock

D
Select * from Products order by ProductGroup,CurrentStock DESC

E
None of these above

Note: Not available
1. Report
Question: Which of the following can be used to uniquely identify a row?
A
Primary Key

B
Unique Key

C
Foreign Key

D
All of these above

Note: Not available
1. Report

First Prev 1 2 3 4 5 Next Last

Question: Which of the following holds true for functions in PostgreSQL?

Question: Choose the correct statements for a trigger function:

Question: Perfect Services provides financial services. You need to display data from the pers table for joining_date from #1/1/2005# to #31/12/2005# and the job should be for Analyst or Clerk or Salesman. Which select statement will you use?

Question: Which of the following is correct for the postmaster -n debugging option?

Question: There is a table t upon which a primary key constraint by the name pk is applied. What will be the correct syntax to drop the constraint?

Question: Which of the following variable declarations is not correct?

Question: What do you understand by the following PL/pgSQL declaration? c_phone customer.contact_no%TYPE;

Question: Which of the following date and time constants are not defined in PostgreSQL?

Question: Select the appropriate query for the Products table when data should be primarily ordered by ProductGroup. ProductGroup should be displayed in ascending order and CurrentStock should be in descending order:

Question: Which of the following can be used to uniquely identify a row?