PostgreSQL Questions and Answers
11. PostgreSQL written in?
A. C
B. C++
C. Java
D. Python
View Answer
Ans : C
Explanation: Written in: C
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
Ans : D
Explanation: 1994-1995 − Postgres95 : Support for SQL was added in 1994, Released as Postgres95 in 1995, Re-released as PostgreSQL 6.0 in 1996, Establishment of the PostgreSQL Global Development Team
13. Which syntax is used to Abort the current transaction?
A. ABORT
B. ABORT [ WORK ]
C. ABORT [ TRANSACTION ]
D. ABORT [ WORK | TRANSACTION ]
View Answer
Ans : D
Explanation: Abort the current transaction : ABORT [ WORK | TRANSACTION ]
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
Ans : C
Explanation: Change the definition of a trigger : ALTER TRIGGER name ON table RENAME TO new_name
15. Numeric types consist of?
A. two-byte
B. four-byte
C. eight-byte
D. All of the above
View Answer
Ans : D
Explanation: Numeric types consist of two-byte, four-byte, and eight-byte integers, four-byte and eight-byte floating-point numbers, and selectable-precision decimals.
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
Ans : C
Explanation: PostgreSQL provides the standard SQL type Boolean. The Boolean data type can have the states true, false, and a third state, unknown, which is represented by the SQL null value.
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
Ans : A
Explanation: PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses.
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
Ans : C
Explanation: This is a sorted list of distinct words that have been normalized to merge different variants of the same word, called as lexemes
19. In PostgreSQL, a named collection of tables is called ?
A. Trigger
B. View
C. Procedure
D. Schema
View Answer
Ans : D
Explanation: In PostgreSQL, a named collection of tables is called Schema.
20. PostgreSQL used what model of communication?
A. Network
B. Client/Server
C. Peer-to-Peer
D. Push Model
View Answer
Ans : B
Explanation: PostgreSQL used Client/Server model of communication.
Discussion