Answer Posted / aditi

commit save the transactions done after the last commit and rollback undo all transactions after last commit
Yes foreign key can have null value

What are the tools for Oracle ?

1013

---

Explain integrity constraint?

1117

---

What is ordinary table in oracle?

1086

---

What is an oracle database?

997

---

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

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4303

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1923

---

How to use "for" statements in oracle?

1026

---

How to check the server version in oracle?

1048

---

What is catalog in Oracle?

1285

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4481

---

How to create an oracle testing table?

1017

---

Is oracle a relational database?

879

---

How to loop through data rows in the implicit cursor?

1024

---

How to sort the query output in oracle?

976

---