Test Your PostgreSQL Data Types Knowledge with This Quiz

Progress

True / False

In PostgreSQL, the INTEGER data type can store both positive and negative whole numbers.

True False

The INTEGER data type in PostgreSQL is a 4-byte integer that can store values ranging from -2147483648 to 2147483647.

True / False

PostgreSQL's CHAR data type is used for fixed-length character strings.

True False

The CHAR data type in PostgreSQL is used for fixed-length character strings, meaning that the storage size is determined by the defined length and it pads the string with spaces if the input is shorter.

True / False

The BOOLEAN data type in PostgreSQL can store the values TRUE, FALSE, and NULL.

True False

The BOOLEAN data type in PostgreSQL can store TRUE, FALSE, and NULL, representing true, false, and unknown states, respectively.

True / False

PostgreSQL's NUMERIC data type is used for storing exact numeric values and allows specifying precision and scale.

True False

The NUMERIC (or DECIMAL) data type in PostgreSQL is used for storing exact numeric values, and you can specify both precision (total number of digits) and scale (number of digits to the right of the decimal point).

True / False

In PostgreSQL, the TIMESTAMP data type can only store date and time without timezone information.

True False

PostgreSQL offers two types of TIMESTAMP data types: TIMESTAMP WITHOUT TIME ZONE and TIMESTAMP WITH TIME ZONE. The latter includes timezone information.

True / False

The UUID data type in PostgreSQL is a 128-bit identifier used for unique identification across tables and databases.

True False

The UUID (Universally Unique Identifier) data type in PostgreSQL is a 128-bit identifier that is used to uniquely identify information without relying on sequences or other methods.

True / False

PostgreSQL supports the ARRAY data type, allowing the storage of arrays of any built-in or user-defined base type.

True False

PostgreSQL supports the ARRAY data type, which allows the creation and storage of arrays for any built-in or user-defined base type.

True / False

In PostgreSQL, the JSON data type is only used for storing JSON objects, not arrays.

True False

The JSON data type in PostgreSQL can store both JSON objects and JSON arrays, allowing for versatile JSON data handling.

True / False

The HSTORE data type in PostgreSQL is used for storing sets of key-value pairs within a single PostgreSQL value.

True False

The HSTORE data type in PostgreSQL is designed to store sets of key-value pairs within a single PostgreSQL value, useful for semi-structured data.

Q10

True / False

In PostgreSQL, the CIDR data type is used for storing IPv4 and IPv6 networks.

True False

The CIDR (Classless Inter-Domain Routing) data type in PostgreSQL is used for storing both IPv4 and IPv6 networks, providing a way to represent network addresses and their subnet masks.

Q11

Single Choice

Which MySQL data type is best suited for storing true/false values?

TINYINT BOOLEAN BITENUM

MySQL supports the BOOLEAN data type, which is an alias for TINYINT(1), typically used to store true (1) or false (0) values.

Q12

Single Choice

Which MySQL data type would you use to store a fixed-length string?

CHAR VARCHAR TEXTBLOB

The CHAR data type is used for storing fixed-length strings, whereas VARCHAR is used for variable-length strings.

Q13

Single Choice

Given the SQL statement below, what is the maximum length of the username column?

SQL Code

CREATE TABLE users (
 username VARCHAR(50)
);

50 characters 255 characters 50 bytes255 bytes

The VARCHAR(50) data type specifies that the username column can store up to 50 characters, not bytes.

Q14

Single Choice

What is the difference between TEXT and BLOB data types in MySQL?

TEXT is for character data, BLOB is for binary data BLOB is for character data, TEXT is for binary data Both are used for character dataBoth are used for binary data

In MySQL, TEXT stores character data, while BLOB stores binary data.

Q15

Single Choice

What MySQL data type would you use to store large integers greater than BIGINT?

MEDIUMINT BIGINT UNSIGNED BIGINTDECIMAL

The DECIMAL data type is used to store large integers or floating-point numbers with a high level of precision.

Q16

Single Choice

Given the following SQL statement, what is the purpose of DECIMAL(10, 2)?

SQL Code

CREATE TABLE orders (
 price DECIMAL(10, 2)
);

Stores a number with up to 10 digits, 2 of which are decimals Stores a number with up to 10 digits, no decimals Stores a number with up to 8 digits, 2 of which are decimalsStores a number with exactly 10 digits, 2 of which are decimals

DECIMAL(10, 2) specifies a numeric value that can have up to 10 digits in total, with 2 digits after the decimal point.

Q17

Single Choice

What MySQL data type would you use to store date and time, with fractional seconds up to microseconds?

DATE TIMESTAMP DATETIMEDATETIME(6)

The DATETIME(6) data type stores date and time with fractional seconds precision up to 6 digits (microseconds).

Q18

Single Choice

