« previous next »

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

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Water amount needed to grow crops Water amount needed to grow crops
This five-wire mass air flow sensor consists of a metal foil sensing unit, an intake air temperature ... This five-wire mass air flow sensor consists of a metal foil sensing unit, an intake air temperature ...
An Internet connection is usually needed to perform updates although some vehicle manufacturers use ... An Internet connection is usually needed to perform updates although some vehicle manufacturers use ...
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
The minimum number of moles of oxygen needed to completely consume 4 moles of C3H8O is ... The minimum number of moles of oxygen needed to completely consume 4 moles of C3H8O is ...
How many milliliters of 13.2 M H2SO4 are needed to prepare 600.0 mL of 0.10 M H2SO4? How many milliliters of 13.2 M H2SO4 are needed to prepare 600.0 mL of 0.10 M H2SO4?
Video: Cardiac Cycle (Part 4 of 4)

For a complete list of videos, visit our video library