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

What is main function of database administrator?

281

What are the different types of database users?

278

What does database administrator do?

253

What degree do database administrators need?

276

What is the main function of database?

283

What are the types of schemas?

273


Post New Oracle DBA (Database Administration) Questions

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

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

273


Who is a database user?

276


What database block size should I use?

396


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

281


Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

273






How can you find dead processes?

278


What do you understand by the term 'normalization'? Explain the various modes of normalization?

259


What is end user in database?

297


What are the steps involved in instance recovery in oracle?

279


What is oracle full backup?

274


How can you find all the processes on your system?

293


What is an artificial (derived) primary key?

263


What are the important tasks of common oracle dba?

277


What do you mean by oracle database?

261


Explain the wait events in statspack report 'db sequential real'?

279