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 46 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
:D TYSM

kthug

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

A health history is essential in collecting subjective data about metabolic acidosis. A health history is essential in collecting subjective data about metabolic acidosis.
Recognizing data clusters Recognizing data clusters
A physician uses a portable electronic tablet to enter patient data while in the examination room. A physician uses a portable electronic tablet to enter patient data while in the examination room.
A typical OBD-II data link connector (DLC). The location varies with make and model and may even be ... A typical OBD-II data link connector (DLC). The location varies with make and model and may even be ...
A mobile weather station that can be used to gather current weather data at the scene of hazardous ... A mobile weather station that can be used to gather current weather data at the scene of hazardous ...
Histograms - Analysis and Data Histograms - Analysis and Data
Video: Role of the respiratory system - effect of altered ventilation rates

For a complete list of videos, visit our video library