Answer / pallavi

cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within sql statement

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

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  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---