PostgreSQL MCQ Questions And Answers

PostgreSQL MCQs : This section focuses on "Basics" of PostgreSQL. These Multiple Choice Questions (MCQ) should be practiced to improve the PostgreSQL skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.

1. Which of the following is true regarding PostgreSQL?

A. PostgreSQL is a powerful
B. PostgreSQL is open source
C. PostgreSQL is object-relational database system
D. All of the above

View Answer


2. PostgreSQL written in?

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

View Answer


3. PostgreSQL, originally called ?

A. Ingres
B. Postgres
C. Pregres
D. None of the above

View Answer


4. 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


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

A. help
B. /help
C. $help
D. &help

View Answer


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

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

View Answer


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

A. UPDATE LANGUAGE name RENAME TO new_name
B. ALTER LANGUAGE name RENAME TO new_name
C. ALTER LANGUAGE name OWNER TO new_name
D. UPDATE LANGUAGE name OWNER TO new_name

View Answer


8. 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


9. The below command is used to?

ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]

A. Collect statistics about a database.
B. Start a transaction block.
C. End a transaction block.
D. Destroy statistics about a database.

View Answer


10. Numeric types consist of?

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

View Answer


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

A. character
B. money
C. binary
D. numeric

View Answer


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

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

View Answer


13. Geometric data types represent?

A. one dimensional
B. boolean
C. enum
D. two dimensional

View Answer


14. 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


15. How many types of SQL bit there?

A. 2
B. 3
C. 4
D. 5

View Answer


16. 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


17. A meta-command always begins with what?

A. Forwardslash character (/)
B. Dollar sign ($)
C. Backslash character ()
D. Question mark (?)

View Answer


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

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

View Answer


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

A. Insert
B. Add
C. Select
D. Update

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.