-
Hot Backup Excessive Log
What is meant by excessive log in hot backup?
-
PGA_AGGREGRATE_TARGET Parameter
What is PGA_AGGREGRATE_TARGET parameter?
-
Delete Disks From ASM
How to delete disks from ASM, Delete Disk Groups from ASM when ASM instance is mount state. Provide ASM INSTNACE creation steps.
-
Oracle Database Size
How we can increae Oracle Database Size?
-
Wrap
What is Wrap?
-
Offload Query Processing
Why we need both the SID and the Serial no's to kill the session?How to offload query processing from the Production DB to Standby DBWhy some times startup /as sysdba starts only the instance (Why not opening the DB)Explain the Functionality of sqlplus /nolog?
-
Constraints and Validations
What is the difference between Constraints and Validations?
-
Oracle Catlog & Oracle Archive Log
What are Oracle Catlog & Oracle Archive Log?
-
Growth Factor
What is Growth Factor?
-
Dump Destination
What is dump destination?
-
TableSpaces and PCTIncrease
What is PCTIncrease in Oracle? How the memory is allocated, reallocated and autoextended while creating tablespaces? What is meant by initial and default in tablespaces and How the next is a multiple of five times DB_BLOCK_SIZE?
-
Run Tme Database Decision
How we can decide at run time that which database is going to use among Oracle, SQL Server, MS Access and so on available databases?
-
Distribution Table
In the hint, pq_distribute, which is the outer distribution table and which is the inner distribution table?
-
Access 2010 moving from one record to another
I am now using an Access program that was created years ago and I used it 5 yrs ago and am now back - and when I attempt to go from 1 record to another with the arrows at the bottom - it use to scan very quickly and now I have to click on the arrow each time to make it go from one record to another. Is there an easy way to make that move quickly without having to click on the arrow each time?
-
Disk have become damage and we have datafile on it.
I have some datafiles were there on a secondary disk and that disk has become damaged and new disk at this time not available. How will I recover from this situation?
thanks in advance.
Ibrahim -
Oracle Production support common issues ?
Hi I want to know what are thw common oracle production support issues that we face when we deal with banking domain and as general too.
-
Cursor for loop and open, fetch,close
What is the difference of using cursor for loop and open,fetch,close. Which one is better? Both are giving same output
Oracle Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans