Oracle D2K Interview Preparation Guide
Strengthen your Oracle D2K interview skills with our collection of 28 important questions. These questions are specifically selected to challenge and enhance your knowledge in Oracle D2K. Perfect for all proficiency levels, they are key to your interview success. Download the free PDF now to get all 28 questions and ensure youre well-prepared for your Oracle D2K interview. This resource is perfect for in-depth preparation and boosting your confidence.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;