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

big1devin

  • Hero Member
  • *****
  • Posts: 583
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
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

cdmart10

  • Sr. Member
  • ****
  • Posts: 332

 

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

For a complete list of videos, visit our video library