What is the difference between truncate and delete? Why is one faster?
No Answer is Posted For this Question
Be the First to Post Answer
What are the possible ways to gain information regarding the control file?
What is difference between logical standby database and physical standby database?
Explain procedure to change characterset of a database.
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
How can you determine if an oracle instance is up from the operating system level?
How should a many-to-many relationship be handled?
What should a dba know?
What are the various ingredients of sga?
Which dba certification is best?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
How long does it take to learn database administration?