Answer Posted / rrr2009cse@gmail.com

while moving tables to the other tablespace the indexes has been unused due to movement of segments(tables). to reuse previous index on a table has to be rebuild
alter index indxname tablespace

how can you record information about current session?

1105

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2615

---

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

2269

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4479

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1058

---

how can you schedule a job in database?

1193

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1999

---

who owns the operating system files created by the utl_file package?

1126

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2217

---

What is a correlated sub-query? : sql server DBA

1157

---

What would you do with an "in-doubt" distributed transaction?

1939

---

What is the default port no on which sql server listens? : sql server DBA

1222

---

What is dbcc? : sql server DBA

1353

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2017

---

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

1265

---