Test Your PostgreSQL ROWs and COLUMNs Knowledge with This Quiz

Progress

True / False

In PostgreSQL, each row in a table must have a unique identifier.

True False

While it is common to have a unique identifier like a primary key for each row, it is not a strict requirement in PostgreSQL. However, having a unique identifier is a best practice for data integrity.

True / False

In PostgreSQL, the data type of a column can be defined when creating the table.

True False

When creating a table in PostgreSQL, you specify the data type for each column to define what kind of data it will hold, such as INTEGER, VARCHAR, DATE, etc.

True / False

In PostgreSQL, the NOT NULL constraint ensures that a column cannot have NULL values.

True False

The NOT NULL constraint in PostgreSQL ensures that a column must have a value and cannot be left empty or NULL.

True / False

PostgreSQL allows you to rename a column in an existing table using the ALTER TABLE statement.

True False

PostgreSQL provides the ALTER TABLE ... RENAME COLUMN ... TO ... command to rename columns in an existing table.

True / False

In PostgreSQL, the UNIQUE constraint allows duplicate values in the specified column.

True False

The UNIQUE constraint ensures that all values in a column are distinct, preventing duplicate values.

True / False

In PostgreSQL, you can define default values for columns in a table.

True False

PostgreSQL allows you to set default values for columns using the DEFAULT keyword, which will be used if no other value is provided during insertion.

True / False

PostgreSQL supports array data types, allowing a column to store multiple values in a single row.

True False

PostgreSQL supports array data types, enabling columns to store arrays of values, such as INTEGER[] or TEXT[].

True / False

In PostgreSQL, the ROW_NUMBER() window function can be used to assign unique sequential integer values to rows within a partition of a result set.

True False

The ROW_NUMBER() window function in PostgreSQL assigns a unique sequential integer to rows within a partition, providing a way to number rows.

True / False

PostgreSQL does not support the ability to store JSON data in table columns.

True False

PostgreSQL supports JSON and JSONB data types, allowing you to store and manipulate JSON data directly within table columns.

Q10

True / False

In PostgreSQL, the GENERATED ALWAYS AS IDENTITY clause can be used to create auto-incrementing columns.

True False

The GENERATED ALWAYS AS IDENTITY clause in PostgreSQL is used to define auto-incrementing columns, providing a standardized way to create sequence-generated unique identifiers.

Q11

Single Choice

Which MySQL keyword is used to retrieve all rows from a specific column in a table?

SELECT FETCH GETRETRIEVE

The SELECT keyword is used in MySQL to retrieve data from one or more columns in a table.

Q12

Single Choice

How do you return only distinct values in a specific column from a MySQL table?

UNIQUE DISTINCT DIFFERENTSELECT

The DISTINCT keyword is used to remove duplicate rows from the result set in MySQL, ensuring that each value in the selected column(s) is unique.

Q13

Single Choice

What does the following SQL query do?

SQL Code

SELECT column1, column2 FROM table_name;

Deletes all rows from table_name Selects and displays column1 and column2 from all rows in table_name Updates column1 and column2 in table_nameAdds a new column to table_name

The SELECT statement retrieves the specified columns (column1 and column2) from all rows in the table table_name.

Q14

Single Choice

Which MySQL clause would you use to filter rows that match specific criteria in a column?

WHERE FILTER CONDITIONCHECK

The WHERE clause is used to filter records and return only the rows that meet specified criteria

Q15

Single Choice

What will the following SQL query return?

SQL Code

SELECT COUNT(*) FROM employees WHERE department_id = 5;

The number of rows in the employees table The total number of departments The number of employees in department 5The sum of all salaries in department 5

The COUNT(*) function returns the number of rows that match the WHERE condition, which in this case is all employees in department 5

Q16

Single Choice

How can you add a new column email to an existing MySQL table users?

SQL Code

________ users ADD COLUMN email VARCHAR(255);

INSERT MODIFY TABLE UPDATE TABLEALTER TABLE

The ALTER TABLE command is used to add, delete, or modify columns in an existing table. In this case, it adds a new column email to the users table.

Q17

Single Choice

Which SQL statement will select all rows where the last_name column has a NULL value?

SQL Code

SELECT * FROM customers WHERE last_name ____ NULL;

= IS CONTAINEQUAL

In MySQL, the IS NULL condition is used to check for NULL values in a column.

Q18

Single Choice

What will the following query do if the users table contains 10 rows?

SQL Code

DELETE FROM users WHERE id > 5;

Deletes all rows from users Deletes the first 5 rows Deletes rows with id greater than 5Deletes the row with id equal to 5

The DELETE statement will remove all rows where the id value is greater than 5.

Q19

Single Choice

Given the following SQL query, what does the keyword ROW_NUMBER() do?

SQL Code

SELECT *, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rank FROM employees;

Calculates the total number of rows Assigns a unique rank to each row based on the salary in descending order Counts the number of rows with the same salaryOrders rows by the employee's rank

The ROW_NUMBER() function assigns a unique sequential integer to rows within a result set, based on the ordering specified in the OVER clause.

Q20

Single Choice

Which MySQL statement will update multiple columns in all rows where status is 'active'?

SQL Code

UPDATE orders SET quantity = quantity + 1, price = price * 1.1 WHERE status = 'active';

Increases the quantity and price for all rows Increases the quantity and price for rows where status is 'active' Updates the status to 'active' for all rowsUpdates the status to 'active' for specific rows

The UPDATE statement modifies the quantity and price columns for all rows where the status is 'active'.

Q21

Multiple Choice

