« previous next »

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

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

The tundra at the base of the Torngat mountains in Labrador consists primarily of low-growing mosses The tundra at the base of the Torngat mountains in Labrador consists primarily of low-growing mosses
Atherosclerosis. (a) A sectioned coronary artery that exhibits an accumulation of fatty plaque, whic Atherosclerosis. (a) A sectioned coronary artery that exhibits an accumulation of fatty plaque, whic
DNA consists of two complementary strands wound around each other to form DNA consists of two complementary strands wound around each other to form
A shim (or half shim) may be needed to provide the proper clearance between the flywheel teeth of ... A shim (or half shim) may be needed to provide the proper clearance between the flywheel teeth of ...
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: Calvin Cycle Explained!

For a complete list of videos, visit our video library