Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

How many databases should a dba manage?

417

What is the dba role in oracle?

396

What does an oracle dba do?

411

What skills should a dba have?

388

What are roles in oracle?

395

What are the five functions of a database?

426

What are database skills?

413

How do I become an administrator?

398

How do I become a data manager?

354

What skills do you need to be a database administrator?

378

What are the five main functions of a database administrator?

409

How many types of database software are there?

401

How do I become a database administrator?

385

What is the difference between internal & external schema?

472

Are database administrators in demand?

367


Post New Oracle DBA (Database Administration) Questions

Un-Answered Questions { Oracle DBA (Database Administration) }

Who is dba in dbms?

398


What is your favorite tool for day-to-day oracle operation?

353


How can you determine if an index needs to be dropped and rebuilt?

404


You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

623


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

377


What is the dba role in oracle?

396


What happens if a tablespace clause is left off of a primary key constraint clause?

403


What is a database instance?

396


What are the different types of database users?

384


You see a wait on lms process in statspack, what does that mean?

399


What do you understand by the term 'system change number (scn)'?

415


What are the types of locks in database?

410


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

435


What happens when the default and temp tablespace clauses are left out from create user statements?

408


What is the finger command?

407