Interview Question List

General Questions

1) what is block, extent, segment?
2) what are main background processess of Oracle?
3) What are main components of Oracle Database instance?
4) How the query will be executed in Oracle database?
5) what is the function of SMON and PMON?
6) what is SCN and what is use of SCN?
7) what is checkpoint and what is use of it?
8) what are redo log file states? (active, inactive, current and unused)
9) Why do you run orainstRoot.sh and ROOT.SH once you finalize the Installation?
10)What are new features of 11g?
11) What is SGA_TARGET and SGA_MAX_SIZE?
12) How oracle database recovery is done ie transaction recovery and rollback?
13) How to increase library pool size?
14) how to add redo log member ?     
15) How to add undo tablespace and remove old undo tablespace?
16) What is MEMORY_TARGET and MEMORY_MAX_TARGET ?
17) what is ora-1555 error? why it is raised and how we can overcome it?
18) what is  Quiesce and suspend state of database?

19) How user connection is established to database?   

RMAN

1) Difference between differential and cumulative incremental backups?

2) Rman convert datafile command?

3) catalog and auxiliary database

4) rman duplicate database command

5) obsolete, expired and crosscheck command

6) alter system archive log current vs alter system switch logfile;
7) how to catalog backup piece?

8) how do you know what all databases are registered in catalog database?

9) views to monitor rman task status?

10)How to recover corrupted block? v$block_corruption

11)How to create catalog database and register database in catalog?

12)what is block change tracking?

13)How to check the status of backup? whether it is running or hanged?

Dataguard

1) What is failover, switchover and how to perform it?

2) Data guard configuration parameters?

3) How to setup data-guard?

4) How to recover standby database, if one of archived log corrupted?

5) Dataguard background processes?

6) Dataguard protection modes?

7) Dataguard data dictionary views?

8) why force logging is needed?          

9) Difference between physical and logical standby?

10) DGMGRL utility?

11) What is active dataguard?

12) How to open standby database in readonly and managed recovery mode?

13) what is snapshot standby?

ASM

1) How to check status of re-balance activity? or stripping?

2) how to find mirrored blocks?
3) Coarse-Grained Striping vs Fine-Grained Striping

4) what are background processess of ASM?

5) what is mirroring and striping?

6) How to create tablespace in ASM?

7) How to add space to datafile in ASM?

8) what is use of asm_power_limit and au_size?

9) Parameters specific to ASM? or Parameters which are different than database?

10) Advantages of ASM?

11) How to copy asm files to normal disk?

12) How to create diskgroups?

13) Upgrading/patching ASM?

14) adding disk to diskgroup?

15) what is ACFS?

16) Important ASM data dictionary views?

17) ACFS command line tools or commands?

RAC

1) what is voting disk and OCR?

2) why odd number of voting disks?

3) can we store voting disk and OCR in ASM?-- Yes since 11gR2. Also we can access OCR file even if cluster services are down.

4) How to backup voting disk and OCR?

5) Background processes of RAC?

6) How cache fusion work? 

7) How SCAN(Single Client Access Name) listener work?

8) what are other vendor to provide cluster solutions?

9) what is TAF (Transparent Application Failover)?

10) How to backup RAC database? RMAN backup?

11) How to upgrade/apply patch to RAC database?

12) Adding new node to RAC?

13) Removing node from RAC database?

14) OCR and Voting disk backup restore, check status?

15) srvctl and crsctl commands?

16) How to refresh single instance database from RAC database backup?

17) Advantages of RAC?     

18) What is VIP? and its use?