Below are the interview questions of Genisys :
Q 1)How to check the archive log mode ?
Ans: We can check the archive log mode as follows:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /usr/app/oracle/arch
Oldest online log sequence 14237
Next log sequence to archive 14245
Current log sequence 14245
SQL> select log_mode from v$database;
Q 2)How to apply patch online in apps?
Ans: We can apply patch online without selecting the option 5 of adadmin utility which tells enable maintainance mode and using
Q 3)How to check th patches applied in Oracle Database?
Ans: opatch -lsinventory gives the list of patches applied in oracle Database.
4)How to check the patches applied in Oracle application?
Check Patches applied from Oracle Application Manager(OAM).
a)Connect to OAM:
Go to Site Map->Maintenance->Applied Patches
Enter Patch ID and press 'Go'
See if Patch was returned.
Use 'adphrept' utility documented in Metalink Note:181665.1.
We might also use the below query,However method 1 & 2 are more reliable.
SELECT DISTINCT RPAD(a.BUG_NUMBER,
ORDER BY 1 DESC;
In multi-node environment we are advised to use Patch Query from section "Checking the Patch Requirements on each Appl_Top" of the Metalink Note:364439.1
1)Login as apps user into sqlplus or an other tool to query the oracle Database:
2)Execute the below query:
Select *from applsys.ad_bugs where bug_number='
If that query returns a row then the patch is applied.
Q 5)What are the parameters obsolute or depreciated in oracle 10g?
Ans :There are about 122 obsolute parameters in oracle 11g :
SQL> select name from v$obsolete_parameter;
To list few of them are:
Parameters obsolute in oracle 10g are:
According to v$parameter there are 25 deprecated Oracle 10g initialization parameters
Q 6)How to kill session at OS level and Database level?
kill -9 pid
where pid=> process id
ALTER SYSTEM KILL SESSION 'sid,serial#';
Q 7)How to check the patch logs in oracle 11i application?
Which consists of two files one is the main log file with .log extension and another is the lgi file which is the log information file.
Q 8)If we lost context file in oracle apps,how can we recreate it?
Ans: Yes,we can recreate the context file in the oracle application with the help of the perl script
$perl adclonectx.pl \ contextfile=Path name
Hope this help.Please feel free to give any feedback.