ORACLE DBA INTERVIEW QUESTIONS (L2)

####################ORACLE DBA INTERVIEW QUESTIONS (L2)#####################


which backup strategy would you choose to have less MTTR for your database?

what steps will you perform to recover your database running on asm instance to bring it in consistence and open mode describe it from scratch, think of it as you have lost all of your data plus database software?

what does recover database command does at back-end?

what can cause a stored pl/sql procedure to go in invalid state?

what type of table partition you know?

what are the different type of redundancy of disk in rac/asm management?

what is the difference between view and materialized view?

what are the possible ways to bring you objects (pl/sql or function) back in valid state from invalid state.?

is it a problem to have an object in invalid state in your database.?

suddenly your database backup is taking time much higher than usual, what checks will you perform in order to identify the issue.?

how to start and stop cluster services.?

will running "crsctl stop crs" command stop the ohas service as well.?

tell me the difference between  global partitioned, global non partitioned and local indexes.?

difference between cumulative and differential incremental backup?

team size?

hobbies?

how you plan to interact with team members sitting across the globe?

what measure and precaution will you take in case of a situation when a application guys reports you that some heavy activity is going to happen on a database on a particular period of time, please monitor the database.?

can you explain the range partitioning?

which parameter is required to send archive files from primary to standby database.?

steps to convert a physical database to snapshot and vice versa?

how to schedule a expdp job via pl/sql?

what are your strength ?

why you want to switch?

what do you do in daily basis?

how to configure oracle asm on a server?

suppose there are two schema A and B, there are few procedure and function in schema A which i need to import in schema B, what option do you have here.?

We have two database instances.
on instance A, i have set the sga_target=0 and sharedpool size =2GB
on instance B, i have set the sga_target=10GB and sharepool size=2GB
Please descibe how these are different and way of assigning the memory.

if number of defined partition is over and there is an insert which does not fall under the mentioned partitioning condition, where this data will go in table.?

How will you bring the data from the default partition to the newly created partition? what will be the feasble way of doing it for a huge amount of data.?

which backup piece you will restore first L0 or L1?

How recover database command tackle's with L0,L1 and archivelogs in order to do recovery?

how do you approach for the troubleshooting ?

how do you handle the block corruption and what action can be taken.?

what is the last situation you tackled in your account w.r.t trouble shooting?

what else skill do you have?

how good are you at pl/sql?


Thanks & Regards
Nikhil Kumar.

Comments

Popular posts from this blog

TNS-12541 TNS-12560 TNS-00511 TNS:protocol adapter error No listener

How to set the root password after creating instance on oracle cloud