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

A.

Hierarchical Database

B.

Object-Relational Database Management System (ORDBMS)

C.

Flat File Database

D.

Network Database

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

A.

MVCC (Multi-Version Concurrency Control)

B.

Table Locking

C.

Two-Phase Locking

D.

Optimistic Locking

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

A.

3306

B.

5432

C.

1521

D.

8080

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

A.

psql

B.

pg_terminal

C.

sqlcmd

D.

pgAdmin

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

A.

pg_ident.conf

B.

pg_hba.conf

C.

config.json

D.

postgresql.conf

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

A.

sa

B.

postgres

C.

root

D.

admin

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

A.

Both A and B

B.

\l

C.

\list

D.

SHOW DATABASES;

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

A.

JSONB

B.

VARCHAR

C.

TEXT

D.

JSON

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

A.

CREATE DATABASE name;

B.

MAKE DATABASE name;

C.

INIT DATABASE name;

D.

NEW DATABASE name;

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

A.

Write-After Log

B.

Wide-Area Latency

C.

Write-Ahead Logging

D.

Web Application Layer

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

A.

\connect dbname

B.

\c dbname

C.

Both A and B

D.

\use dbname

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

A.

REMOVE TABLE

B.

DROP TABLE

C.

ERASE TABLE

D.

DELETE TABLE

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

A.

AUTO_INT

B.

SERIAL

C.

NUMERIC

D.

INT

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

A.

To minify the database size

B.

To delete specific rows based on a condition

C.

To delete all rows quickly without logging individual row deletions

D.

To drop the table structure

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

A.

NOT NULL

B.

CHECK

C.

PRIMARY KEY

D.

UNIQUE

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

A.

ALTER TABLE users RENAME TO customers;

B.

MODIFY TABLE users RENAME customers;

C.

UPDATE TABLE users SET NAME = customers;

D.

RENAME TABLE users TO customers;

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

A.

SAME

B.

=

C.

LIKE

D.

MATCH

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

A.

A numeric digit

B.

Exactly one character

C.

Zero or more characters

D.

A NULL value

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

A.

GROUP BY

B.

ORDER BY

C.

HAVING

D.

WHERE

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

A.

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

B.

UPDATE students ADD (1, 'John');

C.

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

D.

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

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

A.

GET * FROM employees;

B.

SELECT ALL FROM employees;

C.

SELECT * FROM employees;

D.

FETCH employees;

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

A.

STOP

B.

TOP

C.

LIMIT

D.

ROWNUM

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

A.

OFFSET

B.

JUMP

C.

NEXT

D.

SKIP

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.

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

C.

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

D.

CHANGE 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 first row.

C.

It deletes the table structure.

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.

OUTPUT

B.

RETURN

C.

RETURNING

D.

BACK

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

A.

DATETIME

B.

DATE

C.

TIMESTAMP

D.

TIME

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.

DISTINCT

B.

PRIMARY

C.

SINGLE

D.

UNIQUE

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

A.

CONCAT()

B.

||

C.

&

D.

+

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

A.

SORT BY column_name DESC

B.

GROUP BY column_name DESC

C.

ORDER BY column_name ASC

D.

ORDER BY column_name DESC

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

A.

TOTAL()

B.

SUM()

C.

COUNT()

D.

ADD()

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

A.

To limit results

B.

To remove duplicate values from the result set

C.

To sort results

D.

To filter null values

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

A.

ALTER TABLE people ADD COLUMN age INTEGER;

B.

UPDATE TABLE people ADD age INTEGER;

C.

INSERT COLUMN age INTEGER INTO people;

D.

ALTER people ADD age INTEGER;

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

A.

Describes the table structure

B.

Deletes the table

C.

Downloads 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.

XOR

B.

AND

C.

NOT

D.

OR

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

A.

IS NULL

B.

EQUALS NULL

C.

== NULL

D.

= NULL

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

A.

phpMyAdmin

B.

pgAdmin

C.

Compass

D.

Workbench

39 $What does the PRIMARY KEY constraint imply?$

A.

UNIQUE only

B.

NOT NULL only

C.

Both UNIQUE and NOT NULL

D.

Just an index

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

A.

\q

B.

exit

C.

quit

D.

logout

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

A.

FILTER

B.

LIMIT

C.

WHERE

D.

HAVING

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

A.

REMOVE DATABASE name;

B.

TRUNCATE DATABASE name;

C.

DROP DATABASE name;

D.

DELETE DATABASE name;

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

A.

To specify multiple possible values for a column

B.

To specify a range

C.

To check for NULL

D.

To search text patterns

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

A.

INT

B.

VARCHAR(1)

C.

BINARY

D.

BOOLEAN

45 $What does the BETWEEN operator select?$

A.

Values within a given range

B.

Values that match a list

C.

Values that are distinct

D.

Values that are null

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

A.

The child table

B.

Both tables

C.

The parent table

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 ... DROP COLUMN ...

C.

DROP COLUMN ... FROM ...

D.

ALTER TABLE ... DELETE COLUMN ...

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

A.

SELECT

B.

UPDATE

C.

CREATE

D.

INSERT

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

A.

Ascending

B.

Random

C.

Insertion Order

D.

Descending

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