« previous next »

Author Question: Explicit commands to manage transactions are needed when: A) a transaction consists of just one ... (Read 52 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?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

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

Sunlight consists of a spectrum of colors, visible here in a rainbow. Sunlight consists of a spectrum of colors, visible here in a rainbow.
The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen
Structure of a Triglyceride A triglyceride consists of three fatty acids attached to a glycerol back Structure of a Triglyceride A triglyceride consists of three fatty acids attached to a glycerol back
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
A polysome consists of an mRNA molecule loaded with many ribosomes, all engaged in translation. A polysome consists of an mRNA molecule loaded with many ribosomes, all engaged in translation.
Video: Wound Repair Animation

For a complete list of videos, visit our video library