Latest interview questions

Ø  SINGLE NODE OR MULTI NODE?

Ø  SHARED SERVER OR DEDICATED SERVER?

Ø  DIFF B/W SYNC AND ASYNC IN DATAGUARD

Ø  DATAFILE CORRUPTED HOW TO RESTORE

Ø  WHAT IS FND REVIVER

Ø  COMPILE JPS

Ø  COMPILE FORMS WITHOUT ADADMIN EXPLAIN COMMAND

Ø  PATCH STRUCK IN MIDDLE WHAT TO DO

Ø  DIFF B/W 11I AND R12

Ø  DIFF B/W 12.1 AND 12.2

Ø  DBUA NOT STARTING AFTER EXPORTING ALL PATHS

Ø  HTTP SERVER NOT STARTING WHATS THE ISSUE

Ø  CONCURRENT MANAGERS ARE DOWN WHATS THE ISSUE

Ø  12.1 TO 12.2 UPGRADE PROCESS

Ø  HOT BACKUP CLONING PROCESS

Ø  WHAT IS OPP

Ø  WHAT IS PCP

Ø  WHAT IS INTERNAL MONITOR IN PCP

Ø  CONCURRENT REQUEST RUNNING LONG TIME WHATS ARE THE STEPS U DO

Ø  WHAT DO U DO FOR PERFORMANCE MONITORING OF DATABASE

Ø  HOW TO SEE THE PATCH JOB STATUS

Ø  EXPLAIN SGA ARCHITECTURE

Ø  WHAT IS LIBRARY CACHE

Ø  WHAT HAPPENS IN BACKGROUND PROCESS WHEN U RUN A QUERY SAY SELECT * FROM TAB

Ø  WHAT ARE EVENTS

Ø  DO YOU KNOW RAC(EVERY COMPANY ASKING SAME QUESTION)

Ø  IF I INSTALL APPLICATIONS IN ONE NODE AND DATABASE IN ANOTHER NODE CAN WE SETUP CONCURENT MANAGERS IN ANOTHER NODE?

Ø  WHAT ARE THE CONFIGURATION FILES TRANSFERRED TO NODE WHERE THE CONURRENT MANAGERS ARE SETUP

Ø  HTTP SERVER LOG LOCATION

Ø  OJSPCOMPILE SCRIPT LOCATION

Ø  HOW WILL YOU ANALYZE THE PATCH

Ø  IF THE PATCH STRUCK IN MIDDLE AND I REALIZE THAT PREREQUISITE PATCH WAS NOT APPLIED THEN HOW WILL YOU PROCEED

Ø  WHAT ARE THE BIGGEST ISSUE YOU HAVE FACED

Ø  HOW TO CLONE APPLICATION USING ADCFGCLONE WITHOUT PASSING PARAMETERS MANUALLY

Ø  DIFFERENCE BETWEEN PDB AND CDB

Ø  WHAT IS WORKFLOW

Ø  WHAT IS RDF

Ø  WHEN SQL SCRIPTS ARE RUNNING WHAT ARE UPDATED IN DATABASE

Ø  EXPLAIN THE ARCHITECTURE YOU ARE USING

Ø  HOW WILL YOU CLEAR FND_NODES

Ø  HOW WILL YOU CREATE CUSTOM TOP

Ø  RESPONSIBILITY IS ADDED BUT NOT SHOWING WHAT TO DO

Ø  WHAT HAPPENS WHEN YOU LOGIN TO FE APPLICATIONS

Ø  DIFFERENCE BETWEEN AD_BUGS AND AD_APPLIED_PATCH

Ø  HOW DO YOU ENABLE TRACE

Ø  WHAT ARE THE TYPES OF PATCHES YOU HAVE APPLIED AND EXPLAIN ABOUT THOSE PATCHES

Ø  WHATS THE PATCH NUMBER WHEN YOU UPGRADE APPLICATIONS FROM 12.1.1 TO 12.1.3

Ø  WHAT IS STANDARD MANAGER

Ø  HOW CAN I ABORT PATCH IN R12.1

