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 13 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
Excellent

kilada

  • Member
  • Posts: 311
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

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

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

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.
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
What are examples of ideal forms? What are examples of ideal forms?
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 ...
Nargis struck the Irrawaddy Delta in 2008 Nargis struck the Irrawaddy Delta in 2008
Share of Hours Worked by Education Level, 1940–2008 Share of Hours Worked by Education Level, 1940–2008
Video: Glycolysis - Introduction to ATP and the burning of sugar

For a complete list of videos, visit our video library