Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

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,

---

what is a user-defined lock?

0 Answers   Oracle,

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

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

0 Answers  

---