« previous next »

Author Question: Microsoft Access SQL commands are run in the ________ of a Query window. Fill in the blank(s) ... (Read 76 times)

Awilson837

  • Hero Member
  • *****
  • Posts: 509
on: Jul 7, 2018
Microsoft Access SQL commands are run in the ________ of a Query window.
 
  Fill in the blank(s) with correct word

Question 2

Explain the pragmatic reason for using surrogate keys.
 
  What will be an ideal response?


otokexnaru

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

SQL View

Answer to Question 2

Primary keys are commonly included in indexes, and are used to identify records to be retrieved by users. The ideal primary key is short, numeric and fixed. When the primary key contains a lengthy text field, this creates a large amount of duplicated data that must be frequently manipulated. For these reasons, it is often practical to use a surrogate key that is generated by the system and is relatively small and easy to manipulate.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

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?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Plant Cell (Blank Labels) Plant Cell (Blank Labels)
Types of hemodialysis access sites. Types of hemodialysis access sites.
Language Access Services Language Access Services
Reinstall the spark plug wires and all brackets that were removed to gain access to the valve ... Reinstall the spark plug wires and all brackets that were removed to gain access to the valve ...
Water Access Water Access
If 0.40 mol of NaN3 reacts completely in the reaction shown below, then ________ L of N2 will ... If 0.40 mol of NaN3 reacts completely in the reaction shown below, then ________ L of N2 will ...
Video: Hormonal regulation of blood pressure - RAA system

For a complete list of videos, visit our video library