« previous next »

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

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

In 1864, the first barbiturate (barbituric acid) was synthesized.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Nucleotides and their components Nucleotides and their components
Components of a MiniCiggy e-cigarette Components of a MiniCiggy e-cigarette
Components of the Human Body Components of the Human Body
Soil Components Soil Components
Components of MRI Components of MRI
Sternberg's theory postulates three components of love Sternberg's theory postulates three components of love
Video: Methods that regulate pH

For a complete list of videos, visit our video library