Answer Posted / sudipta santra

select sum(bytes / (1024*1024)) "DB Size in MB" from
dba_data_files;

If u have the access of the table dba_data_files

what is the difference between functional dependecy and multilevel dependency?

1989

---

What is columnar storage what is the advantage?

544

---

Explain the dml?

591

---

master table and child table performances and comparisons in Oracle ?

1662

---

What is a select query statement in oracle?

543

---

---

What happens if the imported table already exists?

546

---

How to call a stored function in oracle?

572

---

How to get a list of all background sessions in the database?

537

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1801

---

How do I escape a reserved word in oracle?

624

---

What is Undo Management Advisor in Oracle?

609

---

what is port in oracle? how is it related to database application.

1438

---

What are the attributes of the cursor?

553

---

What is a procedure in oracle?

616

---

How to revoke create session privilege from a user in oracle?

555

---