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

dbose

  • Hero Member
  • *****
  • Posts: 597
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


kswal303

  • Sr. Member
  • ****
  • Posts: 316
Answer to Question 1

B

Answer to Question 2

B



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

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

Did you know?

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

For a complete list of videos, visit our video library