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, originally called ?

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

View Answer


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


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


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


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

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

View Answer


7. Geometric data types represent?

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

View Answer


8. How many types of SQL bit there?

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

View Answer


9. A meta-command always begins with what?

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

View Answer


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

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

View Answer





Discussion


* You must be logged in to add comment.