What is recreating and rebuiding of indexes?

sktest

 Profile Answers by sktest Questions by sktest

• Jul 11th, 2010

ALTER INDEX REBUILD

raghunadhn

 Profile Answers by raghunadhn Questions by raghunadhn

• Mar 3rd, 2010

Rebuilding IndexSyntax: Alter index index_name rebuild.If you rebuild the index, the existing index will be dropped and created immediately, and any overheads existing on the index wil be removed. The...

Answer Question  Select Best Answer

Why we use handlers? What are they?

sktest

 Profile Answers by sktest Questions by sktest

• Jul 11th, 2010

Handlers are group of Package and Procedure which is used in Oracle application to organize the code in PL/SQL form.Handler provide way to centerlize code so that it can easily develop,manage and debu...

Answer Question  Select Best Answer

sunshine60india

 Profile Answers by sunshine60india Questions by sunshine60india

• Jun 18th, 2011

Primary KEY is the combination of UNIQUE and NOT NULL constraint

neha.awasthi1

 Profile Answers by neha.awasthi1 Questions by neha.awasthi1

• May 19th, 2011

Both primary key and unique contain unique value.1: primary key cant be nullUnique key can be null.2: Multiple column of table van be defined as unique key.Only one column can defined as primary key

Answer Question  Select Best Answer