Answer / 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 enter substitution variable in oracle?

0 Answers  

---

Explain the use of parfile option in exp command.

0 Answers  

---

Can the default values be assigned to actual parameters?

1 Answers  

---

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

5 Answers   Oracle,

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

0 Answers   HCL,

---

---

What is DTS and purpose of DTS ?

1 Answers   TCS,

---

What is an Oracle sequence?

1 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?

3 Answers   Digital Group,

---

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers   HCL, IBM,

---

Can you use a commit statement within a database trigger?

4 Answers  

---

how to find the second highest salary in a given table????

5 Answers  

---