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 46 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
:D TYSM

sailorcrescent

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Your heart beats over 36 million times a year.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

The proportion of obese and extremely obese adults in the United States has increased over the past The proportion of obese and extremely obese adults in the United States has increased over the past
All of the homes in this new neighborhood of Brentwood, California, are for sale, evidence of the co All of the homes in this new neighborhood of Brentwood, California, are for sale, evidence of the co
Dolores Huerta and Cesar Chavez, leaders of the United Farm Workers, discuss their 1968 strike of ... Dolores Huerta and Cesar Chavez, leaders of the United Farm Workers, discuss their 1968 strike of ...
Most lifts are equipped with short pad extensions that are often necessary to use to allow the pad ... Most lifts are equipped with short pad extensions that are often necessary to use to allow the pad ...
Enzymatic rate enhancements Enzymatic rate enhancements
Total Fertility Rate in the United States, 1860–2008 Total Fertility Rate in the United States, 1860–2008
Video: Mendel's Principles of Dominance, Segregation and Independent Assortment

For a complete list of videos, visit our video library