Answer Posted / nishi

database contain atleast one tablespace and tablespace must have atleast one datafile

Where are the settings stored for each instance in oracle?

1105

---

What is bulk load in oracle?

1070

---

How to apply filtering criteria at group level in oracle?

1042

---

How to convert a date to char in oracle? Give one example.

1068

---

How to view the data files in the current database?

1098

---

How to lock and unlock a user account in oracle?

1106

---

Who developed oracle & when?

1003

---

How to create a new user account in oracle?

1021

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

---

How to rename an existing table?

1129

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

---

How to define an anonymous block?

1158

---

How many types of database triggers exist?

1135

---

What are the uses of Database Trigger ?

1720

---

What is the difference between postgresql and oracle?

1048

---