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

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

 292

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

 357

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

 265

If you have an example table, what is the best way to get sizing data for the production table implementation?

 277

What file will give you oracle instance status information? Where is it located?

 277

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

 283

How would you find total size of database in os level?

 283

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

 355

What is an artificial (derived) primary key?

 263

What is different type of rman backup?

 312

You see multiple fragments in the system tablespace, what should you check first?

 277

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

 266

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

 298

How do you set up your tablespace on installation level: low?

 283

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

 335

Post New Oracle DBA (Database Administration) Questions

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

What happens if the constraint name is left out of a constraint clause?

272

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

262

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

300

How long does it take to learn database administration?

280

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

278




You see multiple extents in the temporary tablespace. Is this a problem?

261

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

266

How can you find all the processes on your system?

291

How can you find out how many users are currently logged into the database? How can you find their operating system id?

250

How do I become a data manager?

259

If you see statistics that deal with "undo" what are they really talking about?

378

What is oracle log switch?

290

What should a dba know?

259

What skills does a dba need?

301

How many redo logs should you have and how should they be configured for maximum recoverability?

288

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