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 42 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
Great answer, keep it coming :)

jomama

  • Member
  • Posts: 346
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

wild discuss fish wild discuss fish
President-elect Barack Obama, his daughters, and wife, Michelle, celebrate his victory in November 2 President-elect Barack Obama, his daughters, and wife, Michelle, celebrate his victory in November 2
A medical assistant listening to the patient and physician discuss the patient's care. A medical assistant listening to the patient and physician discuss the patient's care.
Tall pad extensions can also be used to gain access to the frame of a vehicle. This position is ... Tall pad extensions can also be used to gain access to the frame of a vehicle. This position is ...
Enzymatic rate enhancements Enzymatic rate enhancements
Sulfur Dioxide (SO2) Trend, 1970 - 2008 Sulfur Dioxide (SO2) Trend, 1970 - 2008
Video: Homologous chromosomes during prophase I - Animation

For a complete list of videos, visit our video library