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?

557

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

540

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

527

Explain procedure to change characterset of a database.

573

What is oracle archived redo log?

550

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

520

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

519

List five most important parameter in 9i affecting performance?

516

What is the difference between rman and a traditional hotbackup?

1 1373

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

533

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

531

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

563

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

529

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

544

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

534

Post New Oracle DBA (Database Administration) Questions

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

If you have an example table, what is the best way to get sizing data for the production table implementation?

510

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

539

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

538

What database block size should I use?

673

What are the possible ways to gain information regarding the control file?

515

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

594

I am getting error "no communication channel" after changing the domain name? What is the solution?

551

Explain the various modes of normalization?

502

What do you mean by dba?

533

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

536

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

652

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

537

What should a dba know?

490

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

511

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

548

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