16th
Jun
PostgreSQL MCQ

PostgreSQL MCQ

  • Admin
  • 16th Jun, 2022
  • 941 Followers

PostgreSQL MCQ Questions

Following are mostly asked Postgresql MCQ test that are designed for professionals like you to crack you interviews. You can take this Postgresql online test before appearing to you real interview. This Postgresql quiz there are around 30+ multiple choice questions on Postgresql with four options.

1) PostgreSQL is a

  • A. XML database management system.
  • B. relational database management system.
  • C. hierarchical database management system.
  • D. network-type database management system.

2) We add data to PostgreSQL by using which statement?

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

3) PostgreSQL written in?

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

4) PostgreSQL used model of communication

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

5) In PostgreSQL, a named collection of tables is called

  • A. View
  • B. Trigger
  • C. Schema
  • D. Procedure
Download Free : PostgreSQL MCQ PDF

6) Geometric data types represent are

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

7) WAL stands for _______

  • A. Write Away Log
  • B. Write Ahead Log
  • C. Write Ahead List
  • D. None Of Above

8) Meta-command always begins

  • A. #
  • B. &
  • C. \
  • D. $

9) ____ extension is used for data encryption/decryption within PostgreSQL

  • A. crypto
  • B. pgcrypto
  • C. pgcrypt
  • D. pg

10) What is PostgreSQL ?

  • A. Open-source SMTP server.
  • B. NoSQL solution.
  • C. Open-source ORDBMS developed at UC Berkley, which supports many modern features.
  • D. Enterprise-class proprietary software developed at Bell Labs, with a basic set of features.

11) SQL condition for pattern matching is?

  • A. IN
  • B. LIKE
  • C. DISTINCT
  • D. BETWEEN

12) PostgreSQL can be installed?

  • A. from Linux binaries
  • B. on a Windows computer
  • C. from the source code
  • D. All of the Above

13) What does MCV stand for?

  • A. Most Common Values
  • B. Most Common Variables
  • C. Many Common Variables
  • D. Massive Checkpoint Vault

14) The basic psql command to list tables is

  • A. \dt
  • B. \dT
  • C. \DT
  • D. None Of Above

15) Which command is used to supress the duplicate records?

  • A. hide
  • B. supress
  • C. distinct
  • D. duplicate

16) Which function is offered by PHP for connecting to a postgreSQL?

  • A. con ( )
  • B. pg_con ( )
  • C. con_psql ( )
  • D. pg_connect ( )

17) PostgreSQL was initially released on

  • A. 8 June 1996
  • B. 8 July 1996
  • C. 8 august 1996
  • D. 8 september 1996

18) The value NULL, in database terminology, means?

  • A. Value is not relevant for this particular row.
  • B. Value is undetermined
  • C. Value is undetermined at this time
  • D. All of the Above

19) When identifying rows uniquely, we use ______ keys.

  • A. command
  • B. surrogate
  • C. standard
  • D. All of the Above

20) PostgreSQL supports Index Only Scans.

  • A. True
  • B. False

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Aug
AngularJs MCQ
01st
Jun
Magento MCQ