« previous next »

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

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Modifications to eukaryotic pre-mRNA are needed to create a functional (mature) mRNA molecule Modifications to eukaryotic pre-mRNA are needed to create a functional (mature) mRNA molecule
When the PCM commands 50% duty cycle, the oil flow through the phaser drops to zero. When the PCM commands 50% duty cycle, the oil flow through the phaser drops to zero.
The tools and equipment needed to perform a compression test include a compression gauge, an air ... The tools and equipment needed to perform a compression test include a compression gauge, an air ...
The flammable range consists of the concentration of fuel that will burn in atmospheric oxygen—the ... The flammable range consists of the concentration of fuel that will burn in atmospheric oxygen—the ...
What mass, in grams, of a 5.00% by mass sugar water solution is needed to supply What mass, in grams, of a 5.00% by mass sugar water solution is needed to supply
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: Exocytosis - secretion

For a complete list of videos, visit our video library