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  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

Can you redefine a table online?

0 Answers   Oracle,

---

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

2 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

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

0 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

Describe what redo logs are.

1 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

What is fill factor? : sql server DBA

0 Answers  

---

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.

0 Answers  

---