Answer / ramakrishnachallapalli

To take both backups we should keep database in archive log
mode.

Neither cold backup nor hot backup identify the corrupted
blocks in backup where as rman can identify

RMAN will take the backup of database used block only where as
hot backup will take physical existing database files
completely

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

what are the differences of where and if in SAS?

0 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---