Explain materialized views and how they are used.

0 Answers  

---

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

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

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

0 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

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

0 Answers  

---

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

0 Answers  

---