Answer Posted / gangaram

Should you place Recovery Catalog in the Same DB?
Recovery catalog can be in the same database. but its
recommended by oracle that we need to have recovery catalog
in other DB.

Can you use RMAN without Recovery catalog
Yes we can use RMAN without catalog.
The information gets stored in the control file.
$>connect target / no catalog

is the command.

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

1218

---

What is the default fill factor value? : sql server DBA

1121

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2559

---

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

2713

---

Which autogrowth database setting is good? : sql server DBA

1148

---

What happens on checkpoint? : sql server DBA

1087

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2148

---

What is the difference between clustered and non-clustered index? : sql server DBA

1084

---

what are the benefits of flashback feature?

1019

---

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

1207

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1900

---

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

2036

---

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

2726

---

how can you create a user-defined lock?

1013

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

999

---