PostgreSQL MCQ Questions

PostgreSQL MCQ Questions | Freshers & Experienced

  • Satyam Jaiswal
  • 22nd May, 2021

We are introducing here the best PostgreSQL MCQ Questions, which are very popular & asked various times. This Quiz contains the best 25+ PostgreSQL MCQ with Answers, which cover the important topics of PostgreSQL so that, you can perform best in PostgreSQL exams, interviews, and placement activities.

PostgreSQL MCQ Questions

1) PostgreSQL is originally known as __________.

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

2) ________ syntax is used to Change the definition of a procedural language.

  • A. ALTER LANGUAGE name OWNER TO new_name
  • B.UPDATE LANGUAGE name RENAME TO new_name
  • C.ALTER LANGUAGE name RENAME TO new_name
  • D.All of the above

3) _________ command is used to connect/select a database.

  • A. \c
  • B.\I
  • C.\cd
  • D.None of the above

4) _______ join are used to create a join between columns that are in the same table.

  • A. right outer
  • B.union
  • C.left outer
  • D.self

5) The application that makes requests of the PostgreSQL server are known as _________.

  • A. Thin Client
  • B.Client
  • C.Interface
  • D.None of the above

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

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

7) In PostgreSQL, a named collection of tables is called ___________.

  • A. Trigger
  • B.Diagram
  • C.Schema
  • D.None of the above

8) ___________ statement is known as the heart of SQL.

  • A. FROM
  • B.SELECT
  • C.WHERE
  • D.IF

9) PostgreSQL is _______.

  • A. a relational database management system.
  • B.an XML database management system.
  • C.a hierarchical database management system.
  • D.All of the above

10) ________ statement is used to add data to PostgreSQL.

  • A. ADD
  • B.INSERT
  • C.SELECT
  • D.UPDATE

11) ________ model of communication is used in PostgreSQL

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

12) ________ is the SQL condition for pattern matching.

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

13) ________ command tells PostgreSQL that all of the changes you made to a database should become permanent.

  • A. Apply
  • B.Execute
  • C.Commit
  • D.All of the above

14) Triggers can be configured to execute when ________ operations are performed.

  • A. INSERT statements
  • B.UPDATE statements
  • C.DELETE statements
  • D.All of the above

15) WAL stands for _________.

  • A. Write Ahead Log
  • B.Write Ahead List
  • C.Write Away Log
  • D.None of the above

16) A tablespace is a place where database objects are stored on disk.

  • A. True
  • B.False

17) Geometric data types represent ________.

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

18) The core PostgreSQL source code includes _______.

  • A. VB and VB.NET interfaces
  • B.The C and embedded C interfaces
  • C.Ruby and PHP interfaces
  • D.None of the above

19) Unless you specify NOT NULL, PostgreSQL will assume that a column is __________.

  • A. Required
  • B.Optional
  • C.Integers
  • D.None of the above

20) Only the administrator can make use of tablespaces.

  • A. True
  • B.False

21) ________ command turns on timing.

  • A. start time
  • B.time start
  • C.timing
  • D.None of the above

22) How many types of SQL bit there?

  • A. 3
  • B.2
  • C.1
  • D.4

23) Dynamic Tracing is enabled by default at compile time.

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

24) MCV stand for _________.

  • A. Most Computing Vault
  • B.Most Computer Values
  • C.Most Common Vault
  • D.Most Common Values

25) PostgreSQL supports Index Only Scans.

  • A. True
  • B.False

26) . A meta-command always begins with _________.

  • A. #
  • B.\
  • C.@
  • D.%

27) Hash indexes are not crash-safe.

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

28) _______ extension is used for data encryption/decryption within PostgreSQL.

  • A. pgcrypt
  • B.crypto
  • C.pgcrypto
  • D.None of the above

29) A file containing values too wide to fit comfortably in the main table is known as __________.

  • A. TO file
  • B.TEST file
  • C.TUSK file
  • D.TOAST file

30) When identifying rows uniquely, we use__________keys.

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

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.