Answer Posted / harikrishna

actually oracle give's more security and best performance other then any databases like ms-sqlsever, DB2,sybase etc.

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848

---

What are internal user account in oracle?

946

---

What is hot backup and logical backup?

998

---

Explain the difference between replace() and translate() functions in oracle?

973

---

What is the usage of control file in oracle?

1024

---

What are the arithmetic operations?

1020

---

What is a parameter file in oracle?

1048

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2130

---

Where are the settings stored for each instance in oracle?

1060

---

How to define a record variable to store a table row?

1001

---

Difference between varchar and varchar2 data types?

1114

---

What is the order of defining local variables and sub procedures/functions?

1003

---

What does sharding mean?

946

---

What is key preserved table?

955

---

How do we get field detail of a table?

1020

---