Answer Posted / nithya

High water mark(hwm) indicates the max level to
which the data has risen in the table. when data is inserted
in the table hwm is adjusted accordingly, If all data is
deleted in a table, hwm is not adjusted and remains pointing
to the max data position in the table.

Explain the use of grant option in imp command.

1078

---

Can multiple cursors being opened at the same time?

1115

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3941

---

How will you identify oracle database software release?

1056

---

Explain index?

1306

---

What do you mean by cdb and pdb in oracle 12c?

1101

---

How to drop an existing view in oracle?

992

---

How to assign a tablespace to a users in oracle?

1088

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4570

---

Explain how are indexes update?

1119

---

What are the numeric comparison operations?

1167

---

How to export data with a field delimiter?

1085

---

What is meant by a deadlock situation?

1153

---

Define oracle database

1096

---

Is rowid unique in oracle?

1043

---