Oracle D2K Interview Preparation Guide Download PDF
Oracle D2K Interview Questions and Answers will guide us now that OracleD2K is the frontend in oracle to develop forms and the backend database oracle would be storing information and d2k will be displaying it. So learn Oracle D2K and get a better job or get preparation for a job in D2K with the help of this Oracle D2K Interview Questions with Answers guide
28 Oracle D2K Questions and Answers:
1 :: What is oracle d2k? why we use it?
It is a front end tool which consist of forms and reports and use plsql as a coding language
2 :: Were you involved in any data conversion, which one?
We have done data conversion for1.Suppliers2.AP Invoices3.Customers4.AR Invoices
3 :: Which Oracle Apps version you are very confident in?
As we basically use 11.5.9 version hence its better to tell that only.
4 :: Total months of effort in Oracle Apps technical work?
If you are technically strong in Oracle D2k then it will take very less or near abt one month to learn abt Oracle apps.
5 :: Are you familiar with User exits in reports?
The best example for user exit which i used is FND FORMAT_CURRENCY.
6 :: Do you know what are User Profiles in Apps. Any examples you can give?
User Profile : It is a set of changeable options through which your application runs.User profile can be defined at various levels. They are
1.System
2.Application
3. Responsibility
4. User
1.System
2.Application
3. Responsibility
4. User
7 :: How many concurrent programs you have customized, can you name some of them?
Have to see the standra reports and possible customizations
8 :: How to make the project as .exe file in oracle forms & reports(d2k)?
Developer/2000 doesn't make exe files. Think of your Dev 2k project like an access database, you develop the forms and reports and then when you deploy them you also install the Forms & Reports Runtimes on the clients machine. Forms, when compiled have the *.fmx extension as opposed to the normal *.fmb extension.
Developer/2000 doesn't make .exe files.
Developer/2000 doesn't make .exe files.
9 :: How do you run ms_batch file in forms?
what could be the value :system.mode?
host('c:myFile.bat');
host('c:myfile.bat);
host('c:myfile.bat);
10 :: How to get / select the nth row from the table?
how to select first n rows ,last n rows from a table?
nth salary
select salary
from table_name a
where &n=(select count(salary) from table_name b where a.salary<=b.salary);
n salaries
select salary
from table_name a
where &n>=(select count(salary) from table_name b where a.salary<=b.salary);
select level,max(column name) from emp where level = n connect by prior sal > sal group by level;
select salary
from table_name a
where &n=(select count(salary) from table_name b where a.salary<=b.salary);
n salaries
select salary
from table_name a
where &n>=(select count(salary) from table_name b where a.salary<=b.salary);
select level,max(column name) from emp where level = n connect by prior sal > sal group by level;