What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

609

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

638

What is oracle partial backup?

640

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

663

What does database administrator do?

617

What is the difference between sga and pga?

667

If you see statistics that deal with "undo" what are they really talking about?

702

How many dba can you have?

579

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

582

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

639

How many databases should a dba manage?

696

What exactly does a dba do?

624

How can you tell if an index on particular table is used or not used in 9i?

598

What are database skills?

633

How do you set up your tablespace on installation level: low?

602