Answer / gogune suresh kumar

Returns multi set data(records) that are subsequently used in
data transformations.

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

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 can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

How would you force a log switch?

4 Answers  

---