Answer Posted / somu.kattikar

First Normal Form:
1.it doesnt contain the duplicate rows and null values.
2.those values can be moved into new table.


second normal form:
1.each columns are completely depend upon key

How to test null values?

1112

---

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?

1953

---

Explain view?

1039

---

How do I limit the number of rows returned by an oracle query after ordering?

1170

---

Explain the use of compress option in exp command.

1021

---

Can we store pictures in the database and if so, how it can be done?

1045

---

How to view existing locks on the database?

1053

---

What is a subquery?

1125

---

How to use "while" statements in oracle?

1327

---

How can I create database in oracle?

1028

---

In oracle there is column command, how will you explain that?

1057

---

material view and view disadvantages?

1079

---

How to create an oracle database manually?

1089

---

Query to retrieve record for a many to many relationship ?

2520

---

Can group functions be used in the order by clause in oracle?

999

---