Answer Posted / saranya

The control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation. It contains (but
is not limited to) the following types of information:

* Database information (RESETLOGS SCN and their time
stamp)
* Archive log history
* Tablespace and datafile records (filenames, datafile
checkpoints, read/write status, offline or not)
* Redo threads (current online redo log)
* Database's creation date
* database name
* current archive log mode
* Log records (sequence numbers, SCN range in each log)
* RMAN catalog
* Database block corruption information
* Database ID, which is unique to each DB

List out the difference between commit, rollback, and savepoint?

985

---

What are the attributes of the cursor?

934

---

if you ctreate table identity

2313

---

What is a lookup table in oracle?

929

---

Can we call procedure inside function in oracle?

1018

---

What are the differences between blob and clob in oracle?

1029

---

What do you understand by database schema and what does it hold?

1177

---

What are the different types of partitions in oracle?

909

---

How to export your own schema?

969

---

How to grant create session privilege to a user in oracle?

946

---

What is merge in oracle?

994

---

How to specify default values in insert statement using oracle?

1034

---

How to execute a stored program unit?

1004

---

What is the string concatenation operator in oracle?

1090

---

What is the quickest way to fetch the data from a table?

999

---