PostgreSQL MCQ Questions

PostgreSQL MCQ Questions

  • Satyam Jaiswal
  • 25th Nov, 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.

Latest Interview Questions

img
API Testing Interview Questions 08th Aug, 2022
img
Celery Interview Questions 25th Nov, 2021
img
Solaris Interview Questions 24th Feb, 2021
img
Telematics Interview Questions 05th Mar, 2021
img
UFT Interview Questions 08th Aug, 2022
img
Terraform Interview Questions 23rd Nov, 2021

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.

Latest Posts

img
Login With Google using PHP 18th Nov, 2019
img
Working with expressions In Angular JS? 01st Nov, 2019
img
What is AngularJS? Why it is Used. 16th Nov, 2019

Latest MCQ Questions

img
Arduino MCQ Questions 08th Dec, 2021
img
3D Printing MCQ 23rd Nov, 2021
img
Bioinformatics MCQ Questions 12th Mar, 2022
img
Business Intelligence MCQ 15th Apr, 2022
img
Salesforce MCQ 28th Feb, 2022
img
SAP ABAP MCQ 05th Mar, 2022

Related MCQ/Quiz

01st
Nov
Fortran MCQ Questions

Fortran MCQ Questions

01st
Nov
Software Engineering MCQ Questions

Software Engineering MCQ Questions

01st
Nov
JavaScript MCQ

JavaScript MCQ

01st
Dec
Compiler Design MCQ Questions

Compiler Design MCQ Questions

01st
May
Agile Methodology MCQ

Agile Methodology MCQ

01st
Jul
Machine Learning MCQ Questions

Machine Learning MCQ Questions