oracle interview questions

1. Tell me about ur responsibilities in your project ?

2. How amny database instance do u maintain ?

3. Backup information in ur environment ?

4. Is it necessaryto restore the entire database when system datafile is corrupt r removed ?

5. How will you restore & recover system datafile ? Do we need to give resetlogs after recovering the datafile , is yes explain if no y ?

6. What is a cpu patch & psu patch ?

7. how will u apply psu patch ?

8. Abbrevation of psu & cpu ?

9. Types of clonning ?

10. Explain rman clonning steps ?

11. What is rac ?

12. How amny nodes do u have ?

13. How to apply patch in RAC database

14. 10g to 11g migration steps ?

15. What do u know abt performance tunning

16. What all u have done in tunning

1. How will configure ASM and data guard in RAC environment
2. What is SCAN listener
3. How will tune single node in RAC.
4. How will apply Patch in RAC.
5. What is HOT and Cold Cloning. Give steps
6. Upgrade DB in ASM with RAC environment
7. How will find Performance drop in DB
8. If we need Log file backup for Cold Cloning..? Yes means why..? No means why..?
9. If DB was crashed in RAC without backup of OCR and Voting Disk. Hw will you recover the DB.
10. Explain plan and TKPROF explain

1. Tell about your profile?

2. Day to day activities?

3. How to check flash_recovery enabled or not?

4. Dbv uses?

5. If two node using rac and archive are going to these two nodes,if we had 3rd node as non rac active standby ?what I have to do ,so that archive to go to 3rd node?

6. Row chaining and row migration? How to avoid row chaining?

7. Dataguard modes? And what parameter is used to set for that modes?

8. Oracle background process?

9. When checkpoint occur?

10. 10g and 11g difference?

11. What is the use of diag in 11g?

12. Trace location in 11g and 10g?

13. Opatch ? when evenly they release patches?

14. Patching steps?

15. What you will do when error occur during patching?

16. What ticketing tool using?

17. What is catbundle?

18. What kind of refresh and all done? What tool used for that?

19. How to create tablespace with blocksize of 16k?

20. Dirty buffer? How the dirty buffer will get clear/

21. Which process write the data in  buffer memory?

22. Instance recovery?

23. How you will connect database to client?

24. Obsolete backup? How you will use the obsolete backup as valid?

25. What happen when we set init trans parameter as 0?

26. Rman cloning steps?

27. Auxilary use?

 Tell   about   urself  and day to day activities ?

1. Patching  steps  for psu ?
2. Upgradation for 10 to 11g    steps?
3. Is it possible for  reuse for logfiles ?
4. If 1000 archives missing in  standby database what u will do ? explain the steps?
5. Ur backup strategies in ur environment  ?
6. Rman cloning   steps in oracle ?explain step by step procedure
7. How to refresh ur database in oracle ?
8. What is meant by mrp process ?
9. How to stop mrp process ?
10. Why we have  to run catlog and catproc ?
11. Which   ticketing tool utility u have to use in ur environment ?
12. DIfference between hot cloning and cold cloning?
13. Difference between consistent backup,inconsistent backup and logical backup ?
14. Asm advantages ?why we have to use asm instance ?
15. How many servers u have to maintained ?
16. How many db’s u have to handle ?
17. Whats ur role in ur project ?
18. Why we have to run catbundle ?
19. What are all the background process in asm ?
20. In awr report  what r all u have to seen in tat report?
21. Any five wait events u have to tell about cause and solutions ?
22. Explain between level 1 and level 0 backup?
23. In ur environment which incremental backup ur preferable ? cumulative or differential ?
24. If ur patch is apply wrong ly,how can u recover for original state ?
25. What is rollback patch ?

1. tell briefly about yourself
2. what is day to day activites
3. will you write scripts in shell
4. what all necessary scripts required for a db
5. what all assistance tools we have in oracle
6. what are all levels of auditing
7. how to encrypt db files
8. what all information we can see in v$logminer_contents
9. how to check index fragmentation
10. diff b/w v$instance and gv$instance
11. diff b/w oracle home and oracle base
12. Rac wait events
13. what is ocr
14. what is GRD
15. migration steps
16. upgradation steps
17. Will create tablespace have a entry in RLBC
18. how to get metadata of a table
19. how you will change db name
20. In which language oui installer in designed
21. what is change management
22. full statement to create a user
23. what all statements wont have entry in RLBC
24. can v coalese LMT
25. any one 12c feature

Infosys Questions(25.08.2015)

1. Tell me about  yourself

2. Day to day activities?

3. Do you have work experience in RAC and ASM

4. How will you check database growth?

5. What is meant by patches?

6. Have u done upgradation? Tell the steps?

7. Steps for schema refresh?

8. Backup strategies?

9. I have 1,2,2 gb sizes in 3 different disks. How will take backup in expdp?

10. Tell the command for rman active cloning?

26. How you will remove ASM from RAC

 Step for upgrade from 10g to 11g

2. If i have 10 materilized view, all 9 are sync properly and one view is not sync. How you give solution.

3. Why 11g DB start with Undo TBS.

4. 11g Arc

5. How will u recover if DG failure in ASM.

6. Difference between One way and two way Mirroring

7. Steps to convert Non ASM to ASM and Why we take backip before convert and change name for Control file

8. Data Guard Modes and Explain

9. If archive was not sync properly means how you give solution

10. If u have one standby and some archive was miss at standby, if you have perform switchover. Tell the steps and hw u recover those missing archive

11. Why u kept FAL_ClIENT and FAL_SERVER parameters

12. How will you apply missing archive from one standby to another standby

13. RMAN Cloning

14. If I have Level 0 backup and i took level 1 differential for Monday, Tuesday. Now am going to take level 1 Cumulative at wednesday. Which backup is base backup for Cumulative backup. (Vice Versa)

15. Migration from Windows to Linux

16. Why we give REMAP SCHEMA and REMAP TABLESPACE parameter in imp/exp

17. Different between import and Data Pump.

18. Different between HOT and COLD backup.

19. Why you give ALTER DATABASE OPEN RESETLOG, If you provide that commend what happen the prev archives.

20. Explain HOT CLONING and COLD CLONING.

21. Why u change REUSE to SET in control file.

22. If the query is not respose properly. Hw will give solution on that.

23. What you do initial level of Tuning

24. Hw will force index to the table

25. If an object was move from one tbs to another tbs. Hw will you recover Index and Partition.

26. Startup and Shoutdown stages and Explain.

27. Hw will you change segment parameters.

28. Explain deadlock

29. What is ORA1555 error

30. IF RAC have two nodes one node was failure which process will take care of switching. Hw will check RAC health.