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 18 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

bigcheese9

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Nitroglycerin is used to alleviate various heart-related conditions, and it is also the chief component of dynamite (but mixed in a solid clay base to stabilize it).

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

President-elect Barack Obama, his daughters, and wife, Michelle, celebrate his victory in November 2 President-elect Barack Obama, his daughters, and wife, Michelle, celebrate his victory in November 2
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 ...
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Economic recession in 2008 saw a small decrease in demand Economic recession in 2008 saw a small decrease in demand
Extensions of the Dura Mater Extensions of the Dura Mater
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: Transmission Across a Synapse

For a complete list of videos, visit our video library