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?

416

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

381

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

409

Explain procedure to change characterset of a database.

436

What is oracle archived redo log?

397

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

393

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

391

List five most important parameter in 9i affecting performance?

396

What is the difference between rman and a traditional hotbackup?

1 1051

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

387

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

390

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

382

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

393

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

407

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

381

Post New Oracle DBA (Database Administration) Questions

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

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

391

How long does it take to learn database administration?

391

Discuss row chaining, how does it happen? How do you correct it?

385

Does a dba have to file taxes?

398

What is the easiest method to create a file on unix?

397

Is oracle dba in demand?

410

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

402

What are the data management skills?

357

Give one method for transferring a table from one schema to another?

408

What kinds of responsibilities does a dba have in a database environment?

416

What is a dba?

407

What is a dba certification?

385

How can you find out how many users are currently logged into the database?

425

What is a junior dba?

413

How do you set up tablespaces during an oracle installation?

387

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