Answer Posted / padma

1st normal form: first identify the repeating group of
fields n group them into separate table
2nd normal: it should be in 1st normal form and check all
fields are dependent on primary key
3nd normal form: it should be in 2nd normal form and check
all the fields r independent of any other non-key attribute
ie removes the fields that dependent on non-key

1st normal: first identify repeating fields and group them
another table
2nd normal: it should be in 1st normal form and identify
that all fields all dependent on primary key.
3nd normal: it should be in 2nd normal form and check all
fields all indpendent of other non-key attribute

How to rename an index?

995

---

Difference between inner join vs where ?

977

---

How translate command is different from replace?

1005

---

How oracle handles dead locks?

1018

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1695

---

What suggestions do you have to reduce the network traffic?

900

---

Explain overloading. Can functions be overloaded?

934

---

What are the parameters that we can pass through a stored procedure?

997

---

What happens if you set the sga too low in oracle?

1052

---

State all possible different index configurations a table can possibly have?

947

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2200

---

How does Oracle guarantee data integrity of data changes?

2331

---

What is an oracle wallet?

881

---

Give the constructs of a package, function or a procedure.

982

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

972

---