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.
570What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
584If 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?
536What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
551Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
617Post New Oracle DBA (Database Administration) Questions
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
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.
Which dba certification is best?
You see multiple fragments in the system tablespace, what should you check first?
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?
What is a dba programmer?
How can I learn oracle dba?
How many dba can you have?
What does database administrator do?
What is the purpose of the grep command?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
What is your favorite tool for day-to-day oracle operation?
What are the types of locks in database?
What are the main functions of dba?
What is end user in database?
