Answer Posted / 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

what is ora 24313?what is the procedure to exclude that error?

2570

---

What is the importance of a recovery model? : sql server DBA

1031

---

how can you schedule a job in database?

1128

---

how can a session indicate its interest in receiving alerts?

1046

---

what is grd?

1101

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1975

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2169

---

How can you control the amount of free space in your index pages? : sql server DBA

1314

---

Why would you use sql agent? : sql server DBA

1091

---

how can you implement fine-grained auditing?

1139

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2815

---

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

2300

---

Can you redefine a table online?

1117

---

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

7921

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1003

---