PostgreSQL MCQs (Chapterwise Multiple Choice Questions)

How will you rank text search results?

With the ORDER BY operator

With the ts_rank function

Search results are automatically ranked

Search results cannot be ranked

None of the above

Answer & Explanation

Correct Answer: With the ts_rank function

Note: This Question is unanswered, help us to find answer for this one

The most common method to get data into a table is to use what command?

Write

Send

Execute

Insert

Answer & Explanation

Correct Answer: Insert

Note: This Question is unanswered, help us to find answer for this one

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

pg_shadow table stores the password as plain text

pg_user table stores the password as encrypted text

Only superusers have access to the system password storing table

All of the above

Answer & Explanation

Correct Answer: Only superusers have access to the system password storing table

Note: This Question is unanswered, help us to find answer for this one

What is the correct order of clauses in the select statement?
1 select
2 order by
3 where
4 having
5 group by

1,2,3,4,5

1,3,5,4,2

1,3,5,2,4

1,3,2,5,4

1,3,2,4,5

1,5,2,3,4

1,4,2,3,5

1,4,3,2,5

Answer & Explanation

Correct Answer:

1,3,5,4,2

Note: This Question is unanswered, help us to find answer for this one

Which of the following is NOT a feature of user defined functions?

Functions marked IMMUTABLE can have their output indexed

They can be written in various different languages

They can perform most database management tasks

They can return multiple result sets via refcursors

They can initiate subtransactions

Answer & Explanation

Correct Answer: They can initiate subtransactions

Note: This Question is unanswered, help us to find answer for this one

Which of the following is correct regarding VACUUM?

It deletes the temporary data and recovers the disk space

The table identifier must be provided

A VACUUM statement without arguments will clean up each table in the presently connected database

All of the above

Answer & Explanation

Correct Answer: A VACUUM statement without arguments will clean up each table in the presently connected database

Note: This Question is unanswered, help us to find answer for this one

You have defined a function "Calculate()" in the template1 database. What will happen when you create a new database "ManagementDB" there?

The function will be moved to the new database

The function will be cloned to the new database

The function will remain with the template database only

Any of the above can happen

Answer & Explanation

Correct Answer: The function will be cloned to the new database

Note: This Question is unanswered, help us to find answer for this one

Which of the following geometric types is not defined in PostgreSQL?

path

box

hexagon

polygon

Answer & Explanation

Correct Answer: hexagon

Note: This Question is unanswered, help us to find answer for this one

True or False? PostgreSQL is so lightweight that performance and reliability are not affected by hardware.

False

True

Answer & Explanation

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

Premium Corp. uses alphanumeric characters for EmployeeID which contains 7 digits prefixed with 3 characters. The 3 characters describe the department code. You need to show the department code and the Employee number separately, where department code should be in capital letters. Which function(s) will you have to use for this?

CONCAT()

SUBSTR()

UPPER()

LOWER()

REPLACE()

Answer & Explanation

Correct Answer: UPPER()

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.

PostgreSQL MCQ

PostgreSQL Quick Quiz

How will you rank text search results?

The most common method to get data into a table is to use what command?

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

What is the correct order of clauses in the select statement?1 select2 order by3 where4 having5 group by

Which of the following is NOT a feature of user defined functions?

Which of the following is correct regarding VACUUM?

You have defined a function "Calculate()" in the template1 database. What will happen when you create a new database "ManagementDB" there?

Which of the following geometric types is not defined in PostgreSQL?

True or False? PostgreSQL is so lightweight that performance and reliability are not affected by hardware.

What is the correct order of clauses in the select statement?
1 select
2 order by
3 where
4 having
5 group by