Answer Posted / priya

Constraints define the conditions or predictions under
which data is valid.
column level constraints are applicable to single column
only like if we want to make Unique constraint on column
level then as shoen below:-
<column Name><data type>Unique
At table level
Unique(<coulmn>,<column>);
Table level constraints means when constraints apply on
more than single column.

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1901

---

How to export your connection information to a file?

1082

---

What is a system tablespace?

1011

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

974

---

How to drop an existing view in oracle?

910

---

How to resolve the ORA-39133 error in Oracle?

1048

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2214

---

Can a formula column be obtained through a select statement ?

2274

---

How to assign data of the deleted row to variables?

1018

---

What is difference between truncate and delete?

984

---

Can I create users through internet explorer in oracle 10g?

1027

---

How to use "in out" parameter properly?

1003

---

How to define and use table alias names in oracle?

890

---

What are the most common interview questions on ETL Testing for experience?

1086

---

what is the difference between substr and instr function in oracle?

1044

---