« previous next »

Author Question: Explicit commands to manage transactions are needed when: A) a transaction consists of just one ... (Read 27 times)

dbose

  • Hero Member
  • *****
  • Posts: 597
on: Jul 7, 2018
Explicit commands to manage transactions are needed when:
 
  A) a transaction consists of just one SQL command.
  B) multiple SQL commands must be run as part of a transaction.
  C) autocommit is set to off.
  D) DDL statements are prohibited.

Question 2

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V;
 
  A) The average of all products in Product_V
  B) The average Standard_Price of all products in Product_V
  C) The average price of all products
  D) The mode of all prices
Modern Database Management ¦ Hoffer, Venkataraman, Topi ¦ 13th Edition
Buy Test-Bank


kswal303

  • Sr. Member
  • ****
  • Posts: 316
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

B


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Sunlight consists of a spectrum of colors, visible here in a rainbow. Sunlight consists of a spectrum of colors, visible here in a rainbow.
Append Modifiers, If Needed. Append Modifiers, If Needed.
Gene expression consists of transcription of DNA into mRNA Gene expression consists of transcription of DNA into mRNA
Electron configuration and how many electrons are needed to achieve the nearest noble-gas ... Electron configuration and how many electrons are needed to achieve the nearest noble-gas ...
How many grams of tartaric acid, H2C4H4O6, (molar mass = 150.10 g) are needed to How many grams of tartaric acid, H2C4H4O6, (molar mass = 150.10 g) are needed to
Structure of hemoglobin, the oxygen-transporting protein of red blood cells. It consists of four glo Structure of hemoglobin, the oxygen-transporting protein of red blood cells. It consists of four glo
Video: Language Areas Animation

For a complete list of videos, visit our video library