Sunday 8 February 2015

Oracle PLSQL and D2K Interview Questions and Answers

Below are some important Oracle D2K interview questions which are asked in most MNC company interviews for beginners or professionals.

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

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.

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);

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;
More Questions & Answers :-

No comments:

Post a Comment