This topic contains a solution. Click here to go to the answer

Author Question: Discuss some of the SQL:2008 enhancements and extensions to SQL. What will be an ideal ... (Read 48 times)

madam-professor

  • Hero Member
  • *****
  • Posts: 584
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
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
:D TYSM


Hdosisshsbshs

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

 

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

Approximately 70% of expectant mothers report experiencing some symptoms of morning sickness during the first trimester of pregnancy.

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?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

For a complete list of videos, visit our video library