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 50 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
Wow, this really help

nguyenhoanhat

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

« previous next »
 

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

Chronic marijuana use can damage the white blood cells and reduce the immune system's ability to respond to disease by as much as 40%. Without a strong immune system, the body is vulnerable to all kinds of degenerative and infectious diseases.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

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
The patient and his family meet with the nurse to discuss progress on the patient care plan. The patient and his family meet with the nurse to discuss progress on the patient care plan.
View from the Phoenix lander, 2008 View from the Phoenix lander, 2008
Particles measured, 1970 - 2008 and Trend in Organic Compound 1990 - 2007 Particles measured, 1970 - 2008 and Trend in Organic Compound 1990 - 2007
Total Fertility Rate in the United States, 1860–2008 Total Fertility Rate in the United States, 1860–2008
GDP per Capita by Country Group, 1820–2008 GDP per Capita by Country Group, 1820–2008
Video: Cataract

For a complete list of videos, visit our video library