« previous next »

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

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

In a craniotomy, a portion of the skull and overlying scalp is pulled back to allow access to the br In a craniotomy, a portion of the skull and overlying scalp is pulled back to allow access to the br
A replaceable PROM used in an older General Motors computer. Notice that the sealed access panel ... A replaceable PROM used in an older General Motors computer. Notice that the sealed access panel ...
Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier. Removing the bed from a pickup truck makes gaining access to the fuel pump a lot easier.
Jump Right In: Essential Computer Skills Using Microsoft Office 2013 (2nd Edition) Jump Right In: Essential Computer Skills Using Microsoft Office 2013 (2nd Edition)
Exploring Getting Started With Microsoft Windows 8 Exploring Getting Started With Microsoft Windows 8
Directions: Fill in the correct number or word(s). Order: Lantus U-100 insulin 68 units subcut ... Directions: Fill in the correct number or word(s). Order: Lantus U-100 insulin 68 units subcut ...
Video: Phases of the ovarian cycle

For a complete list of videos, visit our video library