Interview  questions which are frequently asked for Oracle DBA::

Below questions is for reference for  preparations of interview point.

Answer Links :  Will be shared soon.

List Of Questions:-

*. Tell me your self and roles and responsibilities.

*. What is location of cluster log file.

*. How to Upgrade the opatch utility(IF it is not higher or equal to OUI version) How to apply patch.

*. What are requirement before proceed to 9c Upgrade.

*. How to start scan listener and single instance?

*. In  node RAC one node got rebooted How to proceed to check and start instance?

*. How to clone the user if you have mirror id? Explain in detail each command

*. How to refresh/clone database using particular time or SCN?(till yesterday night

etc) from where you will get scn number,sequence etc

*. In cloning side db is in mount stage after restore controlfile What is db_name

How(production or dev name)?

*. How to add new database to OEM

*. How many databases your are support in your environment and sizes etc(backup          etc)

*. In standby concept

*. Standby side no space left on disk but we didn't check and added datafile in                    primary, How to fix this type of issues?

*. In your whole carrier What are achievements you got from mgmt or anything work      you did alone?

*. How to export table from source to target database(target side schema name diff

and table name also diff) explain in detail with commands

*. What is your password security policy? directly providing password to user or

anything?

*. What is top 5 events in RAC?

*. What is the highest database size?

*. How many databases supporting in your environment?

*. What is the default unDo retention?

*. What is the ORA 555 error? if you get What you will do?

*. What is the diff b/w incident and problem?

*. How to check DG is in sync or not and incremental backup dg sync Explain?

*. How to refresh database?

*. What is the use of catalog and nocatalog?

*. What is the use of unDo advisor?

*. knowledge on PT?

*. ticketing tool Explain?

*. Explain about change open process?

*. which role you are support?

*. tell me ur self and roles and responsibilities?

*. controlfile retention?

*. tell me yourself roles and responsibilities?

*. What is extent,segment etc?

*. Explain about physical standby and logical standby, How to fix gap using incremental backup Explain in detail

*. What is row chaining and row migration, How to fix this issues?

*. What is database,instance,physical and logical sturctures?

*. Explain about shared server architecture?

*. How to clone database using target,catalog Explain in detail?

*. How to configure standby database?

*. What is password file and parameter file mgmt? Explain in detail?

*. What is ASSM?

*. How to apply the patch?

*. Explain about startup process like stages?

*. What are the day to day activities and issues you face

*. Do u know about redaction,scrubbing,multi tenant

*. What are sga parameters

*. if sga_target and sga_max_size are both set to same valuewill there be impact

*. If app team wants to increase sga and u have to plan How will u plan?

*. Difference between g,c

*. Difference between g,c RAC

*. if my system team is upgrading kernel and there has been some issue and you are not able to up the asmlib and u have to Upgrade the asmlib

*. How Do u come to know if the standby is out of sync?

*. How Do u bring standby in sync if it is out of sync for some time with huge gap?

*. How can you perform switchover and switchback?

*. What is the use of fal_client and fal_server?

*. What is the use of ADG? How Do u setup ADG?

*. U have setup dg broker, How Do you use it?

*. Different protection modes used in Standby database

*. What are the prerequisites of RAC installation?

*. What is difference between SCAN VIP and VIP?

*. What parameter is used to failover connection from one node to another?

*. What is node eviction?

*. How Do you come to know that node has evicted?

*. What is location of crs log?

*. What is startup sequence in RAC?

*. What are the background processes in ASM?

*. What is rebalancing in ASM?

*. What are the levels of redundancy And which are used in ur organization?

*. why is ASM better than Filesystem?

*. How does the cluster comes up without the ASM instance been initialized,as most of the files needed for startup are present in ASM

*. Which bg process communicates with listener in RAC (ans LREG)

*. What are the minimum parameters to bring up an ASM instance?

*. What is cache fusion?

*. What is split brain?

