Author Question: Discuss some of the SQL:2008 enhancements and extensions to SQL. What will be an ideal ... (Read 55 times)

madam-professor · **on:** Jul 7, 2018

Discuss some of the SQL:2008 enhancements and extensions to SQL.

What will be an ideal response?

Question 2

Successful attacks are commonly called ________.

A) security incidents
B) countermeasures
C) Both A and B
D) Neither A nor B

lgoldst9 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Several built-in functions were added in SQL:2008. These include ceiling, floor, SQRT, rank, dense_rank, rollup, cube, sample and window. Many operations, such as OLAP operations, can be done within the SQL SELECT statement. There were also three new data types: BIGINT, MULTISET and XML. In addition, the merge operation was added.

Answer to Question 2

Answer: A