Oracle DBA (Database Administration) Interview Questions
Questions Answers Views Company eMail

What is main function of database administrator?

402

What are the different types of database users?

398

What does database administrator do?

392

What degree do database administrators need?

399

What is the main function of database?

426

What are the types of schemas?

397


Post New Oracle DBA (Database Administration) Questions

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

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

411


What is the dba role in oracle?

406


What are the steps involved in instance recovery in oracle?

400


How many control files should you have? Where should they be located?

406


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?

412


What database block size should I use?

518


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

401


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

408


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

409


What is a junior dba?

426


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

444


Why are recursive relationships bad? How do you resolve them?

418


How does one create a new database?

431


What do you understand by a control file?

383


Tell me about standby database? What should we watch out for?

397