*. What happens when you Do not define + in front of datafile while adding in ASM?

*. Have you done addition and deletion of nodes?

*. What are types of mirroring?

*. What kinds of Db refreshes have you done?

*. If currently an export is running and you Do not have handover of the export and user asks about it ,What would you tell them regarding the same?

*. when you use parallel in expdp What is the thing that you check before using it?

*. What is ORA-0555 error and How would you resolve it?

*. Have you done cloning of database?

*. Have you done upgradation?

*. How to Do manual Upgrade?

*. What are the prerequisites of upgradation?

*. What is in pre Upgradejar package for database upgradation?

*. How would u plan to migrate a schema from one database to another

*. How would u plan an update for 00GB table

*. What if your downtime window exceeds for a deployment,What steps will you take?

*. How will you create a  node-standby database for an Oracle RAC -node database?

*. Addition, deletion of nodes in oracle RAC

*. OEM installation and monitoring

*. Types of unDo ?

*. What you would Do in case of block corruption

*. How is mirroring achieved in rac?

*. pre requisites of RAC installation

*. What is dirty buffer?

*. which is the setup file you run during grid installation

*. What is the first window of grid installation?

*. What is the startup sequence in RAC database

*. where is the location of initd

*. What if the disks are not available on second node after issuing the scandisk command

*. What is the process of switchover and switchback in oracle database

*. OEM installation

*. How is monitoring done?

*. What are the steps after identifying ORA-600 errors?

*. when does node eviction happens?How would you come to know?

*. What is use of cssd process?

*. What are the steps involved in cloning of database?

*. What are the performance related issues that u have faced and resolved?

*. How Do u consider which table to de frag ?

*. How Do u come to know if the index is needed to be rebuilt? How Do u identify the indexes to be rebuilt?

*. Patching in oracle rac environment

*. Sequence of events that happen once u start Patching in RAC environment

*. Switchover, Switchback steps in RAC

*. Upgrade utility which has been used in oracle 9c

*. Pre checks to Upgrade

*. Use of datapump in GG

*. check for DMLs in replicat process

*. How to check the structure of database through RMAN

*. How to check the backups of your control file through RMAN

*. What is global inventory,local inventory?

*. Have you done Upgrade?

*. What are the steps involved in manual Upgrade?

*. If my server crashes during Upgrade,will i be able to resume Upgrade from where i left?

*. Which process is involved in instance recovery?

*. What are the pre requisites for Patching on Windows environment?

*. Types of backups used in oracle?

*. How can you make expdp backup faster?

*. What is the significance of exclude=statistics in expdp?

*. What if i have deleted archives from production database and standby db is out of sync ,What to do?

*. How can u restore a RMAN backup on RAC database?

*. Have you worked on DGBROKER? What is fast start failover?

*. What is ASYNC,SYNC?

*. What are the types of shutdown options?

*. What is startup force?

*. What is high water mark? Any way to reduce it?

*. What is optimizer and its use?

*. What is cost based and rule based optimizer?

*. What are the ways in which u can improve the performance of a query?

*. What are the commands that you know to monitor server performance?

*. Why is sysaux tablespace used?

*. How can u overcome the growth of a sysaux tablespace?

*. Does dropping a table can put it in recycle bin?

*. How to Rename a datafile? Are there any pre requisites involved?

*. How can you rename a database?

*. Why Do we need to change the timezone after Upgrade?

*. Have you worked on PDB,CDB?

*. U have done Cloud certifications,have you worked on cloud?

*. Have you worked on RAC

*. What is the difference between OCR and voting disk

*. Difference between OCRCHECK , OCRCONFIG

*. How to create physical standby,parameters involved in physical standby

*. How to convert non-ASM to ASM ?

*. How to convert from single node to RAC?

*. Difference between g,c,8c?

*. Have you worked on AWS,Azure?

*. Have you worked on any other technology apart from Oracle?

*. How to login to PostgreSQL database?