Which SQL command would you use to retrieve specific columns from a PostgreSQL table?

SQL Code

SELECT first_name, last_name, email
FROM employees
WHERE department = 'HR';

SELECT first_name, last_name, email FROM employees WHERE department = 'HR'; SELECT * FROM employees WHERE department = 'HR'; SELECT first_name, last_name FROM employees;SELECT department FROM employees WHERE department = 'HR';

This query selects the 'first_name', 'last_name', and 'email' columns from the 'employees' table where the department is 'HR', a common operation when only specific columns are needed.

Q22

Multiple Choice

Which SQL statement correctly updates a specific row in a PostgreSQL table?

SQL Code

UPDATE orders
SET status = 'shipped'
WHERE order_id = 12345;

UPDATE orders SET status = 'shipped' WHERE order_id = 12345; UPDATE orders SET status = 'shipped' WHERE status = 'pending'; UPDATE orders SET status = 'shipped';UPDATE orders SET status = 'shipped' WHERE order_id > 10000;

This query updates the 'status' column of a specific row in the 'orders' table where 'order_id' is 12345, modifying the data stored in that row.

Q23

Multiple Choice

Which SQL command would you use to add a new row to a PostgreSQL table?

SQL Code

INSERT INTO customers (first_name, last_name, email)
VALUES ('Jane', 'Doe', 'jane.doe@example.com');

INSERT INTO customers (first_name, last_name, email) VALUES ('Jane', 'Doe', 'jane.doe@example.com'); INSERT INTO customers (first_name, last_name) VALUES ('Jane', 'Doe'); INSERT INTO customers VALUES ('Jane', 'Doe', 'jane.doe@example.com');INSERT INTO customers (email) VALUES ('jane.doe@example.com');

This query inserts a new row into the 'customers' table with specific values for the 'first_name', 'last_name', and 'email' columns, adding a new entry to the table.

Q24

Multiple Choice

Which SQL query retrieves the total number of rows in a PostgreSQL table?

SQL Code

SELECT COUNT(*)
FROM products;

SELECT COUNT(*) FROM products; SELECT COUNT(product_id) FROM products; SELECT * FROM products;SELECT COUNT(DISTINCT product_id) FROM products;

This query counts and returns the total number of rows in the 'products' table, which is useful for understanding the size of the table.

Q25

Multiple Choice

Which SQL command is used to modify a column's data type in a PostgreSQL table?

SQL Code

ALTER TABLE orders
ALTER COLUMN order_date TYPE TIMESTAMP;

ALTER TABLE orders ALTER COLUMN order_date TYPE TIMESTAMP; ALTER TABLE orders MODIFY order_date TIMESTAMP; ALTER TABLE orders CHANGE COLUMN order_date TIMESTAMP;ALTER TABLE orders ALTER order_date SET TYPE TIMESTAMP;

This command alters the 'order_date' column in the 'orders' table, changing its data type to TIMESTAMP, a common operation when modifying a table's schema.

Q26

Multiple Choice

Which SQL command removes specific rows from a PostgreSQL table based on a condition?

SQL Code

DELETE FROM employees
WHERE department = 'Sales';

DELETE FROM employees WHERE department = 'Sales'; DELETE FROM employees; DELETE department = 'Sales' FROM employees;DELETE FROM employees WHERE department != 'Sales';

This command deletes rows from the 'employees' table where the department is 'Sales', which is often used to clean up or manage data.

Q27

Multiple Choice

Which SQL query is used to retrieve distinct values from a column in a PostgreSQL table?

SQL Code

SELECT DISTINCT department
FROM employees;

SELECT DISTINCT department FROM employees; SELECT department FROM employees GROUP BY department; SELECT department FROM employees;SELECT UNIQUE department FROM employees;

This query selects distinct values from the 'department' column in the 'employees' table, which is useful for identifying unique entries.

Q28

Multiple Choice

Which SQL command adds a check constraint to ensure that a column's value is positive in PostgreSQL?

SQL Code

ALTER TABLE products
ADD CONSTRAINT chk_price
CHECK (price > 0);

ALTER TABLE products ADD CONSTRAINT chk_price CHECK (price > 0); ALTER TABLE products ADD CHECK (price > 0); ALTER products ADD CONSTRAINT chk_price CHECK (price > 0);ALTER TABLE products ADD CONSTRAINT CHECK (price > 0);

This command adds a check constraint to the 'products' table, ensuring that the 'price' column always contains positive values.

Q29

Multiple Choice

Which SQL query correctly retrieves rows that have NULL values in a specific column in PostgreSQL?

SQL Code

SELECT * FROM orders
WHERE delivery_date IS NULL;

SELECT * FROM orders WHERE delivery_date IS NULL; SELECT * FROM orders WHERE delivery_date = NULL; SELECT * FROM orders WHERE delivery_date IS NOT NULL;SELECT * FROM orders WHERE delivery_date != NULL;

This query retrieves rows from the 'orders' table where the 'delivery_date' column contains NULL values, which is useful for identifying incomplete or missing data.

Q30

Multiple Choice

Which SQL command is used to rename a column in a PostgreSQL table?

SQL Code

ALTER TABLE customers
RENAME COLUMN full_name TO name;

ALTER TABLE customers RENAME COLUMN full_name TO name; ALTER TABLE customers CHANGE COLUMN full_name TO name; ALTER TABLE customers MODIFY COLUMN full_name TO name;ALTER customers RENAME full_name TO name;

This command renames the 'full_name' column to 'name' in the 'customers' table, a common task when modifying the structure of a table.

PostgreSQL Database Quiz Questions