How Clustered Index and Non clustered index stored on SQL
server?

Answers were Sorted based on User's Feedback



How Clustered Index and Non clustered index stored on SQL server?..

Answer / anitha

clustered index that reorders the way in which records in
the table are physically stored.
non clustered index in which the logical order of the index

Is This Answer Correct ?    14 Yes 2 No

How Clustered Index and Non clustered index stored on SQL server?..

Answer / answerme

Clustered Index are always stored on disk in a certain
order i.e, the data on disk may well be stored in order of
the Primary Key. So the data retreival is faster, when
queried based on Primary key.

non Clustered indexes are all the other indexes on a table,
that do not dictate the order that records are stored on
disk.A non Clustered index stores all the fields that
comprise the index, plus a link to the actual full record
on disk. This link is the primary key (clustered index), so
in fact a non clustered index contains all the columns that
you specify for them plus the clustered index columns too.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

what is <location> tag?

2 Answers  


How will you write a web service for secure socket layer? What is secure socket? Have you done any socket programming? What is single thread and multi thread? What are the differences between .NET 1.1 and .NET 2.2? What is the command to connect to a StoredProcedure? How many types of Adapters are available in ADO.NET? Why DataAdapters are important? What is DataSet? It's important to compile the ASP.NET application before using it? What protocol you use to stream the audio and Video data? What are the different kind of network protocols? Write how will you connect to a database using DataSet? Why we use AJAX? What AJAX can do which JavaScript can't do? In a page using Windows Media API, if we press a button and in succession quickly press another button, what do you think will happen? Will the application wait for the first button response and then execute the second one or directly second button command will execute. What is the architecture of your application? What is connection pooling in SQL? Tell some functions of Windows Media API? How you will detect, whether the ActiveX is installed in the system before accessing it? What are validators are available in ASP.NET? What are the basic concepts of OOPS? What is abstraction?

0 Answers   Tesco,


How can you make sure that web api returns json data only?

0 Answers  


How can you change a Master page dynamically in which event of page life cycle?

2 Answers   Fulcrum Logic,


what exception is thrown when you do a response.redirect

2 Answers   IBM,






Define static constructor?

0 Answers  


What type of code (server or client) is found in a Code- Behind class?

2 Answers  


What is dynamic web page with example?

0 Answers  


What should you do is you want to remove an existing component but would like to make some funtionalities?

0 Answers  


how to handle sql exceptions?

4 Answers   Marlabs, TCS,


what is Repeater Control, When it is used,How it is used, what type of template is used for repeater control?

6 Answers   iSoft,


Describe the difference between inline and code behind - which is best in?

0 Answers  


Categories