Answer Posted / manish

catalog means backup information store in control file as well as catalog database.

nocatalog means backup information store in only control file no other external repository

What are the commands used in dcl? : sql server DBA

997

---

how can you enable flashback feature?

896

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2411

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2582

---

what is asm?

996

---

What happens on checkpoint? : sql server DBA

1035

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2617

---

What the different types of replication and why are they used? : sql server DBA

1107

---

how can you communicate with operating system files from oracle?

983

---

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

2401

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1665

---

What is the importance of a recovery model? : sql server DBA

970

---

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

1063

---

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.

2098

---

What are the steps you will take to improve performance of a poor performing query?

2794

---