Answer Posted / mohammed rafi uddin

Catalogue means backup contains the information of control file, backup information and tendency of time period and requires no network connectivity.whereas no catalogue having separate database backup information, no limit of time period & It should be network wise connection.

Where do you find the default index fill factor and how to change it? : sql server DBA

1027

---

What purpose does the model database server? : sql server DBA

1101

---

what do you understand by flashback feature of oracle?

949

---

How do you trace the traffic hitting a sql server? : sql server DBA

1467

---

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

1024

---

how does an oracle clusterware manage crs resources?

1030

---

what is the use of recording information about current session?

999

---

how can you implement fine-grained auditing?

1071

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1919

---

What is a system database and what is a user database? : sql server DBA

1116

---

What the different topologies in which replication can be configured? : sql server DBA

1182

---

. 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?

2403

---

what are the differences of where and if in SAS?

2136

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1888

---

What authentication modes does sql server support? : sql server DBA

1141

---