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 operator tests column for the absence of data?

 295

System tablespace cant be exported from one database and imported into another why?

 286

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

 285

Explain the wait events in statspack report 'db scattered read'?

 279

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

 255

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

 287

What is difference between co-related sub query and nested sub query?

 300

What is oracle full backup?

 279

What is pga_aggregate_target?

 300

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

 311

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

 351

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?

 301

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

 267

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

 270

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

 380

Post New Oracle DBA (Database Administration) Questions

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

What do you mean by dba?

281

Which rman command is used to create an exact replica of a database innew host?

270

What does dba stand for database?

301

What is the meaning of database backup?

287

What are the different types of backup available in the oracle?

300




What degree do database administrators need?

278

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

273

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

363

What are the important tasks of common oracle dba?

281

What skills should a dba have?

289

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

269

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

286

What is pga_aggregate_target?

300

How do you set up tablespaces during an oracle installation?

296

What happens if a tablespace clause is left off of a primary key constraint clause?

297

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