Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

How many memory layers are in the shared pool?

3 Answers  

---

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

How can you enable a trace for a session?

1 Answers  

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---