-
Backup & Recovery
The tape device of datafile of 1GB, while you are taking backup to disk, a user enters and access/modifies the database, where will this data be stored?
-
Database Performance Observation
A user reports that his database is running slow, after 2 days it runs fast, what is your observation?
-
Last Data Refresh Details
Where can we see the last refreshed details of the Database (from Some other Environment Database) or Restored (from some backup)
-
Cancel Automatic Recovery
How to cancel an automatic recovery in standby database?
-
Starting Oracle Services
How to start Oracle services manually for Oracle database?
-
Trigger to invoke a Stored Procedure
How to write a trigger in order to invoke a stored procedure in Oracle?
-
Cache Hit Ratio
What is cache hit ratio in Oracle 9i?
-
Configure LANFree Backup Using TSM
How to configure the LANFree backup using TSM in TBM AIX Platform?
-
Hot Backup Excessive Log
What is meant by excessive log in hot backup?
-
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?
-
PGA_AGGREGRATE_TARGET Parameter
What is PGA_AGGREGRATE_TARGET parameter?
-
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?
Oracle Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans