Answer Posted / nagesh yadav

$ORACLE_HOME/oui
more oraparam.ini
OUI_VERSION=10.2.0.4.0

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.

1989

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1978

---

What authentication modes does sql server support? : sql server DBA

1207

---

what is a crs resource?

1160

---

how can you initialize log miner?

1137

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3405

---

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

1084

---

how can you get actual data change values from previous transactions in oracle?

1085

---

what is a user-defined lock?

1054

---

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

1095

---

what are the benefits of flashback feature?

1019

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1074

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2405

---

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

2106

---

what do you understand by fine-grained auditing?

1051

---