Oracle DBA (Database Administration) Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle DBA (Database Administration) Interview Questions

Questions Answers Views Company eMail

How can be determining the size of the log files?

577

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

571

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

576

How can you tell if a tablespace has excessive fragmentation?

595

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

587

What is a database instance?

583

Which is the best option used to move database from one server to another serve on same network and why?

540

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

662

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

572

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

565

How can you find your id on a system?

561

What os user should be used for the first part of an oracle installation (on unix)?

542

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

567

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

596

Why are recursive relationships bad? How do you resolve them?

575

Post New Oracle DBA (Database Administration) Questions

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

What degree do database administrators need?

543

How does one create a new database?

583

What is the difference between cold backup and hot backup?

579

What are some indications that you need to increase the shared_pool_size parameter?

552

What is da in database?

541

How to drop an oracle database?

557

When configuring sqlnet on the server what files must be set up?

632

What is pct free/pct used/pct increase parameter in segment?

572

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

609

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

574

What does >> do?

577

What is oracle dba role?

569

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

567

What is the difference between truncate and delete? Why is one faster?

643

What are the five functions of a database?

604

For More Un-Answered { Oracle DBA (Database Administration) } Questions Click Here