Hello friend, Please could you answer these Interview questions in the best strong short convincing form. Thank you. Tag the questions with answers.
1, What does active duplicate database do. explain briefly
2, Can you run Rman duplicate without connecting to target database. explain briefly
3, What are the special things to do on backup on tape
4, Restore database preview summary. explain briefly.
5, Explain different kinds of retention policy.. explain what they are and the differences between.
6, Do you have to have flashback enabled to create a guarantee restore point and why.
7, Is there anything else oracle uses when you run a flashback database. explain briefly.
8, Is there anything Rman requires the catalog that is mandatory. explain briefly
9, How do you take old database export from one database and import it to brand new database.
10, When do you have to open database to reset log. and Are you able to restore a reset log from backup that was done yesterday. explain briefly
11, what are the basic mandatory background processes. explain briefly.
12, Can you update a table on a limited specified amount buffer.. The buffer cache can only hold 1000 blocks and your updating 10000 blocks, Also what will happen if database crash during all this.
13,What does undo_retention parameter does. explain briefly.
14, what are the specific steps to upgrade from 10g to 11g.
15, when do you change compatibility during upgrade.
16, what does logical backup do. explain briefly.
17, explain the different between expdp and import and export. explain briefly
18, what happens when you put a table space in begin backup mode. explain briefly
19, what is fractured block and what does it do. explain briefly
20, The different between obsolete and Expired
21, How do you check status on obsolete and expired backup
22, What does control file auto back on does.. explain briefly
23, what does control file auto backup off does. explain briefly
24, How to check status on the obsolete and expired backup
25, What is the different between backup crosscheck and validate
26, What happens when you set control file auto backup on.
27, What do you do with logical standby database
28, Are anyone allowed to change logical standby database
29, Does data guard provide a mechanism for a functionality to prevent updates to the object
30, Using logical standby for upgrades.. Explain briefly
31, How to approach and to fix if there's error on logical standby. explain briefly
32, what's the different between skip transaction and skip error. explain briefly
33, How do you configure active data guard and what does it do. explain briefly
34, What's common tactic to resolve gaps. explain briefly
35, What's the common issues does active data guard has.
36, When you setup a redo transport what would you do to take the new transport to the standby you just created.
37, Describe transport mode and what it does
38, What is maximum protection and what does it do.
39, If your on maximum mode how many standby do you need to have.
40, What is snapshot standby and what does it do.
41, What is farsync and what does it do.
42, Issues with physical standby. explain briefly
43, Active guard. explain briefly
44, Different protection modes with data guard, explain briefly
45, What is snapshot standby
46, How do you resolve gaps on a physical standby
47, How do you stop and start the MRP process on multiple nodes in RAC