Crowdly

Add to Chrome

Universities
softserve.academy
DataBase Fundamentals new

DataBase Fundamentals new

Looking for DataBase Fundamentals new test answers and solutions? Browse our comprehensive collection of verified answers for DataBase Fundamentals new at softserve.academy.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Which type of view combines data from one or more base tables (or views) into a new virtual table?

Partitioned views

Indexed views

Logical views

Standard views

View this question

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

View this question

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;

View this question

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;

View this question

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) AS total

FROM original_table

GROUP BY column1, column2

ORDER BY total DESC;

INSERT INTO new_table

SELECT column1, column2, SUM(column3)

FROM original_table

GROUP BY column1, column2

ORDER BY column3 ASC;

INSERT INTO new_table

SELECT column1, column2, SUM(column3)

FROM original_table

GROUP BY column1, column2

ORDER BY column3 DESC;

INSERT INTO new_table

SELECT column1, column2, AVG(column3)

FROM original_table

GROUP BY column1, column2

ORDER BY column3 ASC;

INSERT INTO new_table (column1, column2, total)

SELECT column1, column2, SUM(column3)

FROM original_table

GROUP BY column1, column2

ORDER BY SUM(column3) DESC;

View this question

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

INSERT INTO table1 (col1, col2)

SELECT col1, col2

WHERE col3 NOT ANY (SELECT col3 FROM table3);

INSERT INTO table1 (col1, col2)

SELECT col1, col2

WHERE col3 IN (SELECT col3 FROM table3);

INSERT INTO table1 (col1, col2)

SELECT col1, col2

WHERE col3 = (SELECT col3 FROM table3);

INSERT INTO table1 (col1, col2)

SELECT col1, col2

WHERE col3 = ANY (SELECT col3 FROM table3);

View this question

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)

SELECT column1, column2, column3

FROM original_table

ORDER BY column3 DESC;

INSERT INTO new_table

FROM original_table

ORDER BY column3 DESC

INSERT INTO new_table

FROM original_table

ORDER BY column3 DESC;

View this question

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

WHERE condition;

INSERT INTO table_2 (column_1, column_2, column_3)

SELECT column_1, column_2, column_3

WHERE condition;

INSERT INTO table_2 (column_1, column_2, column_3)

SET column_1, column_2, column_3 =

SELECT column_1, column_2, column_3

WHERE condition;

INSERT INTO table_2 (column_1, column_2, column_3)

SELECT FROM table_1

WHERE condition;

View this question

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);

View this question

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)

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

INSERT INTO users

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

INSERT INTO users (id, name, email)

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

INSERT INTO table users (id, name, email)

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

View this question

Previous
1
9
10
11
17
Next

Want instant access to all verified answers on softserve.academy?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us

Add to Chrome

Add to Chrome