PostgreSQL & PostGIS Quiz

What is the role of a DBMS in a database system?

• It manages spatial data only

• It performs arithmetic operations

• It stores, retrieves, and manages data

• It converts data to binary

Which architecture type involves a middle layer between client and server?

• Two-Tier

• One-Tier

• Three-Tier

• Serverless

Which constraint ensures that a column cannot have NULL values?

• PRIMARY KEY

• UNIQUE

• DEFAULT

• NOT NULL

What does the \l command do in psql shell?

• Lists all tables

• Lists all databases

• Lists all users

• Lists all constraints

Which SQL keyword is used to remove all records but not the structure of a table?

• DELETE

• DROP

• TRUNCATE

• REMOVE

Which operator is used to test if a column is NOT equal to a value?

• !=

• <>

• BOTH A and B

• =

Which data type is used to store large binary data?

• VARCHAR

• INT

• TEXT

Which clause is used to sort query results?

• WHERE

• ORDER BY

• GROUP BY

• HAVING

Which aggregate function returns the average value of a numeric column?

• SUM()

• COUNT()

• AVG()

• MIN()

What does the LIKE 'A%' pattern search for?

• Names that contain 'A' anywhere

• Names that end with 'A'

• Names that start with 'A'

• Names that equal 'A'