Oracle DBA Questions

Oracle DBA QUESTIONS


Architecture
==========


11G New Features @ Architecture level? RESULT Cache,...


11G Backgroung Processes?


Literal Vs. Bind Variables?
Select * from emp where dept=10; what level should i configure for better performance Where Clause .... Literal or Bind Variables? Expalin?


Incarnation? Explain in detail? Where the incarnation information will be stored?


What happens when we give command ALTER DATABASE OPEN RESET LOGS?


What is SCN? SCN vs Sequence Number?


Hard Parse Vs. Soft Parse?


Backup&Recovery
=============
My Database has Level 1 backup, tell me what are all backed up ? with Example?


Databse is UP and has taken Level 0 backup, is the backup taken is Consistent or Inconsistent?
How do you say a backup is Consistent or Inconsistent, Oracle Terminology?


Can we take backup when the Database is down?


If i have backup of Sun @9PM, on Mon 9PM taken incremental Level 1 backup. What type of backup do you get and what is actually backedup?


A table got dropped between 9AM - 11AM how to get the Table backup using RMAN, DB size 500GB available mount point space for table recovery is 15GB?


Sys Admin has changed the time from 10:00 AM to 9:30  AM, table dropped, How do you recover the Table?


Performance Tuning
==================
As a DBA what Pro active steps do you take for a Highly utilized Undo?
AWR Vs. ASH?
AWR Contents?
Wait Events?
Difference between DB File Sequential Read and DB file Scattered Reads?
Database Replay?


Datapump
========
How Datapump  works internally? What resources will be utilized at Network level, in Memory level?
How to Export Dumpfile to different mount points (multiple dumpfiles) sametime both in EXP and EXPDP,  as the destination has less space available?


Dataguard
========
What is Active Dataguard?
What is Snapshot Standby?
Primary DB Dataguard Parameter?
Parameters responsible for Failover in Dataguard?
Difference between FAL_SERVER (Fetch Archive Log) Vs. FAL_Client
What is RFS?
What is DELAY?
By default in what mode will the Standby will be, either SYNC or ASYNC?


RAC
===
SCAN?
LMON?
VIP?
TAF?
FAN?
OCR?
VD?
How to take VD backup?
How to take OCR backup? Do you take OCR backup?
How do you know which is the Master Node without connecting to Database?


Cloning
=======
What is Cloning?
How to do take RMAN Cloning? Explain Steps?


MISC
====


RAC:
1) About OCR and VOTING files?
2)Cache Fusion?
3)Cache coherence?
4)Node evicted scenario?
5)what is SCAN_LISTENER?
6)OCSSD?
7) STAND ALONE DATABASE TO RAC SETUP?
8)how many voting disks using ur organization?


INDEXES:
1)When u rebuild the INDEX?
2)diff b/w Bitmap INDEX and B tree INDEX?
3)reverse key index?
4)local index and global index?
5)PARTITIONS?


1)Explain RESULT CACHE? How to enable and how to disable?
2)when u applied ‘ALTER DATABASE OPEN RESETLOGS’?
3)One of user drop my dept table In prod how to recover it?
4)in RMAN level 11gR2 NF?
5)Cloning of database ? 10g and 11g
6)Explain LOCKs, LATCHES AND ENQUES?
7)DIFF b/w soft parsing and hard parsing?
8)which process bring the data from datafiles to database buffer cache?
9)NF 11gR1 and 11gR2?
10)what is RFS?
11)diff b/w cumulative, differential and level 0 backup?
12)about DB architecture?




1) If one of my mandatory background process goes down what will happen
2) What is SGA_TARGET and SGA_MAX_SIZE
3) What is MMON, MMAN
4) If I keep SGA_TARGET =0 then what will happen
5) In 2 RAC, how many IP’s are r using
6) What is difference between RAC ipaddresses
7) Can application developer access the private ip
8) What is the VIP
9) What is voting disk
10) How many voting disks are u maintaining
11) Why we need to keep odd number of voting disks
12) What is the difference between DG and STANDBY database
13)  What are new background processes are there in 10g and 11g
14) When will use Reset Logs Option?
15) What is OPROCD?
16) ASM Redundancy Levels?
17) Dataguard Parameters?
18) Backup Stratergy u r using?
19) Incremental vs Cumulative Backups?
20) Can application developer access the private ip?



"Hope for the best, prepare for the worst"
-Dharmendra