*. How to take backup of PostgreSQL database?

*. What are the utilities used in PostgreSQL to take backup?

*. Difference between SCAN VIP and VIP?

*. why is table_exist_action used in Datapump?

*. Why is attach parameter used in datapump?

*. Which processes are used to handle workload in Oracle database?

*. Which are the background processes in Oracle RAC?

*. Overall architecture in RAC database?

*. What are the tasks you have done in Performance tuning?

*. From which view to find the sql text of a given SQL id?

*. Have you worked on Oracle Goldengate and Exadata?

*. If my client or Whatever application team needs to implement RAC without SCAN IPs in g How will you Do it?

*. Have you worked on RAC?

*. What happens when your OCR gets corrupted and How will you restore it?

*. Have you faced block corruptions? How have you handled them?

*. What is the role of standby file management in dataguard?if i keep it as manual are there any kind of entries made at Standby?

*. If given an AWR report What all are the things that you would check in that report

*. Have you worked on PostgreSQL installation ?

*. Have you done Upgrade? What are the steps involved?

*. You have worked in Bank Of India What are the RBI guidelines did you follow as it is mentioned here

*. How did you implement DGBROKER?

*. What is difference between instance and database?

*. Have you done any implementations related to Firewall in terms of Security with Oracle?

*. Have you done any implementations or worked on Load Balancer?

*. What are the editions that you have used?

*. Hace you worked on OCI platform?

*. What happens when my control file is lost?

*. What are the stages of startup, What happens in resetlogs?

*. Why does an ORA-0555 error comes? How can you resolve it?Anything apart from unDo retention and size increase?

*. When does Deadlock occur? How can you resolve deadlock from db end?

*. If Application team wants to connect through same TNS name from their application, after you have performed switchover and they Do not want to change anything in their application, What would you do?

*. If during an Upgrade, you have created a restore point in Production and started the Upgrade but now after some time the production has gone down,is there any way to Upgrade the standby and make it production?

*. Have you done scripting for queries? Like can you find out the top 0 tables according to their sizes?Can you write scripts for relevant things as and when the come from client?

*. If i Do not have a control file and log file of RMAN backup can i restore it to another database?Only on the basis of datafiles and archive log files?

*. Can I use duplicate command to restore a backup from a source where the mount point name was different and at destination the mount point name was different?

*. If a user has updated and committed data mistakenly , How will you restore the data back to that table prior to the update operation?

*. How will u sync a table in Goldengate if it has gone into lag, and table is in TBs ?

*. What kind of Performance Tuning have you been involved in?

*. Auditing has been mentioned in your resume ,What kind of auditing have you done?

*. Are you comfortable with database refreshes?

*. Have you done shell scripting and have automated any tasks?

*. Have you worked with other technologies?

*. Have you done silent intallation?

*. Have you Upgraded from c to 9c? Do you know about the preUpgradejar utility?

*. Have worked on OEM?

*. Performance issue faced by you and solution provided

*. Different wait events, there common cause and solution

*. Suppose random customer comes and tell you that there is issue in database (no particular issue provided)

*. What evidence will you give him to proof that the database is working fine

*. What are the common things which you check in AWR report

*. Basic parameters used in dataguard

*. protection mode in brief

*. why sync and async is used

*. why AFFIRM and NOAFFIRM is used

*. What issues you have faced during recovery and What steps you have used to solve the issue

*. have you face block corruption  in the database ?

*. Suppose there are - DR databases of single primary database and you have backup of yesterday 

*. If there the entire mount point gets corrupted which includes

*. 9-10  datafiles and customer want the issue to be resolved asap How will you approach

*. Have you migrate cross platform databases?

*. What are basic prechecks done during migration

*. Have you done Upgrade ? steps to performs Upgrade and prechecks

*. Have you face any performance issue post upgradation? if yes which are those?

*. What are the solution provided for those performance issue post upgradation?(optimizer_  related parameters need to be set)

*. have you face ora-600, ora-7445, and How Do you approach ?

*. Precheck for manual Patching (not autopatch)

*. have you faced ORA-055?

*. What is unDo segments and why are they used

*. What is PCTFREE and PCTUSED

*. Block Change Tracking

*. What is checkpoint?

*. What is cache fusion

*. What is node eviction?

*. What are components of RAC?

*. Have you configure OEM from Scratch? What all things you Do during configuring OEM?

*. Have you work on exadata?

*. Have you worked on goldengate?

*. Which file you will check if any process is in abedended state?

*. How you will check the cluster health ?

*. Have you perform switchover switchback ? What are the imp things you check before activity?

*. How you will know that my DR database is ready for switchover?

*. What is Cache Fusion

*. What is OLR?

*. What is node eviction?

*. Explain RAC startup process

*. Difference between Virtual IP and Private IP

*. What is value of intance_type for oracle home and grid home?

*. How many voting disks are needed in a -node RAC?

*. What is Scan Ip?

*. How many scan IPs are required

*. How to add node in Oracle RAC? (Mujhse steps likhvaaye paper pe)

*. Which backup is good? Rman or expdp?

*. What is Listener Poisoning?

*. How can you make a rman backup piece password protected?

*. How to perform DR drill through DG broker ?

*. Write down the steps to perform switchover and switchback(ye bhi paper pe likhvaaya)

*. What is ctsd and cssd in RAC?

*. What is cache fusion? Which processes are involved?

*. How to analyze AWR report?

*. Which are the mandatory background processes?

*. Types of TDE?

*. Use of TDE?

*. How have you converted physical standby to snapshot standby?

*. Which parameter is used prior to incase there is a switchover and there happens to be a block corruption in the now primary database

*. What is private interconnect?

*. Command to unlock a user

*. What is the shared pool made up of?

*. How many datafiles max can be added in database?

*. What is bigfile? What are it's advantages?

*. What are the requirements for setting up an Oracle RAC database?

*. What are the various components of SGA?

*. What is parsing? What happens in it?

*. What is transportable Tablespace in datapump?

*. Which background processes are mandatory in RAC?

*. How does the mirroring happen in ASM

*. What is RAID level?

*. How to add and remove disks from ASM disk group?

*. How to add, delete node from RAC database?

*. What is ntpd service in RAC and How is ctsd service better?

*. Why is the default port 65 in RAC?

*. Have you done migration? What are the pre requisites?

*. Can u Upgrade a database from c to 8c? Can u Upgrade from c to 9c?

*. Steps for Manual Upgrade

*. Types of partitioned tables/partitioning?

*. Have u implemented tde?

*. What is the startup sequence in RAC?

*. How many daemons are started up when you start the RAC cluster?

*. Have you worked on performance tuning?

*. How Do u analyze a query and it's Explain plan?

*. Types of dataguard protection modes

*. Types of dataguard?

*. What happens when your reDo log or datafile becomes corrupt? 

*. Command to add a datafile

*. What is sga? Pga?

*. What is archival process?

*. What is control file?

*. How many users can connect at a time in the database?

*. What is server process?

*. How Do you track the address of users connected to your database?

*. How Do you purge listener logs?

*. What is sqlnetora?

*. How to take rman full backup?

*. What is differential backup?

*. How to configure DR?Which parameters are used for it?

*. Which Oracle versions have u worked on?

*. Best practice before installing database?

*. How u used to take 5TB backup in yesbank?

*. Best way to clone database?

*. Have u worked on RAC?

*. How many scan IPs are involved?total no Of IPs?

*. What is node eviction?

*. What is split brain?

*. How to setup ASM?

*. Have you installed Goldengate?

*. How to analyze slowness in RAC database?

*. Have u configured dataguard?

*. What are the modes in dataguard?

*. Difference between Maximum protection and Maximum performance?

*. have you done database refresh activity?

*. What is flexasm?

*. In case of Block corruption How Will you open the database?

*. If the rfs process has stopped How will u resolve?

*. In case the hostname of the RAC server has changed What all changes will you have to perform?

*. Have u worked on RAC?

*. What can u use to display the no Of nodes in a cluster?

*. How is select statement processed in Oracle?

*. In parsing ,How many execution plans are generated by the optimizer?

*. How have u used sqlldr in database?

*. Have u used instaclient on Oracle client?

*. What is the startup sequence in RAC?

*. Which tools Do you use to identify alert log errors?

*. Have you done upgradation/migration?

*. How can you create a partitioned table in database with respect to day wise partition?

*. Have you heard of interval in partitioned tables?

*. Which parameter of RAC is used in Expdp

*. How much time does it take for the backup of a production database on ur previous client?

*. How Do u Do switchover switchback in c through dgmrl?

*. What if your datafile was taken offlineWhat is the impact and How will the datafile come online?

*. What is shared pool?

*. What shell scripting have you done so far?

*. What is database cloning?

*. After that they have given one system and they said check load on server,What are  values at load average ?

*. They asked me to open test database,that db having issue

*. What is FRA?

*. Is having inactive sessions good or bad?

*. What views are used in active sessions and inactive sessions?

*. We have 50% Oracle and 50% mongodb,postgre,MySQL databases ,will u be open to work on them?

*. Which clients have you worked on?

*. When a user issues a command What happens?(in depth parsing steps)

*. When does the lgwr write the reDo log buffers to the reDo log files?(all events)

*. When does checkpoint happen?

*. What if a redolog file is deleted and I don't have the database in archived log mode or the database doesn't have a rman backupWhat would u do?(ye scenario pe 7-8 mins liya)

*. What is split brain? How will u address it? What will happen in this scenario? How will you or oracle internally handle it?(6 mins)

*. What is the process of adding node in a RAC?

*. I want a backup that should be consistentlike point in time kind of a backupis it possible in Expdp?

*. Is it possible to recover a table that is dropped from a rman backup taken?

*. Below topics which are covered to interview point of view only ,french based banking client ::

*. Explain plan

*. RAC wait events

*. Force_match = true 

*. Monitoring template

*. Scripting

*. RAC Startup Sequence

*. RAC Installation

*. RAC  node RMAN Restoration 

*. RAC Patching (Manual)

*. RAC Node Eviction Types (NHB/DHB) 

*. Adding node in RAC

*. GPnP Profile

*. LMD/LMS/LMON/GRD

*. Cache Fusion

*. Working of SCAN

*. VOTING Disk/OCR (Role/Min/Max)

*. Add Service in RAC / Checking whether added successfully?

*. Table Partitioning (HASH/Split)

*. Flashback DB/ Restore Point /Guarantee RP

*. ORA - 0000 Process Parameter Exceeds

*. ORACLE EVENTS - Index Fast full Scan

*. Big-Long Update is running What impact will be on Database (DBBC LRU Mechanism)

*. INITRANS/MAXTRANS/PCTFREE/PCTUSED

*. AMM / ASMM

*. Loss of all controlfile

*. c to g EXPDp/IMPDP (VERSION=)

*. FAL Client/FAL Server

*. DR Sync with Incremental NO REDo Recovery Method

*. Member KILL / Node KILL

*. Remote_listener Scenario (5 Node RAC connections only routing to rd Node only)

*. Access and Filter in Explain plan

*. Unique Index Scan / Index scan by RowID

*. Does datafile Contains Uncommitted Data? yes(for following conditions)

*. Flush buffer cache

*. Before a logfile gets overwritten

*. Manual checkpoint

*. To free buffers

*. Tablespace offline

*. Tablespace read only

*. Tablespace begin backup

*. Troublesshooting Node Eviction (Check /var/log/messages)

*. non rac to rac migration

*. Non asm to asm migration of database

*. manual database creation in RAC

*. creating scan listener

*. How scan Works, changing scan port,

*. Use of Interconnect in RAC

*. Use of OCR, Voting Disk

*. OCR Scenarios 

*.   - add/delete/replace OCR location

*.   - OCR Corruption issues (one or all)

*.   - ocrconfig, ocrcheck, ocrdump

*.   - What if one of the OCR is corrupted

*. Voting Disk Scenarios

*.   - add voting disk location

*.   

*.   - deleting voting disk location

*.   

*.   - restore voting disk scenarios

*.   

*.   - Taking a backup of VD

*.   

*.   - disk redundacy for Voting Disk  

*. RAC processes

*.    - lck0,lmsn,lmd0,lmon,ACMS,

*. RAC startup sequence

*. OHASD

*. oraagent,orarootagent,cssdagent,cssdmonitor

*. oraasm,gnsd,gpnpd,evmd,evmlogger,mdnsd

*. ctssd, crsd,diskmon,acfsdrivers

*. (crsd) oraagent,orarootagent

*. ASM,oradg,ons, listener, scan listener,db, ons,eons,gsd, services

*. scanvip,nodevip,gnsvip,gns

*. Cache Fusion, GRD

*. TAF,FAN implementation

*. RAC restoration, creation of Clone in RAC

*. RAC Node Pinning & Unpinning Concept

*. Installation steps , cleanup failed installation

*. How to detect master Node

*. Types of Master Node (Cluster Master,OCR Master,Resource Master)

*. How to add/delete  resource

*. How to add/delete Node Instance 

*. Patching Rac Setup, One offs, PSU

*. 19c New Features in RAC

*. Rac Node Node 

*. Modiying Private IP/Virtual IP for RAC

*. Briefly Explain about architecture

*. What is pmon, smon, dbwr,lgwr,ckpt and archiver

*. Select and update query internal process

*. What is a keep and row cache

*. What is a base tables

*. What is a parsing

*. Difference b/w soft and hard parsing

*. Difference b/w pga and sga?

*. Difference b/w ASSM ans AMM?

*. Difference sg_target and memory_target?

*. Difference b/w sga_max_size and memory_max_target?

*. Difference b/w pfile and spfile?

*. What is alertlog file?

*. What is a 0RA-555 error

*. What is a ORA-00600 error and How you will fix

*. What is a ORA-404 error and How you will fix

*. Yesterday query is good today it's taking time

*. Database yesterday is good but today it's taking time

*. What is AWR

*. What is ASH

*. What is ADDM

*. What is sqlprofile

*. What is sqlbaseline

*. What is average active sessions

*. Difference b/w sqlprofile and sqlbaseline

*. Difference b/w AWR, ASH and ADDM

*. How you will generate AWR and exactly What you will check and briefly Explain it?

*. What is statistics, How will check table and index statistics

*. What is index, How will check index statistics

*. How will check table and index fragmentation

*. What is Explain plan and How you will generate?Table space and user management :

*. What is a tablespace

*. Difference b/w tablespace and table

*. What is a undotablespace and it's advantage

*. What is a temporaray tablespace and it's advantage

*. Difference b/w expired and unexpired blocks in undotablespace

*. How to enforce user requirement

*. User wants its same password How

*. What is a password file and How you will check password assign to user

*. How you will assign tablespace from another tablespace, What happen object inside the tablespace

*. UnDo database having 4hours unDo retention without guarntee clause What happen

*. UnDo database having 4hours unDo retention with guarntee clause What happen

*. Difference between exp and expdp or traditional and  datapump or traditional and expdp

*. How you will improve performance of export and import

*. Mandatory things to create schema refreshment

*. How you will perform schema refreshment and table refreshment

*. How you will take only metadata of database

*. What is a table_exists_action

*. How you will rename user

*. User wrongly inserted the date What you will do?

*. Export or import failures happen What is the reason, How you will fix

*. How you will check the dump file job time before export

*. How you will check the dump file size before export

*. How you will export or import the data from unDo table space using traditional and datapump methods

*. Difference b/w cold backup and Hot backup

*. Difference b/w expired backup and obsolete backup

*. Difference b/w image copy and backupset

*. Difference b/w incremental and cummulative backups and differential backups

*. What is a backup startegy or backup policy

*. What is difference b/w full backup and Level 0 backup

*. What is a FRA and How you will enable and manage the FRA

*. Archive destination reaches 90% What you will do

*. Archive destination full What you will do

*. Pfile deleted, control file deleted(Backup and multiplexing not available), datafile           deleted, log file corrupted or log file deleted, blocks corrupted and How will Do               restore and recovery

*. Table dropped How will restore

*. Database crash at particular time How will restore

*. Disaster recovery(Pfile, spfile,control file, datafiles, logfiles entired deleted) How you will restore

*. Datafile deleted backup not available What you will do

*. How you will perform cloning briefy Explain

*. What is a snapshot controlfile

*. What is a encryption

*. What is a optimazation

*. What is a retention policy and recovery window

*. What is a Crosscheck command

*. Difference b/w no catalog database and recovery catalog database

*. What are the C and 9C featuers Data Guard  

*. What is a data guard and How many types and What are there

*. Importance of dataguard

*. Difference b/w physical and logical standby

*. What are the top most services in dataguard

*. Difference b/w active and snapshot dataguard

*. How you wll create standy database

*. What are the mandatory things to create standby database

*. Difference b/w switchover and failover 

*. How you will perform switchover and failover

*. Top 5 mandatory things to Do switchover activities

*. How you will patch on data guard environment and Upgrade

*. Difference b/w fall client and fall server

*. What is a standby management

*. Standby database not syn with primary from longtime or huge gap How you will fix

*. Less gap exists How you will fix

*. Archive shipping is very slow or archive shipping not's happening What is your              findings and How you will fix

*. log applying is very slow or log applying not's happening What is your findings and       How you will fix

*. Primary not available What you will do

*. What is a force logging

*. Tell me few reasons why primary not syn with standby database

*. Nologging operation happen at primary What happen and How you will recover            standby

*. Somebody changes sys password at primary What happen and How you will fix

*. Difference between performance mode, protection mode and maximum availability mode

*. Difference between syn and asyn

*. Difference between noaffirm and Affirm

*. How you will perform incremental recovery in standby

*. What is the backup command to create standby database

*. Standby out of syn with primary then How archive backup and deletes

*. What are the C and 9C features in dataguard

*. What is a ASM and it's importance?

*. How you will add asm disk to diskgroup?

*. What is a asm array?

*. What is redundancy and How many type?

*. How you will create tablespace using ASM diskgroup?

*. How you will create external and normal redundancy?

*. How to move external redundancy to normal redundancy entire database?

*. What is asm_power_limit?

*. What is asm background process?

*. What is a power in ASM?Interview questions on RAC

*. What is a cluster and it's advantage

*. Difference b/w standalone instance and RAC instance

*. Difference b/w crash recovery and crash instance recovery

*. What is a ocr file, How you will find location and also backup location

*. How you will backup ocr file and restore

*. What is a olr file and it's importance and What is the location

*. What is a voting file and How you will find it's location

*. Why we need to use odd number of voting file

*. What is a master node and it's location

*. What is split brain syndrome

*. What is a node eviction and it's reason and How you will findout

*. Explain briefly about rac architecture

*. What is the cache fusion, cache coherence, resource affinity

*. Which background process is managing cache fusion

*. What are the rac background process

*. What are the cluster background process

*. What is the cluster sequence process

*. How you will stop and start cluster

*. How you wii stop particular instance

*. How you will check cluster status in entire instance and particular instance

*. How you wiil generate AWR report in rac

*. For  node and  node How many ip's require

