This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: The SQL statement used to modify a view is: A) ALTER EXISTING VIEW ViewName AS. B) ALTER VIEW ... (Read 353 times)

BRWH

  • Hero Member
  • *****
  • Posts: 553
on: Jul 7, 2018
The SQL statement used to modify a view is:
 
  A) ALTER EXISTING VIEW ViewName AS.
  B) ALTER VIEW ViewName AS.
  C) DROP EXISTING VIEW ViewName.
  D) DROP VIEW ViewName.
  E) MODIFY VIEW ViewName AS.

Question 2

With optimistic locking, locks are first issued, then the transaction is processed, and then the locks are released.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

coyin

  • Sr. Member
  • ****
  • Posts: 334
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

FALSE


BRWH

  • Member
  • Posts: 553
Reply 2 on: Jul 7, 2018
Wow, this really help

komodo7

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

In 1864, the first barbiturate (barbituric acid) was synthesized.

Did you know?

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

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Muscles of the Body, Posterior View Muscles of the Body, Posterior View
A view from underneath a Chevrolet pickup truck showing how the pad extensions are used to attach ... A view from underneath a Chevrolet pickup truck showing how the pad extensions are used to attach ...
A cutaway view of a typical two-stage turbine electric fuel pump. A cutaway view of a typical two-stage turbine electric fuel pump.
Right lateral view of skull Right lateral view of skull
Development of the Eyes and Ears: External View - 28 days Embryo Development of the Eyes and Ears: External View - 28 days Embryo
The Muscular System (Posterior View) The Muscular System (Posterior View)
Video: Bulk flow - factors that influence bulk flow

For a complete list of videos, visit our video library