This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: With SQL Server, the clustered index is faster for data retrieval. Indicate whether the statement ... (Read 83 times)

ghost!

  • Hero Member
  • *****
  • Posts: 560
on: Jul 7, 2018
With SQL Server, the clustered index is faster for data retrieval.
 
  Indicate whether the statement is true or false

Question 2

Why do we say a database is self-describing and why is this an advantage?
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

shoemake

  • Sr. Member
  • ****
  • Posts: 343
Reply #1 on: Jul 7, 2018
Answer to Question 1

TRUE

Answer to Question 2

A database is considered self-describing because it contains a description of its own structure within the database itself. This description is called the metadata, and it is stored in specialized tables in relational databases. The advantage is that the database is self-documenting, and that a knowledgeable user or a database designer can easily access the metadata. All DBMS vendors provide tools to access the metadata within their products.


ghost!

  • Member
  • Posts: 560
Reply 2 on: Jul 7, 2018
Excellent

carlsona147

  • Member
  • Posts: 341
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Did you know?

According to the Migraine Research Foundation, migraines are the third most prevalent illness in the world. Women are most affected (18%), followed by children of both sexes (10%), and men (6%).

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Thyroid scan. The right image is the data from a thyroid scan, printed on a superimposed map of the Thyroid scan. The right image is the data from a thyroid scan, printed on a superimposed map of the
Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry. Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry.
Dimensions for gathering data Dimensions for gathering data
Women who are monozygotic twins and have the same genes are more similar in their marital happiness Women who are monozygotic twins and have the same genes are more similar in their marital happiness
Interpret CPT Index Conventions Interpret CPT Index Conventions
Satiety Index of Different Foods Subjects Satiety Index of Different Foods Subjects
Video: Bone tissue types - compact and spongy

For a complete list of videos, visit our video library