« previous next »

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

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

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?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Components of the Stethoscope Components of the Stethoscope
Many electronic components are used to construct a typical vehicle computer. Notice the quantity of ... Many electronic components are used to construct a typical vehicle computer. Notice the quantity of ...
Components of a Sarcomere Components of a Sarcomere
Skeletal Components of the Thorax Skeletal Components of the Thorax
Sonal bought a coat for $198.88, which included 8% PST and 5% GST. What was the selling price ... Sonal bought a coat for $198.88, which included 8% PST and 5% GST. What was the selling price ...
Components of the lymphatic system Components of the lymphatic system
Video: Introduction to Herpes

For a complete list of videos, visit our video library