« previous next »

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

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Heme consists of a complex organic ring structure, protoporphyrin Heme consists of a complex organic ring structure, protoporphyrin
Water amount needed to grow crops Water amount needed to grow crops
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 ...
Equipment and supplies needed for manual exfoliation using natural substances. Equipment and supplies needed for manual exfoliation using natural substances.
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 ...
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: Anatomy and Chemical Makeup of a Single Hair (Animation)

For a complete list of videos, visit our video library