« previous next »

Author Question: Explicit commands to manage transactions are needed when: A) a transaction consists of just one ... (Read 57 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 FDA recognizes 118 routes of administration.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Choose the telephone unit that offers the features needed in your office. Choose the telephone unit that offers the features needed in your office.
skeletal muscle consists of a group of fibers held together by connective tissue. It is enclosed in ... skeletal muscle consists of a group of fibers held together by connective tissue. It is enclosed in ...
"No Oven Needed" Energy Bars Try this recipe as an inexpensive alternative to commercial ... "No Oven Needed" Energy Bars Try this recipe as an inexpensive alternative to commercial ...
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
Expulsion of fetus and afterbirth during normal delivery. The afterbirth consists of the placenta, t Expulsion of fetus and afterbirth during normal delivery. The afterbirth consists of the placenta, t
A taproot system consists of a large main root together with its lateral branchings A taproot system consists of a large main root together with its lateral branchings
Video: EpiPen Animation (Part 2)

For a complete list of videos, visit our video library