*. What are the private, public and VIP'S

*. What is the SCAN and it's importance

*. What is the difference b/w local listener and scan listener

*. What is a scan ip

*. What is a service and it's properties and you will configure services

*. How you will configure service for particular instance

*. How data will move in rac environment

*. Rac installation

*. How you will psu patch in rac environment

*. How you will Upgrade rac database

*. How you will unlock grid home while applying patches and it's importance

*. What is you daily activities in a rac

*. Any issue faces in rac

*. Difference b/w cpu and psu patch

*. How you will check optach version and installed patches

*. How you will check central inventory

*. Central inventory corrupted How you wiil do

*. Difference b/w local inventory and central inventory

*. Local inventory corrupted then How

*. How you will download patch from oracle support

*. How you will apply psu patch in standalone and rac environment

*. How you will check conflicts, if conflicts happen then What you will do

*. How you will patch at database level

*. Difference b/w g and C patches

*. What is a Upgrade and it's importance

*. How you will Upgrade from g to c

*. How you will Upgrade from c to 9c

*. How you will Upgrade from 0 to 9c

*. Any issues faced while applying patches and upgradation

*. Describe Oracle database architecture?  

*. What is SGA?

*. What is the logical and physical structure of the database?

*. What is pfile and spfile?

*. Can we create pfile from spfile or vise versa when the database is down?

*. What is the oracle background process?

*. What is the difference between pmon and smon?

*. What is instance recovery?

*. What is rollforward and rollback?

*. Describe all the database startup options? mount no-mount etc

*. What is Extents? How to calculate table, schema and database size? Give the SQL for each item?

*. What is an oracle tablespace? Can a datafile be a part of two tablespaces?

*. How many tablespaces can be created in a single database? What is the thumb rule?

*. What is unDo and temp tablespace?

*. What is checkpointing?

*. What is checkpoint global?

*. Why Do we need checkpointing?

*. Tell me about oracle memory buffers and parameters?

*. Why Do we need a large pool?

*. List all the mandatory background process names?

*. Can we run multiple databases from a single Oracle database instance?

*. Can we create a Database from scripts without using DBCA?

*. Without an oracle listener can we connect to the database?

*. How to connect to the oracle database from a remote server?

*. Can we connect to the oracle database from remote server odbcini?

*. While oracle database software installation why Do we need Linux packages or Linux? 

*. What is the importance of RPM in oracle database software installation?

*. What is the environment variable file?

*. Can we connect to a database without sourcing the environment variable file? Explain both the ways with env File and without?

*. What is the semaphore? Why Do we need it?

*. How to limit the oracle instance memory utilization to a fixed size in the Linux server? 

*. What is the difference between schema and user?

*. Why Do we need an index?

*. What is the global index?

*. How to hide the index so that SQL execution should not pick it? What is a cost-based optimizer? How does it work? How you can get an Explain plan for SQL? What is the profiler? How to create a profile for a SQL? What are the Histogram and buckets? What are the Hits? How to sHow only 000 rows of a SQL output from a hint and What hit you will use?

*. What is partitioned index and tables?

*. Can we convert a normal table to a partitioned table?

*. How to track the table row insert, update and delete? Suggest away or auditing tool?

*. What is oracle Grid or an enterprise manager? 

*. How to automate daily repeated tasks? give any server-side scripting language name and example of automation?

*. Can we Do automation or trigger shell/python script from Oracle Grid?

*. What is the monitoring profile in the oracle gird

*. How to take a backup of a table or data?

*. What is the Data Pump? How is it more powerful than traditional export-import? 

*. Can we export only data without metadata from expdp?

*. If the database size is 4tb and want to take the backup from expdp What is the imp parameter we should use to speed up the process and create the dump file in multiple pieces?

*. How to ignore the errors in impdp?

*. How to kill an expdp job? 

*. Can we pause an expdp job?How to determine the dump size in advance without running actual expdp?