« previous next »

Author Question: What components are included in a database? What will be an ideal ... (Read 19 times)

big1devin

  • Hero Member
  • *****
  • Posts: 583
on: Jul 7, 2018
What components are included in a database?
 
  What will be an ideal response?

Question 2

With SQL Server, a nonclustered index does not contain data but has pointers to the data.
 
  Indicate whether the statement is true or false


cdmart10

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

The database contains user data, metadata, indexes and other overhead data, and application metadata. User data is the data from the user's environment that they want to track. Metadata is data about the structure of the database. Indexes and other overhead data are structures that the database uses to improve performance. Finally, the application metadata is data about forms, reports, and other application components that some databases, particularly those created with desktop DBMS products, store with the database.

Answer to Question 2

TRUE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

big1devin

  • Hero Member
  • *****
  • Posts: 583
Reply #2 on: Jul 7, 2018
Thank you


cdmart10

  • Sr. Member
  • ****
  • Posts: 332
Reply #3 on: Jul 7, 2018
No problemo


« previous next »
 

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.

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

Sildenafil (Viagra®) has two actions that may be of consequence in patients with heart disease. It can lower the blood pressure, and it can interact with nitrates. It should never be used in patients who are taking nitrates.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

The Major Components of the Limbic System The Major Components of the Limbic System
Information Processing Model The components of the model operate simultaneously. Information Processing Model The components of the model operate simultaneously.
Edward Bellamy, author of the utopian novel Looking Backward (1888) Bellamy’s socialism worried many Edward Bellamy, author of the utopian novel Looking Backward (1888) Bellamy’s socialism worried many
Components of a Capsule Components of a Capsule
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
(a) Blue arrows (right side): External components of the innate immune system: human body with skin, ... (a) Blue arrows (right side): External components of the innate immune system: human body with skin, ...
Video: Blood Test Basics

For a complete list of videos, visit our video library