PostgreSQL Databases

@T-Bone

This question paper focuses on the "PostgreSQL" of Databases. These Multiple Choice Questions (mcq) should be practiced to improve the Databases skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

This question paper focuses on the "PostgreSQL" of Databases. These Multiple Choice Questions (mcq) should be practiced to improve the Databases skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

Questions

1. Which of the following is true regarding PostgreSQL?

Mark the correct option

2. PostgreSQL, originally called ?

Mark the correct option

3. Using psql, you can generate a complete list of commands by using the ________ command

Mark the correct option

4. Which syntax is used to Change the definition of a procedural language?

Mark the correct option

5. The below command is used to? ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]

Mark the correct option

6. The ________ type stores a currency amount with a fixed fractional precision.

Mark the correct option

7. Geometric data types represent?

Mark the correct option

8. How many types of SQL bit there?

Mark the correct option

9. A meta-command always begins with what?

Mark the correct option

10. We add data to PostgreSQL by using which statement?

Mark the correct option

11. PostgreSQL written in?

Mark the correct option

12. Which of the following is true regarding Postgres95?

Mark the correct option

13. Which syntax is used to Abort the current transaction?

Mark the correct option

14. The below command is used to? ALTER TRIGGER name ON table RENAME TO new_name

Mark the correct option

15. Numeric types consist of?

Mark the correct option

16. The Boolean data type can have the states true, false, and a third state?

Mark the correct option

17. PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses.

Mark the correct option

18. This is a sorted list of distinct words that have been normalized to merge different variants of the same word, called as?

Mark the correct option

19. In PostgreSQL, a named collection of tables is called ?

Mark the correct option

20. PostgreSQL used what model of communication?

Mark the correct option

Index of Questions