PostgreSQL Questions and Answers

11. PostgreSQL written in?

A. C
B. C++
C. Java
D. Python

View Answer


12. Which of the following is true regarding Postgres95?

A. Support for SQL was added in 1994
B. Released as Postgres95 in 1995
C. Establishment of the PostgreSQL Global Development Team
D. All of the above

View Answer


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

A. ABORT
B. ABORT [ WORK ]
C. ABORT [ TRANSACTION ]
D. ABORT [ WORK | TRANSACTION ]

View Answer


14. The below command is used to?

ALTER TRIGGER name ON table RENAME TO new_name

A. Delete the definition of a trigger
B. Update the definition of a trigger
C. Change the definition of a trigger
D. Insert the definition of a trigger

View Answer


15. Numeric types consist of?

A. two-byte
B. four-byte
C. eight-byte
D. All of the above

View Answer


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

A. null
B. error
C. unknown
D. undefined

View Answer


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

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


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

A. tsquery
B. UUID
C. lexemes
D. None of the above

View Answer


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

A. Trigger
B. View
C. Procedure
D. Schema

View Answer


20. PostgreSQL used what model of communication?

A. Network
B. Client/Server
C. Peer-to-Peer
D. Push Model

View Answer





Discussion


* You must be logged in to add comment.