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

What is the use of the drop option in the alter table command?

591

How do you use automatic pga memory management with oracle 9i and above?

572

Which function is used to find the largest integer less than or equal to aspecific value?

558

Explain procedure to change characterset of a database.

608

What is oracle archived redo log?

581

what does the no logging option do? Why would we use it?

546

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

551

List five most important parameter in 9i affecting performance?

551

What is the difference between rman and a traditional hotbackup?

1 1438

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

557

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

564

What does the no logging option do? Why would we be careful of using it?

594

Tell me about standby database? What are some of the configurations of it?

563

When using oracle export/import what character set concerns might come up? How do you handle them?

580

Which date function is used to find the difference between two dates?

572

Post New Oracle DBA (Database Administration) Questions

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

What is oracle log switch?

603

What are the various ingredients of sga?

559

When configuring sqlnet on the client what files need to be set up?

633

What are the main benefits of using spfile over pfile?

629

Are database administrators in demand?

558

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.

576

Is oracle dba in demand?

584

What is the purpose of the import option ignore? What is its default setting?

593

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

572

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

599

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

543

What happens if the constraint name is left out of a constraint clause?

536

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

545

What are four common errors found in an alert .log?

555

How can you determine if an oracle instance is up from the operating system level?

552

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