« previous next »

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

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Choose the telephone unit that offers the features needed in your office. Choose the telephone unit that offers the features needed in your office.
An assortment of hoist pad adaptors that are often needed to safely hoist many pickup trucks, ... An assortment of hoist pad adaptors that are often needed to safely hoist many pickup trucks, ...
The tools and equipment needed to perform a compression test include a compression gauge, an air ... The tools and equipment needed to perform a compression test include a compression gauge, an air ...
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
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 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: ribosome

For a complete list of videos, visit our video library