30 Multiple Choice Questions on PostgreSQL 12

Q1. Which of the following is a valid way to start a transaction in PostgreSQL 12?

START TRANSACTION

BEGIN TRANSACTION

BEGIN

All of the above

Q2. Which of the following commands is used to insert data into a table in PostgreSQL 12?

SET

UPDATE

ADD

INSERT

Q3. Which of the following is not a valid aggregation function in PostgreSQL 12?

GROUP_CONCAT

MIN

STDEV

COUNT

Q4. Which of the following is not a valid constraint type in PostgreSQL 12?

INDEX

FOREIGN KEY

UNIQUE

PRIMARY KEY

Q5. Which command is used to delete data from a table in PostgreSQL 12?

ERASE

CLEAR

REMOVE

DELETE

Q6. Which of the following is a valid way to comment a line in a PostgreSQL 12 SQL script?

/* This is a comment */

-- This is a comment

// This is a comment

# This is a comment

Q7. Which of the following is not a valid index type in PostgreSQL 12?

B-Tree

Heap

Hash

GIN

Q8. Which command is used to grant privileges on a table to a user in PostgreSQL 12?

GRANT PRIVILEGES

GRANT TABLE

GRANT ALL

GRANT SELECT

Q9. Which command is used to create an index on a table in PostgreSQL 12?

ADD INDEX

CREATE INDEX

INDEX TABLE

CREATE KEY

Q10. Which command is used to revoke privileges from a user in PostgreSQL 12?

REVOKE SELECT

REVOKE ALL

REVOKE PRIVILEGES

REVOKE TABLE

Q11. Which command is used to create a new sequence in PostgreSQL 12?

CREATE AUTOINCREMENT

CREATE SERIAL

CREATE IDENTITY

CREATE SEQUENCE

Q12. Which command is used to rename a table in PostgreSQL 12?

ALTER RENAME TABLE

RENAME TABLE

RENAME TO

ALTER TABLE RENAME

Q13. What is the maximum number of columns a table can have in PostgreSQL 12?

100

1600

250

2500

Q14. Which of the following is not a valid join type in PostgreSQL 12?

RIGHT JOIN

OUTER JOIN

INNER JOIN

LEFT JOIN

Q15. Which of the following is not a valid aggregation function in PostgreSQL 12?

COUNT

SUM

MAXIMUM

AVG

Q16. Which command is used to create a new database in PostgreSQL 12?

CREATE DATABASE

CREATE VIEW

CREATE TABLE

CREATE INDEX

Q17. Which command is used to update data in a table in PostgreSQL 12?

CHANGE

SET

MODIFY d

UPDATE

Q18. Which command is used to create a new user in PostgreSQL 12?

NEW USER

CREATE USER

USER ADD

ADD USER

Q19. Which of the following is not a valid data type conversion function in PostgreSQL 12?

EXTRACT

TO_DATE

CONVERT

CAST

Q20. Which command is used to modify the definition of an existing table in PostgreSQL 12?

UPDATE TABLE

ALTER TABLE

CHANGE TABLE

MODIFY TABLE

Q21. Which command is used to create a new schema in PostgreSQL 12?

CREATE VIEW

CREATE SCHEMA

CREATE DATABASE

CREATE TABLESPACE

Q22. Which command is used to create a new table in PostgreSQL 12?

TABLE CREATE

CREATE TABLE

NEW TABLE

ADD TABLE

Q23. Which of the following commands is used to delete a table in PostgreSQL 12?

ERASE TABLE

REMOVE TABLE

DROP TABLE

DELETE TABLE

Q24. Which of the following is not a valid comparison operator in PostgreSQL 12?

=

!=

<>

>=

Q25. Which of the following statements is true about the SERIAL data type in PostgreSQL 12?

It can only be used for primary key columns.

It can be used in conjunction with other data types.

It is equivalent to the INTEGER data type.

It generates a unique integer value when a new row is inserted into the table.

Q26. Which of the following is not a valid system catalog table in PostgreSQL 12?

pg_tablespaces

pg_class

pg_index

pg_database

Q27. Which command is used to add a new column to an existing table in PostgreSQL 12?

ALTER TABLE

MODIFY COLUMN

ADD COLUMN

CREATE COLUMN

Q28. Which of the following is not a valid data type in PostgreSQL 12?

CHAR

DECIMAL

INTEGER

DOUBLE PRECISION

Q29. Which of the following is a valid way to concatenate two strings in PostgreSQL 12?

string1 || string2

string1 + string2

string1 . string2

string1 & string2

Q30. Which command is used to create a new trigger in PostgreSQL 12?

TRIGGER TABLE

ADD TRIGGER

CREATE EVENT

CREATE TRIGGER

Your Score

- of - questions are answered correctly

Certificate in PostgreSQL 12

For Support

Office Hours

We are on

Company

Customer Service

Help

PostgreSQL 12

Your Score

- of - questions are answered correctly

Login to view answer sheet

FORGOT PASSWORD

SIGN UP

Email Verification