Given the SQL statement below, what is the maximum value that can be stored in the age column?

SQL Code

CREATE TABLE person (
 age TINYINT UNSIGNED
);

127 255 128256

TINYINT stores values from -128 to 127. When unsigned (UNSIGNED), it stores values from 0 to 255.

Q19

Single Choice

Which MySQL data type should be used for a column that stores IP addresses in the most optimized way?

VARCHAR(15) INET6 BINARY(16)VARBINARY(16)

BINARY(16) is used to store IPv6 addresses in a compact, optimized way, while VARBINARY would be variable in length.

Q20

Single Choice

Which MySQL data type is best suited for storing geographic coordinates such as latitude and longitude?

FLOAT DOUBLE GEOMETRYDECIMAL

The GEOMETRY data type is designed for storing spatial data, including geographic coordinates like latitude and longitude.

Q21

Multiple Choice

Which SQL command defines a column with a VARCHAR data type in PostgreSQL?

SQL Code

CREATE TABLE customers (
 customer_id SERIAL PRIMARY KEY,
 customer_name VARCHAR(100) NOT NULL
);

CREATE TABLE customers ( customer_id SERIAL PRIMARY KEY, customer_name VARCHAR(100) NOT NULL ); CREATE TABLE customers ( customer_id SERIAL PRIMARY KEY, customer_name TEXT NOT NULL ); CREATE TABLE customers ( customer_id SERIAL PRIMARY KEY, customer_name CHAR(100) NOT NULL );CREATE TABLE customers ( customer_id SERIAL PRIMARY KEY, customer_name VARCHAR(255) NOT NULL );

This command creates a 'customers' table with a 'customer_name' column defined as VARCHAR, allowing up to 100 characters.

Q22

Multiple Choice

Which SQL command defines a column with a NUMERIC data type in PostgreSQL?

SQL Code

CREATE TABLE transactions (
 transaction_id SERIAL PRIMARY KEY,
 amount NUMERIC(10, 2) NOT NULL
);

CREATE TABLE transactions ( transaction_id SERIAL PRIMARY KEY, amount NUMERIC(10, 2) NOT NULL ); CREATE TABLE transactions ( transaction_id SERIAL PRIMARY KEY, amount DECIMAL(10, 2) NOT NULL ); CREATE TABLE transactions ( transaction_id SERIAL PRIMARY KEY, amount MONEY NOT NULL );CREATE TABLE transactions ( transaction_id SERIAL PRIMARY KEY, amount INTEGER NOT NULL );

This command creates a 'transactions' table where the 'amount' column is defined as NUMERIC, allowing for precise storage of numbers with two decimal places.

Q23

Multiple Choice

Which SQL command correctly defines a DATE data type column in PostgreSQL?

SQL Code

CREATE TABLE events (
 event_id SERIAL PRIMARY KEY,
 event_date DATE NOT NULL
);

CREATE TABLE events ( event_id SERIAL PRIMARY KEY, event_date DATE NOT NULL ); CREATE TABLE events ( event_id SERIAL PRIMARY KEY, event_date TIMESTAMP NOT NULL ); CREATE TABLE events ( event_id SERIAL PRIMARY KEY, event_date DATETIME NOT NULL );CREATE TABLE events ( event_id SERIAL PRIMARY KEY, event_date TIMESTAMP WITH TIME ZONE NOT NULL );

This command creates an 'events' table where the 'event_date' column is defined as DATE, storing calendar dates without time information.

Q24

Multiple Choice

Which SQL command defines a JSONB column in PostgreSQL?

SQL Code

CREATE TABLE logs (
 log_id SERIAL PRIMARY KEY,
 log_data JSONB NOT NULL
);

CREATE TABLE logs ( log_id SERIAL PRIMARY KEY, log_data JSONB NOT NULL ); CREATE TABLE logs ( log_id SERIAL PRIMARY KEY, log_data JSON NOT NULL ); CREATE TABLE logs ( log_id SERIAL PRIMARY KEY, log_data TEXT NOT NULL );CREATE TABLE logs ( log_id SERIAL PRIMARY KEY, log_data VARCHAR NOT NULL );

This command creates a 'logs' table where the 'log_data' column is defined as JSONB, storing JSON data in a binary format for efficient access.

Q25

Multiple Choice

Which SQL command defines a BOOLEAN data type column in PostgreSQL?

SQL Code

CREATE TABLE tasks (
 task_id SERIAL PRIMARY KEY,
 task_name VARCHAR(100) NOT NULL,
 completed BOOLEAN NOT NULL
);

