1) What are the common questions asked in DBA interview? 2) Kindly give me important tips for attending DBA interviews.3) What size of database you handled? What should be the expected answer?4) Expectation of RMAN knowledge.5) What is the normal backup strategy use in your company & in market?6) On which OS you are working?7) How we should quote our salary?8) How many times you have done pl/sql coding while working as a DBA?9) What are the common DBA activities you do on daily basis?10) For @ 3
How do you find the total database size in the database, is there any command to see the database size or in os level?2.can we unload the data by using sql*loader?3.can we take incremental backup with out taking complete backup?
The ORACLE db is running with session audit and the audit table is full. What happens to new sessions? Nothing, They are not audited New Connections are Not Allowed Session allowed, with audit to alert.log
Latest Answer : What is this ? Please post individually ...
At the time of hot backup lot of redo will be generated how to reduce that redo generations
How to take backup using RMAN backup, without catalogdb?
Latest Answer : How to connect to RMAN without catalog ...
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?
Where can we see the last refreshed details of the Database (from Some other Environment Database) or Restored (from some backup)
How to cancel an automatic recovery in standby database?
How to configure the LANFree backup using TSM in TBM AIX Platform?
Where will the transactions be stored during Hot Backup?
During hot backup we specify the tablespace during beginning backup mode and now if a user perform some transactions then where such transactions