Answer Posted / ron

Note:
1. data is normalized in oltp systems
( are of different forms :1NF, 2NF, 3NF, BCNF, 4NF,
5NF,DKNF,6NF)
2. when it comes to olap/datawarehouse/dss sytems data is
generally de-normalized. (N1NF, PNF).

there is always a trade-off to consider between data
redundancy vs performance

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1369

---

What is logical backup in oracle?

969

---

Explain the different normalization forms?

1012

---

How to convert csv to table in oracle?

924

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2074

---

What is the usage of control file in oracle?

1028

---

How to define a data field as not null?

1061

---

What are the roles of dba?

1021

---

what is meant by magic query

2137

---

How to retrieve data from an cursor to a record?

1019

---

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

1102

---

What is a relational database management system?

1064

---

How to write date and time interval literals in oracle?

974

---

Is there a combination of "like" and "in" in sql?

1007

---