« previous next »

Author Question: What components are included in a database? What will be an ideal ... (Read 85 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?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

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?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Microscopic Components of Osseous Tissue Microscopic Components of Osseous Tissue
Typical port fuel-injection system, indicating the location of various components. Notice that the ... Typical port fuel-injection system, indicating the location of various components. Notice that the ...
World Inequality and Its Components, 1820–1992 World Inequality and Its Components, 1820–1992
General Components of a Reflex Arc General Components of a Reflex Arc
Components of Human Blood Components of Human Blood
Floral components. Anthers produce pollen and ovules produce eggs. Floral components. Anthers produce pollen and ovules produce eggs.
Video: Virtual Tour of the Heart

For a complete list of videos, visit our video library