Top 55 PostgreSQL MCQ (Quiz) : W3Schools, Tutorials Point

1 .

PostgreSQL, originally called?

A)

Ingres

B)

Pregres

C)

Postgres

D)

None of the above

Correct Answer : Postgres

Explanation : PostgreSQL, originally called Postgres, was created at UCB by a computer science professor named Michael Stonebraker.

2 .

PostgreSQL written in which programming language?

A)

C Language

B)

C++ Language

C)

Java Language

D)

Python Language

Correct Answer : C Language

Explanation : PostgreSQL written in "C" programming language.

3 .

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

Correct Answer : All of the above

Explanation : PostgreSQL (pronounced as post-gress-Q-L) is an open source relational database management system (DBMS) developed by a worldwide team of volunteers.

4 .

The SQL WHERE clause_________

A)

limits the row data are returned

B)

limits the column data that are returned

C)

Both (A) and (B)

D)

None of the above

Correct Answer : limits the row data are returned

5 .

When PostgreSQL was Initial release date?

A)

2 March 1995

B)

8 July 1996

C)

12 August 1997

D)

5 November 1998

Correct Answer : 8 July 1996

6 .

Who developed PostgreSQL?

A)

Daniel Abadi

B)

Michael Stonebraker

C)

Margo Seltzer

D)

Jeffrey Naughton

Correct Answer : Michael Stonebraker

Explanation :

Michael Stonebraker : Originally developed in 1986 as a follow-up to INGRES (an open-source SQL relational database project begun in the early 1970s), POSTGRES, now known as PostgreSQL, was the brainchild of Michael Stonebraker, a computer science professor at Berkeley.

7 .

Which of the following is true regarding Postgres95?

A)

Support for SQL was added in 1994

B)

Released as Postgres95 in 1995

C)

Establishment of the PostgreSQL Global Development Team

D)

All of the above

Correct Answer : All of the above

Explanation : 1994-1995 − Postgres95 : Support for SQL was added in 1994, Released as Postgres95 in 1995, Re-released as PostgreSQL 6.0 in 1996, Establishment of the PostgreSQL Global Development Team

8 .

When developing SQL injection attacks, the final resulting statement must what?

A)

It must start with a single quote

B)

It must meet the ISO SQL:2008 standard

C)

It must be balanced and true

D)

It must end with a SQL comment ( –)

Correct Answer : It must be balanced and true

9 .

ROLLBACK adalah Struktur Query pada Level?

A)

Transaction Control Language

B)

Data Control Language

C)

Data Definition Language

D)

Data Manipulation Language

Correct Answer : Transaction Control Language

10 .

How many tables may be included with a join?

A)

One

B)

Two

C)

Three

D)

All of the above

Correct Answer : All of the above

11 .

Which Of The Following Is True About Modifying Rows In A Table?

A)

You can modify multiple columns.

B)

You can update some rows in a table based on values from another table.

C)

If you try to update a record related to an integrity constraint, it raises an error.

D)

All of the above.

Correct Answer : All of the above.

12 .

Command Yang Digunakan Untuk Melakukan Backup Cluster Database Adalah?

A)

pg_dumpall

B)

pg_basebackup

C)

Both (A) and (B)

D)

None of the above

Correct Answer : pg_basebackup

13 .

Injecting A Malicious Script Into A Website Which Will Later Be Executed In A Victim's Web Browser Is Called What?

A)

Java scripting

B)

Malware injection

C)

Cross site scripting

D)

Command Injection

Correct Answer : Cross site scripting

14 .

The Command To Remove Rows From A Table 'CUSTOMER' Is______

A)

DELETE FROM CUSTOMER WHERE ..

B)

DROP FROM CUSTOMER ..

C)

UPDATE FROM CUSTOMER ..

D)

REMOVE FROM CUSTOMER ..

Correct Answer : DELETE FROM CUSTOMER WHERE ..

15 .

When retrieving data in a particular table, we use the_____________ statement.

A)

FETCH

B)

ORDER BY

C)

SELECT FROM

D)

SELECT DISTINCT

Correct Answer : SELECT FROM

16 .

The SQL ALTER statement can be used to?

A)

add rows to the table

B)

change the table data

C)

delete rows from the table

D)

change the table structure

Correct Answer : change the table structure

17 .

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

A)

SELECT Persons.FirstName

B)

SELECT FirstName FROM Persons

C)

EXTRACT FirstName FROM Persons

D)

None of the above

Correct Answer : SELECT FirstName FROM Persons

18 .

Using psql, you can generate a complete list of commands by using the ________ command.

A)

help

B)

/help

C)

$help

D)

