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
Ans : D
Explanation: PostgreSQL (pronounced as post-gress-Q-L) is an open source relational database management system (DBMS) developed by a worldwide team of volunteers.
2. PostgreSQL, originally called ?
A. Ingres
B. Postgres
C. Pregres
D. None of the above
View Answer
Ans : B
Explanation: PostgreSQL, originally called Postgres, was created at UCB by a computer science professor named Michael Stonebraker.
3. Using psql, you can generate a complete list of commands by using the ________ command
A. help
B. /help
C. $help
D. &help
View Answer
Ans : A
Explanation: Using psql, you can generate a complete list of commands by using the help command.For the syntax of a specific command, use the following command : postgres-# help
4. 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
Ans : B
Explanation: Change the definition of a procedural language : ALTER LANGUAGE name RENAME TO new_name
5. 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
Ans : A
Explanation: Collect statistics about a database : ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]
6. The ________ type stores a currency amount with a fixed fractional precision.
A. character
B. money
C. binary
D. numeric
View Answer
Ans : B
Explanation: The money type stores a currency amount with a fixed fractional precision. Values of the numeric, int, and bigint data types can be cast to money. Using Floating point numbers is not recommended to handle money due to the potential for rounding errors.
7. Geometric data types represent?
A. one dimensional
B. boolean
C. enum
D. two dimensional
View Answer
Ans : D
Explanation: Geometric data types represent two-dimensional spatial objects.
8. How many types of SQL bit there?
A. 2
B. 3
C. 4
D. 5
View Answer
Ans : A
Explanation: Bit String Types are used to store bit masks. They are either 0 or 1. There are two SQL bit types: bit(n) and bit varying(n), where n is a positive integer.
9. A meta-command always begins with what?
A. Forwardslash character (/)
B. Dollar sign ($)
C. Backslash character ()
D. Question mark (?)
View Answer
Ans : C
Explanation: A meta-command always begins with Backslash character ().
10. We add data to PostgreSQL by using which statement?
A. Insert
B. Add
C. Select
D. Update
View Answer
Ans : A
Explanation: We add data to PostgreSQL by using insert statement.
Discussion