How does one coalesce free space?

543

What is pga_aggregate_target?

564

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

594

What is main function of database administrator?

561

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?

618

What are types of data model?

544

How do you analyze table partition using oracle provided package?

511

What command is used to type files to the screen?

585

Who is a database user?

534

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

629

Which function is used to find the largest integer less than or equal to aspecific value?

558

What exactly does a dba do?

567

What is a dba?

580

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

659

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

584