&help

Correct Answer : help

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

19 .

Which syntax is used to Abort the current transaction?

A)

ABORT

B)

ABORT [ WORK ]

C)

ABORT [ TRANSACTION ]

D)

ABORT [ WORK | TRANSACTION ]

Correct Answer : ABORT [ WORK | TRANSACTION ]

Explanation : Abort the current transaction : ABORT [ WORK | TRANSACTION ]

20 .

Ultimately, injection attacks are caused by what?

A)

Development languages using immutable strings

B)

Unpatched versions of applications and operating systems

C)

Developers not sanitizing application input

D)

Operating systems not restricting memory from one process to another

Correct Answer : Developers not sanitizing application input

21 .

Metasploit is an exploitation tool that has multiple user interfaces. Which of the options below is a valid user interfaces for Metasploit?

A)

armitage

B)

msfconsole

C)

crowdstrike

D)

Both (A) and (B)

Correct Answer : Both (A) and (B)

22 .

The WHERE Clause Is Useful When?

A)

An exact match is not possible in a CREATE statement

B)

An exact match is not possible in a SELECT statement

C)

An exact match is necessary in a CREATE statement

D)

An exact match is necessary in a SELECT statement

Correct Answer : An exact match is not possible in a SELECT statement

23 .

We Add Data To PostgreSQL By Using Which Statement?

A)

INSERT

B)

ADD

C)

UPDATE

D)

SELECT

Correct Answer : INSERT

24 .

The SQL Condition For Pattern Matching Is?

A)

IN

B)

LIKE

C)

BETWEEN

D)

DISTINCT

Correct Answer : LIKE

25 .

Which syntax is used to Change the definition of a procedural language?

A)

ALTER LANGUAGE name OWNER TO new_name

B)

UPDATE LANGUAGE name OWNER TO new_name

C)

ALTER LANGUAGE name RENAME TO new_name

D)

UPDATE LANGUAGE name RENAME TO new_name

Correct Answer : ALTER LANGUAGE name RENAME TO new_name

Explanation : Change the definition of a procedural language : ALTER LANGUAGE name RENAME TO new_name

26 .

The below command is used to?

ALTER TRIGGER name ON table RENAME TO new_name

A)

Insert the definition of a trigger

B)

Update the definition of a trigger

C)

Delete the definition of a trigger

D)

Change the definition of a trigger

Correct Answer : Change the definition of a trigger

Explaination : Change the definition of a trigger : ALTER TRIGGER name ON table RENAME TO new_name

27 .

The below command is used to?

ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]

A)

Start a transaction block.

B)

End a transaction block.

C)

Destroy statistics about a database.

D)

Collect statistics about a database.

Correct Answer : Collect statistics about a database.

Explaination : Collect statistics about a database : ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]

28 .

Berikut ini adalah Query untuk melakukan Connection Check, Kecuali!

A)

\conninfo

B)

SHOW current_connection;

C)

show port;

D)

SELECT current_user;

Correct Answer : SHOW current_connection;

29 .

Sebutkan default logging name format pada PostgreSQL.

A)

postgresql-%a.log

B)

‘postgresql-%d.log

C)

‘postgresql-%d-%a.log

D)

‘postgresql-%a-%d-%m.log

Correct Answer : postgresql-%a.log

30 .

What is the term for technology that restricts access to networks or services based upon the user’s geographical location?

A)

Geoblocking

B)

TLD Filtering

C)

Domain Filtering

D)

TTL: Topographic Traffic Limiting

Correct Answer : Geoblocking

31 .

Which of the following query is correct for using comparison operators?

A)

SELECT name, course_name FROM student WHERE age>50 and <80;

B)

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

C)

SELECT name, course_name FROM student WHERE age>50 and age<80;

D)

None of the above

Correct Answer : SELECT name, course_name FROM student WHERE age>50 and age<80;

32 .

The ability to find all web pages, directories and other files that make up a web application is provided by a__________

A)

Proxy

B)

Spider

C)

Response analysis tool

D)

None of the above

Correct Answer : Spider

33 .

Numeric types consist of?

A)

two-byte

B)

four-byte

C)

eight-byte

D)

All of the above

Correct Answer : All of the above

Explanation : Numeric types consist of two-byte, four-byte, and eight-byte integers, four-byte and eight-byte floating-point numbers, and selectable-precision decimals.

34 .

Sebutkan cara untuk membuat sebuah output query dengan menggunakan command OS__________

A)

\o

B)

psql -o

C)

psql -s

D)

None of the above

Correct Answer : psql -o

35 .

When you want to use a join between columns that are in the same table, you use what type of join?

A)

