Answer Posted / nathahar anees

MANUAL CREATION:
CREATE APROPRIATE FOLDERS IN THE CORRESPONDING LOCATION AND
CREATE PFILE..
COME TO COMMAND PROMPT CREATE NEW SID USING ORANEW COMMAND
AND START INSTANCE IN NOMOUNT STAGAGE AND CREATE A DATABASE
COMMAND FOR DATABASE CREATION.

sql :> CREATE DATABASE <DATABASE NAME> DATAFILE....

AND RUN CATALOG AND CATPROC SCRIPTS

How to write a left outer join with the where clause in oracle?

1130

---

What is max rowid in oracle?

1080

---

How to create a stored procedure in oracle?

1149

---

How to create an initialization parameter file?

1101

---

How to start an oracle instance?

1071

---

How much memory your 10g xe server is using?

1150

---

how can we store any pdf file in oracle

2216

---

What are the differences between blob and clob in oracle?

1134

---

How to use "for" statements in oracle?

1120

---

Briefly explain what is literal? Give an example where it can be used?

1087

---

What do you mean by merge in oracle?

1028

---

What are group functions in oracle?

1092

---

How to assign a tablespace to a users in oracle?

1086

---

What privilege is needed for a user to connect to oracle server?

1032

---

What is index in Oracle?

1128

---