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.

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

1085

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1109

---

how can a session indicate its interest in receiving alerts?

1048

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1119

---

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

1976

---

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?

1986

---

how can you find out if a table can be redefined?

1019

---

what functionality does oracle provide to secure sensitive information?

1002

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1051

---

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

1199

---

how can you communicate with operating system files from oracle?

1054

---

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

2721

---

what are the differences of where and if in SAS?

2197

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2048

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

999

---