PostgreSQL, Databases

Question: Consider the following structure of the students table: rollno number(4) name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?
A
Select course from students where count(course) > 5;

B
Select course from students where count(*) > 5 group by course;

C
Select course from student's group by course;

D
Select course from student's group by course having count(*) > 5;

Note: Not available
1. Report
Question: Choose the correct statement regarding WAL in PostgreSQL:
A
It increases the reliability of the database

B
It logs the entries to the database automatically

C
It is detrimental for database performance

D
There is no such term defined in PostgreSQL

Note: Not available
1. Report
Question: Which of the following functions is not available in PostgreSQL?
A
intfrombit

B
bittoint4

C
to_number

D
to_timestamp

Note: Not available
1. Report
Question: What is the first step in installing PL/pgSQL in PostgreSQL?
A
Use 'CREATE FUNCTION' to create the procedural call handler

B
Use 'CREATE LANGUAGE' SQL command

C
Either one of the above can be used

Note: Not available
1. Report
Question: Which of the following is correct with regard to Password Authentication?
A
pg_shadow table stores the password as plain text

B
pg_user table stores the password as encrypted text

C
Only superusers have access to the system password storing table

D
All of these above

Note: Not available
1. Report
Question: A steel production company has two sales outlets. Both outlets are maintaining their data separately in servers SVA and SVD. Both outlets use the same structure for the Sales table. Which method will you use to create a combined sales report for both the outlets?
A
Select * from SVA.Sales join SVD.Sales

B
Select * from SVA.Sales union all SVD.Sales

C
select * from SVA.Sales,SVD.Sales

D
None of these above

Note: Not available
1. Report
Question: Which of the following help PostgreSQL avoid unnecessary locking of records?
A
Multi Lock

B
MCVR

C
MVCC

D
MVSQL

Note: Not available
1. Report
Question: Which of the following help PostgreSQL avoid unnecessary locking of records?
A
Multi Lock

B
MCVR

C
MVCC

D
MVSQL

Note: Not available
1. Report
Question: Which of the following programming structures is not available in PL/pgSQL?
A
IF THEN ELSE

B
LOOP

C
WHILE

D
DO WHILE

E
FOR

Note: Not available
1. Report
Question: When should sub queries be used?
A
To define the set of rows to be inserted in a table

B
To define the set of rows to be included in a view

C
To define one or more values to be assigned to existing rows

D
To provide values for conditions in the Where clause

E
All of these above are correct

Note: Not available
1. Report

First Prev 4 5 6 7 8 Next Last

Question: Consider the following structure of the students table: rollno number(4) name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?

Question: Choose the correct statement regarding WAL in PostgreSQL:

Question: Which of the following functions is not available in PostgreSQL?

Question: What is the first step in installing PL/pgSQL in PostgreSQL?

Question: Which of the following is correct with regard to Password Authentication?

Question: A steel production company has two sales outlets. Both outlets are maintaining their data separately in servers SVA and SVD. Both outlets use the same structure for the Sales table. Which method will you use to create a combined sales report for both the outlets?

Question: Which of the following help PostgreSQL avoid unnecessary locking of records?

Question: Which of the following help PostgreSQL avoid unnecessary locking of records?

Question: Which of the following programming structures is not available in PL/pgSQL?

Question: When should sub queries be used?