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 49 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
YES! Correct, THANKS for helping me on my review

Sarahjh

  • Member
  • Posts: 370
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

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.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Republican candidates John McCain and Sarah Palin campaign at Franklin & Marshall University in Republican candidates John McCain and Sarah Palin campaign at Franklin & Marshall University in
Ten Leading Causes of Death in Low-Income Countries, 2008 Ten Leading Causes of Death in Low-Income Countries, 2008
Incidence of acute hepatitis B in the United States, 1980–2008. Incidence of acute hepatitis B in the United States, 1980–2008.
Enzymatic rate enhancements Enzymatic rate enhancements
Share of Hours Worked by Education Level, 1940–2008 Share of Hours Worked by Education Level, 1940–2008
GDP per Capita by Country Group, 1820–2008 GDP per Capita by Country Group, 1820–2008
Video: Factors that affect conduction rates (myelination, axon diameter & temperature)

For a complete list of videos, visit our video library