« previous next »

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

Everyone has one nostril that is larger than the other.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Components of the Arcuate Fasciculus Components of the Arcuate Fasciculus
Components of a computer system. Components of a computer system.
Arrangement of components of the two photosystems on the thylakoid membrane Arrangement of components of the two photosystems on the thylakoid membrane
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
Skeletal Components of the Thorax Skeletal Components of the Thorax
Components of the lymphatic system Components of the lymphatic system
Video: Passive Smoke Exposure

For a complete list of videos, visit our video library