Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bharath
explain plan for select * from t1 where num_col = '1';
select * from table(dbms_xplan.display);
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how does an oracle clusterware manage crs resources?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Explain materialized views and how they are used.
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.
What happens on checkpoint? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What authentication modes does sql server support? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what do you understand by flashback feature of oracle?
what is a crs resource?
