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?

 329

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

 303

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

 320

Explain procedure to change characterset of a database.

 350

What is oracle archived redo log?

 312

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

 292

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

 307

List five most important parameter in 9i affecting performance?

 301

What is the difference between rman and a traditional hotbackup?

 1 810

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

 297

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

 309

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

 293

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

 289

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

 320

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

 288

Post New Oracle DBA (Database Administration) Questions

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

Who is dba in dbms?

309

How can you tell if a tablespace has excessive fragmentation?

335

What skills should a dba have?

303

When should you increase copy latches?

291

How can you find your id on a system?

290




What does dba stand for database?

318

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

306

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

327

What is dump destination? What are bdump, cdump and udump?

307

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.

327

System tablespace cant be exported from one database and imported into another why?

302

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

307

What happens when the default and temp tablespace clauses are left out from create user statements?

323

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

310

What are the main functions of dba?

290

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