Answer Posted / kittu

Hi,

First query

select username, sid#, serial from v$session where
username='ur_username';

if rows are get selected, then kill the process, by issuing
following statement:

alter system kill session 'sid, serial#';

after that issue the following statement:

drop user username cascade;

how can you find out if a table can be redefined?

1011

---

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

2409

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1078

---

What is dcl? : sql server DBA

1267

---

What is the importance of a recovery model? : sql server DBA

1025

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1066

---

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.

2166

---

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

1934

---

Explain materialized views and how they are used.

2440

---

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

2228

---

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.

2565

---

How to start SQL Server in minimal configuration mode?

7968

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1197

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2358

---

what is the use of recording information about current session?

1051

---