Answer Posted / kittu_chintu2005

CATALOG is used when you use a repository database as catalog.
NOCATALOG is used when you used the controlfile to register your backup information.
Default in NOCATALOG.

what are the types of connection load-balancing?

940

---

what is the role of dip user in our database?

2364

---

What the different components in replication and what is their use? : sql server DBA

1001

---

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

1988

---

Can you redefine a table online?

1061

---

how can a session indicate its interest in receiving alerts?

982

---

how can you record information about current session?

981

---

What is dcl? : sql server DBA

1186

---

What is dbcc? : sql server DBA

1219

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1032

---

which background process invoke at the time of upgradation tell me???

2663

---

Why would you use sql agent? : sql server DBA

1019

---

how can you schedule a job in database?

1043

---

What are statistics, under what circumstances they go out of date, how do you update them?

2195

---

How to start SQL Server in minimal configuration mode?

7811

---