You see multiple fragments in the system tablespace, what should you check first?

584

What is the difference between truncate and delete? How would a full table scan behave after?

552

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

590

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

616

How can you determine the number of sqlnet users logged in to the unix system?

574

As an oracle dba what are the entire unix file you should be familiar with?

579

How do I become a data manager?

527

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

587

What is a production dba?

606

What is dba in sound level?

583

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

566

How many types of dba are there?

568

You have taken a manual backup of a datafile using os. How rman will know about it?

552

How do you set up tablespaces during an oracle installation?

606

How does one coalesce free space?

550