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 would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

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?

0 Answers  

---

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

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

0 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

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  

---

what is asm?

0 Answers   Oracle,

---