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 do you trace the traffic hitting a sql server? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you implement fine-grained auditing?
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?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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
Where would you look for errors from the database engine?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How can you control the amount of free space in your index pages? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
