This topic contains a solution. Click here to go to the answer
« previous next »

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

madam-professor

  • Hero Member
  • *****
  • Posts: 584
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


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

lgoldst9

  • Sr. Member
  • ****
  • Posts: 372
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


madam-professor

  • Member
  • Posts: 584
Reply 2 on: Jul 7, 2018
:D TYSM

xthemafja

  • Member
  • Posts: 348
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Vampire bats have a natural anticoagulant in their saliva that permits continuous bleeding after they painlessly open a wound with their incisors. This capillary blood does not cause any significant blood loss to their victims.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

2008 launch of the SM-3 missile used to destroy American spy satellite USA-193 2008 launch of the SM-3 missile used to destroy American spy satellite USA-193
In 2008, the U.S. economy suffered a gaping wound as several trillion dollars were ripped out of it. In 2008, the U.S. economy suffered a gaping wound as several trillion dollars were ripped out of it.
A view from underneath a Chevrolet pickup truck showing how the pad extensions are used to attach ... A view from underneath a Chevrolet pickup truck showing how the pad extensions are used to attach ...
Enzymatic rate enhancements Enzymatic rate enhancements
Daily Calorie Intake from Sugar Drinks, United States, 2005–2008 Daily Calorie Intake from Sugar Drinks, United States, 2005–2008
Total Fertility Rate in the United States, 1860–2008 Total Fertility Rate in the United States, 1860–2008
Video: Methods that regulate pH

For a complete list of videos, visit our video library