CREATE TABLE tasks ( task_id SERIAL PRIMARY KEY, task_name VARCHAR(100) NOT NULL, completed BOOLEAN NOT NULL ); CREATE TABLE tasks ( task_id SERIAL PRIMARY KEY, task_name VARCHAR(100) NOT NULL, completed BIT NOT NULL ); CREATE TABLE tasks ( task_id SERIAL PRIMARY KEY, task_name VARCHAR(100) NOT NULL, completed CHAR(1) NOT NULL );CREATE TABLE tasks ( task_id SERIAL PRIMARY KEY, task_name VARCHAR(100) NOT NULL, completed TINYINT NOT NULL );

This command creates a 'tasks' table where the 'completed' column is defined as BOOLEAN, allowing only true or false values.

Q26

Multiple Choice

Which SQL command defines an ARRAY data type column in PostgreSQL?

SQL Code

CREATE TABLE orders (
 order_id SERIAL PRIMARY KEY,
 product_ids INT[] NOT NULL
);

CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, product_ids INT[] NOT NULL ); CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, product_ids ARRAY NOT NULL ); CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, product_ids INTEGER[] NOT NULL );CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, product_ids VARCHAR(100) NOT NULL );

This command creates an 'orders' table where the 'product_ids' column is defined as an ARRAY of integers, allowing storage of multiple product IDs in a single field.

Q27

Multiple Choice

Which SQL command defines a column using the ENUM data type in PostgreSQL?

SQL Code

CREATE TYPE status_enum AS ENUM ('pending', 'shipped', 'delivered');
CREATE TABLE orders (
 order_id SERIAL PRIMARY KEY,
 order_status status_enum NOT NULL
);

CREATE TYPE status_enum AS ENUM ('pending', 'shipped', 'delivered'); CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, order_status status_enum NOT NULL ); CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, order_status ENUM ('pending', 'shipped', 'delivered') NOT NULL ); CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, order_status VARCHAR(20) NOT NULL );CREATE TABLE orders ( order_id SERIAL PRIMARY KEY, order_status CHAR(10) NOT NULL );

This command creates a custom ENUM type 'status_enum' and then defines the 'order_status' column in the 'orders' table to use this ENUM type, restricting the column to specific values.

Q28

Multiple Choice

Which SQL command defines a column with a UUID data type in PostgreSQL?

SQL Code

CREATE TABLE devices (
 device_id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
 device_name VARCHAR(100) NOT NULL
);

CREATE TABLE devices ( device_id UUID PRIMARY KEY DEFAULT gen_random_uuid(), device_name VARCHAR(100) NOT NULL ); CREATE TABLE devices ( device_id SERIAL PRIMARY KEY, device_name VARCHAR(100) NOT NULL ); CREATE TABLE devices ( device_id UUID PRIMARY KEY, device_name VARCHAR(100) NOT NULL );CREATE TABLE devices ( device_id CHAR(36) PRIMARY KEY, device_name VARCHAR(100) NOT NULL );

This command creates a 'devices' table where the 'device_id' column is defined as a UUID, providing a globally unique identifier for each row.

Q29

Multiple Choice

Which SQL command defines a column with a TIMESTAMP data type in PostgreSQL?

SQL Code

CREATE TABLE audit_logs (
 log_id SERIAL PRIMARY KEY,
 log_timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 log_details TEXT NOT NULL
);

CREATE TABLE audit_logs ( log_id SERIAL PRIMARY KEY, log_timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, log_details TEXT NOT NULL ); CREATE TABLE audit_logs ( log_id SERIAL PRIMARY KEY, log_timestamp TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, log_details TEXT NOT NULL ); CREATE TABLE audit_logs ( log_id SERIAL PRIMARY KEY, log_timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, log_details TEXT NOT NULL );CREATE TABLE audit_logs ( log_id SERIAL PRIMARY KEY, log_timestamp TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP, log_details TEXT NOT NULL );

This command creates an 'audit_logs' table where the 'log_timestamp' column is defined as TIMESTAMP, storing both date and time information.

Q30

Multiple Choice

Which SQL command defines a column using the BYTEA data type in PostgreSQL?

SQL Code

CREATE TABLE files (
 file_id SERIAL PRIMARY KEY,
 file_name VARCHAR(255) NOT NULL,
 file_data BYTEA NOT NULL
);

CREATE TABLE files ( file_id SERIAL PRIMARY KEY, file_name VARCHAR(255) NOT NULL, file_data BYTEA NOT NULL ); CREATE TABLE files ( file_id SERIAL PRIMARY KEY, file_name VARCHAR(255) NOT NULL, file_data BLOB NOT NULL ); CREATE TABLE files ( file_id SERIAL PRIMARY KEY, file_name VARCHAR(255) NOT NULL, file_data BINARY NOT NULL );CREATE TABLE files ( file_id SERIAL PRIMARY KEY, file_name VARCHAR(255) NOT NULL, file_data LONGBLOB NOT NULL );

This command creates a 'files' table where the 'file_data' column is defined as BYTEA, allowing storage of binary data like files.

PostgreSQL Database Quiz Questions