DBMS endterm

Select incorrect statement about the following SQL statement

CREATE OR REPLACE VIEW sales_view

AS SELECT * FROM sales_table ORDER BY sales_date DESC

LIMIT 10

• Replaces "sales_view" if it already exists

• Some errors occur when "SELECT * FROM sales_table" is executed after the view is defined

• When you 'SELECT' the "sales_view", it displays the first 10 records from the "sales_table" sorted by the "sales_date" in desc order

• Defines the view called "sales_view"

• An error occurs when executing the (2) SQL statement

• An error occurs when executing the (4) SQL statement

• No error is generated

• An error occurs when executing the (1) SQL statement

• An error occurs when executing the (3) SQL statement

Based on the relationship of columns within a table, select the most suitable description that shows that column A is dependent on the column B

• The value in column A is uniquely determined when a value in column B is selected

• As long as column B exists, the amount of the information won't decrease even if column A is deleted

• When the value in column B is changed, the corresponding value of column A also must be changed

• The value in column B is uniquely determined when a value in column A is selected

• When the value in column A is changed, the corresponding value of column B also must be changed

You can use aggregate functions as expressions only in the following clauses

• LIMIT and DISTINCT clauses

• SELECT and HAVING clauses

• CREATE and DELETE clauses

• GROUP BY and JOIN clauses

• WHERE and ORDER BY clauses

PostgreSQL evaluates the GROUP BY clause after...

• the FROM and WHERE clause

• the LIMIT clause

• the ORDER BY clause

• the HAVING clause

• the SELECT clause

This operator removes all duplicate rows from the combined data set

• SELECT

• UNION ALL

• INTERSECT

• UNION

• EXCEPT

• NAND

• UNION ALL

• INTERSECT

• UNION

• EXCEPT

What is a grouping set ?

• a set of indexes by which you group by using the GROUP BY clause

• a set of rows by which you group by using the GROUP BY clause

• a set of operators by which you group by using the GROUP BY clause

• a set of views by which you group by using the GROUP BY clause

• a set of columns by which you group by using the GROUP BY clause

The RANK() function...

• returns a value evaluated against the first row within its partition

• assigns ranking within an ordered partition. If rows have the same value, the function assigns the same rank, with the next ranking(s) skipped

• assigns a sequential to each row in each partition

• returns a value evaluated against the last row in its partition

• assigns a rank to each row within an ordered partition, but the ranks have no gap. In other words, the same ranks are assigned o multiple rows and now ranks are skipped

Which of the following are NOT a property of database transactions? Choose all that apply

• Atomicity

• Durability

• Consistency

• Insulation