How can you enable a trace for a session?

1 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---