Answer / savithri

A database index is a data structure that improves the
speed of operations in a table. Indices can be created
using one or more columns, providing the basis for both
rapid random lookups and efficient ordering of access to
records.

Answer / sunny sarin

Indexing is creating an index for a table in the database to
fasten the speed of retrieving the results and for better
performance and efficiency.
Normally,indexes are of 2 types
unique
non-unique

unique index is created implicitly by the server whenever
any primary or foreign key constraint is given to any
column/s in the table.

we can also create a non unique index for any column in the
table.

indexes are stored on a different segment than the
table,this reduces contention on the table

indexes should not be created for that columns for which the
value in the column varies a lot.

indexes should also not be created on the columns on which
high level of DML's and DDL's are performed.

Answer / pppandu

It Is One Of The Database Object,Which Automatically
Created While Creating The Primary Keys Those Gives More
Performance

What is the use of INDEXES option in EXP command ?

1 Answers  

---

Explain the difference between physical and logical data independence?

0 Answers  

---

What are the partitions types available in Oracle10g. How it will do? Simple example?

1 Answers   Tech Mahindra,

---

What is database in simple language?

0 Answers  

---

Define atomicity and aggregation.

0 Answers  

---

What is Normalization and its different forms?

0 Answers   QuestPond,

---

What is cardinality in db?

0 Answers  

---

Describe the Process of ETL (Extract, Transform, Load).

1 Answers  

---

What are the limitations of rdbms?

0 Answers  

---

Explain the key constraints and constraints on Null Values with examples?

2 Answers  

---

What are the 5 major parts of a database system?

0 Answers  

---

Explain relational algebra?

0 Answers  

---