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 purpose of the import option ignore? What is its default setting?

 262

Which process writes data from data files to database buffer cache?

 285

When should an artificial (or derived) primary key be used?

 335

Give one method for transferring a table from one schema to another?

 302

How many control files should you have?

 272

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

 299

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

 279

How do you prevent output from coming to the screen?

 263

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

 291

When configuring sqlnet on the server what files must be set up?

 280

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

 259

What are the requirements of simple database?

 288

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

 302

What command is used to type files to the screen?

 285

How can you find out how many users are currently logged into the database?

 323

Post New Oracle DBA (Database Administration) Questions

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

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

380

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

299

What is different type of rman backup?

319

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

297

How can you tell if a tablespace has excessive fragmentation?

315




Explain the term 'oracle grid architecture'?

295

What does an oracle dba do?

308

What are the different types of database users?

282

What command is used to type files to the screen?

285

How do I become a data manager?

264

What is the purpose of the import option ignore? What is its default setting?

262

What is a dba?

286

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

295

What is your favorite tool for day-to-day oracle operation?

255

What should a dba know?

267

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