What skills should a dba have?

529

Explain force logging feature in 9i.

573

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

540

What is oracle full backup?

529

What is dba training?

501

Are database administrators in demand?

522

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

545

I have applied the following commands: now what will happen, will the database will give an error / it will work?

515

What are types of data model?

503

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?

584

Explain the term 'oracle grid architecture'?

546

What is the difference between sga and pga?

565

How would you find total size of database in os level?

520

What is difference between co-related sub query and nested sub query?

532

What does a dba do all day?

510