How does one coalesce free space?
What is pga_aggregate_target?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What is main function of database administrator?
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?
What are types of data model?
How do you analyze table partition using oracle provided package?
What command is used to type files to the screen?
Who is a database user?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
Which function is used to find the largest integer less than or equal to aspecific value?
What exactly does a dba do?
What is a dba?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?