Ø  WHAT HAPPENS WHEN U RUN AUTOCONFIG

Ø  WHAT WILL BE UPDATED IN DATABASE IF YOU RUN AUTOCONFIG

Ø  WHAT IS ADPRECLONE AND WHAT HAPPENS WHEN YOU RUN IT

Ø  ADCFGCLONE SCRIPT LOCATION

Ø  DIFFERENCE BETWEEN VIEW AND MATERIALIZED VIEWS AND WHICH IS BENIFICIENT

Ø  HOW WILL U UPDATE MATERILIZED VIEW

Ø  WHAT ARE THE TABLES CREATED WHEN APPLYING PATCH

Ø  WHAT THE MAIN PURPOSE OF RMAN

Ø  WHAT LOG FILES ARE CREATED WHEN U APPLY PATCH AND WHAT IS .LGI FILE

Ø  HOW U APPLY PATCH IN TEST MODE

Ø  I WANT TO TRANSFER DATA FROM MYSQL TO ORACLE

Ø  WHAT IS REQUEST GROUP

Ø  WHATS THE SIZE OF YOUR DATABASE

Ø  WHAT IS INDIAN LOCALIZATION

Ø  EXPLAIN OBIEE INSTALLATION

Ø  IS SCHEMAS BIPLATFORM AND MDS NEEDED

Ø  WHERE IS THE OPTION STRUCK IN WEBLOGIC CONSOLE

Ø  WHAT IS THE USE OF GUEST USER IN ORACLE APPS

Ø  IS IT POSSIBLE TO UPGRADE DATABASE FROM 10G TO 12C

Ø  PATCH IS STRUCK AT SOME POINT AND U CAME TO KNOW PREREQUISITE PATCH TO BE APPLIED WHAT WILL U DO

Ø  PATCH GOT STRUCK FOR NO REASON,NO ERRORS IN LOG FILE WHAT WILL U DO FNDOPP NOT STARTING AND NO ERRORS IN LOG FILE WHATS THE ISSUE

Ø  CONCURRENT REQUEST FAILED WITH OUTPUT PROCESSING WHATS THE ISSUE

Ø  WORKFLOW NOTIFICATION MAILERS ARE NOT STARTING AND NO ERRORS IN LOG FILE WHATS THE ISSUE

Ø  HOW WILL U REGISTER PRINTER

Ø  HOW WILL U CHECK PRINTER STATUS FROM BACK END

Ø  CONCURRENT MANAGERS NEED TO BE BOUNCED IN PROD, U HAVE SENT MAIL AND CALLED TO MANAGER BUT NO REPLY , USERS ARE WORKING IN PROD , WILL U BOUNCE CONCURRENT MANAGERS WITHOUT ASKING MANAGER?CONCURRENT LOG FILES LOCATION

Ø  HOW WILL U APPLY A PATCH

Ø  HOW WILL U MONITOR PRODUCTION DATABASE

Ø  HAVE U DONE ANY CODE MIGRATION

Ø  WHAT ARE YOUR DAILY ACTIVITIED

Ø  WHAT IS ADCLONECTX.PL

Ø  HOW TO CLONE R12.2

Ø  DIFFERENCE BETWEEN CLONING R12.1 AND R12.2

Ø  PATCH GOT FAILED DUE TO NETWORK WHAT WILL U DO

Ø  WHAT ARE THE STANDARD PARAMETERS IN STANDBY DATABASE

Ø  ARCHIVE LOGS ARE GENERATED HUGE AND NOT TRANSFERRED TO STANDY DATABASE WHAT TO DO

Ø  HOW WILL U CLEAR NODES DETAILS IN R12

Ø  HOW WILL U REGENERATE NODES DETAILS IN DATABASE

Ø  HOW WILL U DELETE USERS IN APPS

Ø  HOW WILL U CHECK IF APPLICATIONS PRODUCT LEVEL PATCHES ARE AT RECOMMENDED LEVEL

Ø  HOW TO ADD NODE IN R12.2