deleted of control file how will u recover control file?

4 Answers   CTS,

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

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  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---