« previous next »

Author Question: How are SQL views handled in Microsoft Access? What will be an ideal ... (Read 41 times)

Mr. Wonderful

  • Hero Member
  • *****
  • Posts: 866
on: Jul 7, 2018
How are SQL views handled in Microsoft Access?
 
  What will be an ideal response?

Question 2

What is the least restrictive isolation level that will prevent dirty reads?
 
  A) Read Committed
  B) Serializable
  C) Read Uncommitted
  D) Atomic Read
  E) Repeatable Read


ansleighelindsey

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

Microsoft Access does not support views directly. But since an SQL view is essentially a stored query, Microsoft Access queries can be used to implement SQL view equivalents. Standard Microsoft Access queries can then use previously stored view equivalent Access queries the same way an SQL SELECT statement is used to retrieve SQL views.

Answer to Question 2

A


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

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?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

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.

The respiratory system: nasal cavity, pharynx, larynx, trachea, bronchus, and lung with expanded vie The respiratory system: nasal cavity, pharynx, larynx, trachea, bronchus, and lung with expanded vie
Change in American Gender Attitudes, 1977-2006 Over recent decades, views of gender roles have beco Change in American Gender Attitudes, 1977-2006 Over recent decades, views of gender roles have beco
Microsoft Word Attachments Microsoft Word Attachments
Intaglio printmaking techniques, side views. Intaglio printmaking techniques, side views.
Two stubby screwdrivers used to access screws that have limited space above. A straight blade is on ... Two stubby screwdrivers used to access screws that have limited space above. A straight blade is on ...
A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ... A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ...
Video: Baroreceptor Reflex

For a complete list of videos, visit our video library