UNION

B)

LEFT JOIN

C)

SELF JOIN

D)

OUTER JOIN

Correct Answer : SELF JOIN

36 .

TCL commands are_______

A)

GRANT

B)

REVOKE

C)

ROLLBACK

D)

All of the above

Correct Answer : All of the above

37 .

A named collection of tables is called what in PostgreSQL?

A)

Schema

B)

View

C)

Diagram

D)

Trigger

Correct Answer : Schema

38 .

The ability to intercept and change requests as they leave a web browser is provided by a________

A)

Proxy

B)

Spider

C)

Response analysis tool

D)

None of the above

Correct Answer : Proxy

39 .

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

A)

binary

B)

money

C)

numeric

D)

character

Correct Answer : money

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.

40 .

The Boolean data type can have the states true, false, and a third state?

A)

null

B)

error

C)

unknown

D)

undefined

Correct Answer : unknown

Explanation : PostgreSQL provides the standard SQL type Boolean. The Boolean data type can have the states true, false, and a third state, unknown, which is represented by the SQL null value.

41 .

PostgreSQL used what model of communication?

A)

Network

B)

Push Model

C)

Peer-to-Peer

D)

Client/Server

Correct Answer : Client/Server

Explanation : PostgreSQL used Client/Server model of communication.

42 .

In PostgreSQL, a named collection of tables is called?

A)

View

B)

Schema

C)

Trigger

D)

Procedure

Correct Answer : Schema

Explanation : In PostgreSQL, a named collection of tables is called Schema.

43 .

A tool that examines responses from web-servers and web sites in order to 'fingerprint' them for an analysis of what software and versions they are called what?

A)

Proxy

B)

Spider

C)

Response analysis tool

D)

All of the above

Correct Answer : Response analysis tool

44 .

If you don't specify ASC or DESC, PostgreSQL will assume you want to see results__________

A)

in ascending order

B)

in a random order

C)

in descending order

D)

grouped together by field type

Correct Answer : in ascending order

45 .

Which Of The Following Tasks Can Be Performed With The Tool NTDS Audit?

A)

Identify the number of accounts with non-expiring passwords

B)

Show the last login date/time of each administrative user

C)

Show the last login date/time of each non-administrative user.

D)

Give information about domain controllers that have weak network encryption

Correct Answer : Identify the number of accounts with non-expiring passwords

46 .

PostgreSQL is the default database for macOS Server and is also available for______

A)

Linux

B)

Windows

C)

FreeBSD & OpenBSD.

D)

All of the above

Correct Answer : All of the above

47 .

A meta-command always begins with what?

A)

Dollar sign ($)

B)

Backslash character ()

C)

Question mark (?)

D)

Forwardslash character (/)

Correct Answer : Backslash character ()

Explanation : A meta-command always begins with Backslash character ().

48 .

This is a sorted list of distinct words that have been normalized to merge different variants of the same word, called as?

A)

UUID

B)

tsquery

C)

lexemes

D)

None of the above

Correct Answer : lexemes

Explanation : This is a sorted list of distinct words that have been normalized to merge different variants of the same word, called as lexemes.

49 .

Geometric data types represent?

A)

enum

B)

boolean

C)

one dimensional

D)

two dimensional

Correct Answer : two dimensional

Explanation : Geometric data types represent two-dimensional spatial objects.

50 .

Unless you specify NOT NULL, PostgreSQL will assume that a column is :

A)

Optional

B)

Text

C)

Required

D)

Integers

Correct Answer : Optional

51 .

Delete * from empl;

A)

Destroys the table.

B)

Deletes all tuples.

C)

updates the table emp with null.

D)

None of the above

Correct Answer : Deletes all tuples.

52 .

DML commands are :

A)

INSERT

B)

UPDATE

C)

DELETE

D)

All of the above

Correct Answer : All of the above

53 .

Injecting a malicious script into a website which will later be executed in a victim’s web browser is called what?

A)

Java scripting

B)

Malware injection

C)

Cross site scripting

D)

Command Injection

Correct Answer : Cross site scripting

54 .

Special type of stored procedure is?

A)

Table

B)

Trigger

C)

View

D)

Function

Correct Answer : Trigger

55 .

What is one mistake network administrators often make from a security perspective?

A)

Using domain admin privileged accounts for day-to-day non-admin use.

B)

Enforcing password security on users who do not require it.

C)

Forgetting passwords on systems since they have too many passwords.

D)

Not writing passwords down in a safe place, such as a sticky note on your workstation.

Correct Answer : Using domain admin privileged accounts for day-to-day non-admin use.

PostgreSQL MCQs with Answers