Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is the use of database index(apart from the last
searching of records) and what is the use of composite key?

Question Posted / brijesh kumar


what is the use of database index(apart from the last searching of records) and what is the use o..

Answer / brijesh kumar

Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table

Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.

Is This Answer Correct ?    12 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

How to create an identity column?

0 Answers  

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

What is query and its types?

0 Answers  

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

What are the common performance issues in sql server?

0 Answers  

Explain log shipping?

0 Answers  

How to create stored procedures with parameters in ms sql server?

0 Answers  

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

Explain log shipping and mention its advantages.

0 Answers  

What are number line correlation administrators will use while working with a subquery?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories