1 $What type of database management system is PostgreSQL classified as?$

A.

Object-Relational Database Management System (ORDBMS)

B.

Network Database

C.

Hierarchical Database

D.

Flat File Database

2 $Which mechanism does PostgreSQL use to handle concurrency without read locks blocking write locks?$

A.

Table Locking

B.

Two-Phase Locking

C.

MVCC (Multi-Version Concurrency Control)

D.

Optimistic Locking

3 $What is the default TCP port that PostgreSQL listens on?$

A.

8080

B.

3306

C.

5432

D.

1521

4 $What is the name of the interactive terminal-based command-line tool for PostgreSQL?$

A.

pg_terminal

B.

pgAdmin

C.

psql

D.

sqlcmd

5 $Which configuration file is primarily responsible for controlling client authentication in PostgreSQL?$

A.

pg_ident.conf

B.

config.json

C.

postgresql.conf

D.

pg_hba.conf

6 $What is the default superuser account created during PostgreSQL installation?$

A.

root

B.

postgres

C.

admin

D.

sa

7 $Which command inside the psql interface is used to list all databases?$

A.

Both A and B

B.

SHOW DATABASES;

C.

\l

D.

\list

8 $Which data type in PostgreSQL is best suited for storing JSON data with indexing capabilities?$

A.

TEXT

B.

VARCHAR

C.

JSON

D.

JSONB

9 $Which SQL statement is used to create a new database in PostgreSQL?$

A.

NEW DATABASE name;

B.

CREATE DATABASE name;

C.

INIT DATABASE name;

D.

MAKE DATABASE name;

10 $What does the acronym WAL stand for in the context of PostgreSQL architecture?$

A.

Wide-Area Latency

B.

Web Application Layer

C.

Write-After Log

D.

Write-Ahead Logging

11 $Which command allows you to connect to a specific database from within the psql prompt?$

A.

\connect dbname

B.

Both A and B

C.

\c dbname

D.

\use dbname

12 $To remove a table and all its data from the database, which command is used?$

A.

ERASE TABLE

B.

DELETE TABLE

C.

REMOVE TABLE

D.

DROP TABLE

13 $Which PostgreSQL data type is an auto-incrementing integer typically used for primary keys?$

A.

SERIAL

B.

INT

C.

NUMERIC

D.

AUTO_INT

14 $What is the purpose of the 'TRUNCATE' command?$

A.

To delete specific rows based on a condition

B.

To delete all rows quickly without logging individual row deletions

C.

To drop the table structure

D.

To minify the database size

15 $Which constraint ensures that a column cannot contain NULL values?$

A.

UNIQUE

B.

PRIMARY KEY

C.

NOT NULL

D.

CHECK

16 $How do you rename an existing table 'users' to 'customers' in PostgreSQL?$

A.

UPDATE TABLE users SET NAME = customers;

B.

MODIFY TABLE users RENAME customers;

C.

RENAME TABLE users TO customers;

D.

ALTER TABLE users RENAME TO customers;

17 $Which operator is used for pattern matching with wildcards in a WHERE clause?$

A.

=

B.

MATCH

C.

LIKE

D.

SAME

18 $In the context of the LIKE operator, what does the '%' wildcard represent?$

A.

A NULL value

B.

Exactly one character

C.

Zero or more characters

D.

A numeric digit

19 $Which SQL clause is used to filter records that meet a specified condition?$

A.

GROUP BY

B.

WHERE

C.

ORDER BY

D.

HAVING

20 $What is the correct syntax to insert a new record into the 'students' table?$

A.

UPDATE students ADD (1, 'John');

B.

INSERT students SET id=1, name='John';

C.

ADD TO students VALUES (1, 'John');

D.

INSERT INTO students (id, name) VALUES (1, 'John');

21 $How can you retrieve all columns from the 'employees' table?$

A.

FETCH employees;

B.

SELECT ALL FROM employees;

C.

GET * FROM employees;

D.

SELECT * FROM employees;

22 $Which clause allows you to limit the number of rows returned by a query?$

A.

ROWNUM

B.

LIMIT

C.

STOP

D.

TOP

23 $Which command allows you to skip a specific number of rows before returning the result set?$

A.

SKIP

B.

OFFSET

C.

JUMP

D.

NEXT

24 $What is the correct syntax to update the email of a user with id 5?$

A.

MODIFY users SET email = 'new@test.com' WHERE id = 5;

B.

CHANGE users email = 'new@test.com' WHERE id = 5;

C.

UPDATE users SET email = 'new@test.com' WHERE id = 5;

D.

SET users.email = 'new@test.com' WHERE id = 5;

