Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

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

1 Answers   CTS,

---

what is the role of dip user in our database?

0 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

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

0 Answers   Oracle,

---

---

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?

1 Answers  

---

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

2 Answers  

---

how to restore files with rman?

0 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

what is asm?

0 Answers   Oracle,

---