Interested to Buy Any Domain ? << Click Here >> for more details...
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.
652What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
677If 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?
623What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
675Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
696Post New Oracle DBA (Database Administration) Questions
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
Which function is used to find the largest integer less than or equal to aspecific value?
When should the default values for oracle initialization parameters be used as is?
What are the five main functions of a database administrator?
Who is dba in dbms?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What are the various ingredients of sga?
When should you increase copy latches? What parameters control copy latches?
How to uncatalog backup?
What is pga_aggregate_target?
Which database is best to learn?
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?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
