Answer / kittu

SERVER PROCESS

wat is global index and local indes

1 Answers   Oracle,

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

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

0 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

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  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

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

4 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---