25 $What happens if you run a DELETE FROM table_name command without a WHERE clause?$

A.

It deletes all rows in the table.

B.

It deletes the table structure.

C.

It deletes the first row.

D.

It throws a syntax error.

26 $Which keyword is used to return data immediately after an INSERT, UPDATE, or DELETE operation in PostgreSQL?$

A.

RETURNING

B.

RETURN

C.

OUTPUT

D.

BACK

27 $Which PostgreSQL data type stores both date and time?$

A.

TIME

B.

TIMESTAMP

C.

DATE

D.

DATETIME

28 $Which command is used to modify the structure of an existing table, such as adding a column?$

A.

ALTER TABLE

B.

MODIFY TABLE

C.

CHANGE TABLE

D.

UPDATE TABLE

29 $To ensure a column's value is unique across the entire table, which constraint should be used?$

A.

UNIQUE

B.

PRIMARY

C.

SINGLE

D.

DISTINCT

30 $Which operator is used to combine string values in PostgreSQL?$

A.

||

B.

&

C.

CONCAT()

D.

+

31 $How do you sort the result set in descending order?$

A.

ORDER BY column_name DESC

B.

ORDER BY column_name ASC

C.

SORT BY column_name DESC

D.

GROUP BY column_name DESC

32 $Which function is used to count the number of rows in a selection?$

A.

SUM()

B.

COUNT()

C.

ADD()

D.

TOTAL()

33 $What is the purpose of the DISTINCT keyword in a SELECT statement?$

A.

To remove duplicate values from the result set

B.

To filter null values

C.

To limit results

D.

To sort results

34 $Which of the following is a correct command to add a new column 'age' of type integer to table 'people'?$

A.

INSERT COLUMN age INTEGER INTO people;

B.

ALTER TABLE people ADD COLUMN age INTEGER;

C.

UPDATE TABLE people ADD age INTEGER;

D.

ALTER people ADD age INTEGER;

35 $What does the psql command '\d table_name' do?$

A.

Downloads the table

B.

Describes the table structure

C.

Deletes the table

D.

Duplicates the table

36 $Which logical operator is used to display a record if any of the conditions separated by it are true?$

A.

AND

B.

XOR

C.

NOT

D.

OR

37 $How do you check for a NULL value in a WHERE clause?$

A.

IS NULL

B.

== NULL

C.

EQUALS NULL

D.

= NULL

38 $Which PostgreSQL tool is a popular open-source GUI for database management?$

A.

Workbench

B.

phpMyAdmin

C.

Compass

D.

pgAdmin

39 $What does the PRIMARY KEY constraint imply?$

A.

NOT NULL only

B.

Both UNIQUE and NOT NULL

C.

UNIQUE only

D.

Just an index

40 $Which command allows you to quit the psql terminal?$

A.

logout

B.

exit

C.

quit

D.

\q

41 $Which clause is used to filter groups of rows created by GROUP BY?$

A.

LIMIT

B.

WHERE

C.

FILTER

D.

HAVING

42 $Which statement is used to delete an entire database?$

A.

TRUNCATE DATABASE name;

B.

DROP DATABASE name;

C.

REMOVE DATABASE name;

D.

DELETE DATABASE name;

43 $What is the purpose of the 'IN' operator?$

A.

To check for NULL

B.

To search text patterns

C.

To specify a range

D.

To specify multiple possible values for a column

44 $Which data type would be most appropriate for a True/False value?$

A.

VARCHAR(1)

B.

BOOLEAN

C.

INT

D.

BINARY

45 $What does the BETWEEN operator select?$

A.

Values within a given range

B.

Values that are null

C.

Values that match a list

D.

Values that are distinct

46 $To create a foreign key, which table is modified?$

A.

The child table

B.

The parent table

C.

Both tables

D.

The system table

47 $Which command is used to remove a specific column from a table?$

A.

ALTER TABLE ... REMOVE COLUMN ...

B.

ALTER TABLE ... DELETE COLUMN ...

C.

DROP COLUMN ... FROM ...

D.

ALTER TABLE ... DROP COLUMN ...

48 $Which basic SQL command is NOT part of CRUD operations?$

A.

SELECT

B.

CREATE

C.

UPDATE

D.

INSERT

49 $What is the default sort order if ASC or DESC is not specified in ORDER BY?$

A.

Random

B.

Descending

C.

Insertion Order

D.

Ascending

50 $Which character is used to denote a parameter/variable placeholder in a prepared statement in psql (e.g., $1, $2)?$

A.

$

B.

?

C.

@

D.

:

Unit 5 - Practice Quiz