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 19 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
Thanks for the timely response, appreciate it

helenmarkerine

  • Member
  • Posts: 324
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Medication errors are three times higher among children and infants than with adults.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Telomere length is related to the amount of time adults spend in leisure time activity. Source: Ada Telomere length is related to the amount of time adults spend in leisure time activity. Source: Ada
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.
Incidence of acute hepatitis B in the United States, 1980–2008. Incidence of acute hepatitis B in the United States, 1980–2008.
Sulfur Dioxide (SO2) Trend, 1970 - 2008 Sulfur Dioxide (SO2) Trend, 1970 - 2008
Nargis struck the Irrawaddy Delta in 2008 Nargis struck the Irrawaddy Delta in 2008
Fraction of obese individuals by state in 1998 and 2008. In 1998, 42 states had obesity rates below Fraction of obese individuals by state in 1998 and 2008. In 1998, 42 states had obesity rates below
Video: What are Strong & Weak Acids and How they're different?

For a complete list of videos, visit our video library