« previous next »

Author Question: Microsoft Access SQL commands are run in the ________ of a Query window. Fill in the blank(s) ... (Read 87 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?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

Injecting an IV push (bolus) medication; C, another type of needleless syringe and needleless IV acc Injecting an IV push (bolus) medication; C, another type of needleless syringe and needleless IV acc
Allows access to the nut that has a stud plus other locations needing great depth, such as spark ... Allows access to the nut that has a stud plus other locations needing great depth, such as spark ...
Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ... Needle-nose pliers are used where there is limited access to a wire or pin that needs to be ...
This red gasoline container holds about 30 gallons of gasoline and is used to fill vehicles used ... This red gasoline container holds about 30 gallons of gasoline and is used to fill vehicles used ...
Regional Variation in Income and Access to the Sea Regional Variation in Income and Access to the Sea
X-ray showing pneumonia. Fluid and blood cells fill the lungs X-ray showing pneumonia. Fluid and blood cells fill the lungs
Video: Calvin cycle (The light-independent reactions )

For a complete list of videos, visit our video library