What is the main purpose of RETURNING in PostgreSQL?INSERT INTO categories (category_name)VALUES (‘Snacks’)RETURNING category_id;

In a well-formed relation, which rule is required?

In an E-R model, an attribute is:

What happens if this statement is run?INSERT INTO products (category_id, product_name, unit_price, quantity_in_stock)VALUES (1, ‘Invalid Item’, 2.00, -5);

What does the following SQL statement do?CREATE TABLE departments ( department_id INTEGER PRIMARY KEY, department_name TEXT NOT NULL);

Which situation is most likely to cause an update anomaly in a single spreadsheet-style list?

The order in which rows appear in a relational table is part of the data’s meaning.

Which SQL statement category includes SELECT, INSERT, UPDATE, and DELETE?

In the relation EMPLOYEE(EmployeeNumber, FirstName, LastName, Department), which statement about Department is correct if it references DEPARTMENT(DepartmentName)?

What is the benefit of explicitly listing columns in an INSERT statement?INSERT INTO customers (first_name, last_name, email)VALUES (‘Ava’, ‘Brown’, ‘ava@example.com’);