Crowdly

What is a SQL View?

A group of related tables that are linked together

A query that retrieves and displays data from one or more tables

A stored procedure that performs a set of operations on data

A physical table that stores data

What is the correct syntax for deleting records from table_name with a specific condition in PostgreSQL?

DELETE WHERE condition SET column = value;

DELETE FROM table_name WHERE condition;

DELETE WHERE condition from table_name;

DELETE SET column = value WHERE condition;

Suppose you have a table named sales with columns id, product_name, quantity, and price. You want to update the column total_price by multiplying the quantity and price columns. Which SQL statement will achieve this?

UPDATE FROM sales SET total_price = (quantity * price);

UPDATE TABLE sales SET total_price = quantity * price;

UPDATE sales SET total_price = quantity - price;

UPDATE sales SET total_price = quantity * price;

SELECT column1, column2, SUM(column3) AS total

How can you insert the result of a SELECT query with a GROUP BY clause and an ORDER BY the sum in descending order into a new table in PostgreSQL?

INSERT INTO new_table (column1, column2, total)

SELECT column1, column2, SUM(column3)

ORDER BY total DESC;

INSERT INTO new_table

SELECT column1, column2, SUM(column3)

ORDER BY column3 ASC;

INSERT INTO new_table

SELECT column1, column2, AVG(column3)

ORDER BY column3 DESC;

INSERT INTO new_table

SELECT column1, column2, SUM(column3)

ORDER BY column3 ASC;

INSERT INTO new_table (column1, column2, total)

ORDER BY SUM(column3) DESC;

How to insert records into a table using a nested subquery and the ANY operator in PostgreSQL?

INSERT INTO table1 (col1, col2)

WHERE col3 NOT ANY (SELECT col3 FROM table3);

INSERT INTO table1 (col1, col2)

WHERE col3 IN (SELECT col3 FROM table3);

INSERT INTO table1 (col1, col2)

WHERE col3 = (SELECT col3 FROM table3);

INSERT INTO table1 (col1, col2)

WHERE col3 = ANY (SELECT col3 FROM table3);

SELECT column1, column2, column3

What is the correct syntax to insert a query result into another table and sort the result by a specific column in descending order?

INSERT INTO new_table (column1, column2)

SELECT column1, column2

FROM original_table;

INSERT INTO new_table (column1, column2, column3)

ORDER BY column3 DESC;

INSERT INTO new_table

SET = SELECT *

ORDER BY column3 DESC

INSERT INTO new_table

SELECT *

ORDER BY column3 DESC;

Which of the following is the correct syntax for inserting the result of a query into another table in PostgreSQL?

INSERT INTO table_2 (column_1, column_2, column_3)

INSERT SELECT column_1, column_2, column_3

FROM table_1

SELECT column_1, column_2, column_3

INSERT INTO table_2 (column_1, column_2, column_3)

FROM table_1

SET column_1, column_2, column_3 =

INSERT INTO table_2 (column_1, column_2, column_3)

SELECT column_1, column_2, column_3

FROM table_1

INSERT INTO table_2 (column_1, column_2, column_3)

SELECT FROM table_1

What is the correct syntax to insert a NULL value in a PostgreSQL table?

INSERT INTO table_name (column1) VALUES (NOT NULL);

INSERT INTO table_name (column1) VALUES ('NOT NULL');

INSERT INTO table_name (column1) VALUES ('NULL');

INSERT INTO table_name (column1) VALUES (NULL);

VALUES (1, 'John Doe', '[email protected]');

What is the correct syntax to insert a new row into a table named users with columns id, name, email?

INSERT INTO (id, name, email)

SET id=1, name='John Doe', email='[email protected]';

INSERT INTO users

VALUES (1, 'John Doe', '[email protected]');

INSERT INTO users (id, name, email)

VALUES (1, 'John Doe', '[email protected]');

INSERT INTO table users (id, name, email)