Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  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?

 217

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

 198

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

 207

Explain procedure to change characterset of a database.

 241

What is oracle archived redo log?

 207

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

 189

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

 207

List five most important parameter in 9i affecting performance?

 202

What is the difference between rman and a traditional hotbackup?

 1 581

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

 194

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

 209

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

 202

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

 187

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

 222

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

 194

Post New Oracle DBA (Database Administration) Questions

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

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?

186

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

194

What is tkprof and how is it used?

195

How can you determine the number of sqlnet users logged in to the unix system?

194

What is the difference between cold backup and hot backup?

215




How can you determine the space left in a file system?

258

What does dba stand for in technology?

194

What degree do database administrators need?

196

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

215

What do you mean by oracle dba?

206

What is the difference between raid 5 and raid 10? Which is better for oracle?

210

How do I become a dba?

213

I have applied the following commands: now what will happen, will the database will give an error / it will work?

177

What do you mean by oracle dba and what is its role?

187

How many databases should a dba manage?

205

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