1. Categories >> Software >> Databases >> Oracle >> Oracle DBA (Database Administration)
  2. Suggest New Category
Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

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

 382

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

 347

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

 375

Explain procedure to change characterset of a database.

 404

What is oracle archived redo log?

 370

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

 357

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

 360

List five most important parameter in 9i affecting performance?

 362

What is the difference between rman and a traditional hotbackup?

 1 968

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

 348

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

 358

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

 348

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

 354

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

 375

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

 332

Post New Oracle DBA (Database Administration) Questions

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

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

375

What is ora-1555 snapshot too old error? Explain in detail?

429

What are the types of schemas?

338

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

326

What skills do you need to be an administrator?

345




What is end user in database?

369

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

440

What are elements of administration?

370

What do you mean by oracle database?

343

What are the data management skills?

329

Why do we need a database?

357

What are the different responsibilities of a dba?

382

What is dba in sound level?

360

How can you tell if a tablespace has excessive fragmentation?

383

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.

376

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