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

ghost! · **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?

shoemake · **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.