Answer Posted / ram

to avoiding duplicate data and easy maintence
it depends on entity relationship between columns

What is the usage of synonyms?

591

---

What is program global area (pga) in oracle?

609

---

What are named parameters?

616

---

How to initialize variables with default values?

636

---

what is the use of system.effective.date variable in oracle?

673

---

---

How to load data from external tables to regular tables?

541

---

How do we display rows from the table without duplicates?

550

---

What to do if the binary spfile is wrong for the default instance?

564

---

Explain user account with reference to oracle.

538

---

What are the components of logical database structure in oracle database?

583

---

How would you change old and new values in an insert, delete and update triggers?

545

---

What are dml statements in oracle?

623

---

candidate key is subset of super key but not vice-verse explain

1579

---

How to convert a string to a date in oracle database?

543

---

Where are the settings stored for each instance in oracle?

627

---