What are the different responsibilities of a dba?
How does one create a new database?
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?
System tablespace cant be exported from one database and imported into another why?
You see multiple fragments in the system tablespace, what should you check first?
What does a dba do all day?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
How can be determining the size of the log files?
What is the easiest method to create a file on unix?
What are some indications that you need to increase the shared_pool_size parameter?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
When should you increase copy latches?
What are the goals of dba?
Which is the best option used to move database from one server to another serve on same network and why?
How can you find out how many users are currently logged into the database?