Answer Posted / imran khan

First normal form, sets the very basic rules for an
organized database i.e. Eliminate duplicative columns.
Create separate tables for each group of related data and
identify the row with a unique column i.e the primary key.

Second normal form further removes the duplicate data:

i.e. Meet the requirements of the first form of
normalalization. Create relationships between new tables
through foreign keys.

Difference between cartesian join and cross join?

1039

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1017

---

What is the difference between view and materialized view in Oracle?

1154

---

How will you write a query to get a 5th rank student from a table student_report?

1866

---

Is java required for oracle client?

999

---

Name the three major set of files on disk that compose a database in Oracle?

1123

---

What is key preserved table?

1021

---

How can I get column names from a table in oracle?

1048

---

How to write a query with an inner join in oracle?

1040

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

---

Give the various rollback segment states.

1052

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

---

Is oracle a language?

946

---

Explain about achiever in sql?

1035

---

Explain a private synonyms?

1037

---