Apps Technical Interview Questions Part 5

[et_pb_section bb_built=”1″ _builder_version=”3.0.52″ background_image=”https://oraclesolutions.pk/wp-content/uploads/2017/07/question-mark-2123967_1920.jpg” parallax=”on” parallax_method=”off” inner_shadow=”on”][et_pb_row _builder_version=”3.0.52″ parallax=”on” parallax_method=”off” background_position_1=”top_left” background_repeat_1=”no-repeat” make_fullwidth=”on” use_custom_width=”on” custom_width_percent=”100%” custom_width_px=”1702px” use_custom_gutter=”on” width_unit=”off” make_equal=”on”][et_pb_column type=”4_4″][et_pb_toggle _builder_version=”3.0.52″ title=”What is Summary columns? ” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

• A summary column performs a computation on another column’s data.
• Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total.
• You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries:  first, last, standard deviation, variance.

 

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can u define exceptions twice in same block?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

NO

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can you have two functions with the same name in a pl/sql block?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

YES

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can you have two stored functions with in the same name?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

YES

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can function be overload?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

YES

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is the maximum number of statements that can be specified in a trigger statement?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

ONE

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Can 2 functions have same name & input parameters but differ only by return datatype?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

NO

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is FORWARD DECLARATION in Packages?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

PL/SQL allows for a special subprogram declaration called a forward declaration.It consists of the subprogram specification in the package body terminated by a semicolon.You can use forward declarations to do the following:

1. Define subprograms in logical or alphabetical order.
2. Define mutually recursive subprograms.(both calling each other).
3. Group subprograms in a package

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”Difference between triggers and procedures?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

Triggers	Procedures
Defined with create trigger	Defined with create procedure
The data dictionary contains source code in the user_triggers.	Data dictionary contains source code in user_source
Implicitly invoked	Explicitly invoked
Commit, save point and rollback are not allowed(TCL)	Those are allowed

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What do you mean by LOCKS?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

Locks are used to reduce concurrency

SHARE LOCK—it allows the other users for only reading not to insert or update or delete.

EXCLUSIVE LOCK— only one user can have the privileges of insert or update and delete of particular object others can only read.

UPDATE LOCK—-multiple user can read, update delete

Lock levels :

1) TABLE LEVEL

2) TABLE SPACE

3) DATABASE LEVEL.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is template?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

The TEMPLATE form is the required starting point for all development of new Forms. It includes platform–independent attachments of several Libraries.

• APPSCORE :- It contains package and procedures that are required of all forms to support  the MENUS ,TOOLBARS.
• APPSDAYPK :- It contains packages that control the oracle applications CALENDER FEATURES.
• FNDSQF  :- it contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESSING.
• CUSTOM :- it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom    ( such as moving to another form and querying up specific records)

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What is responsibility?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

It is a collection of menus, request security groups and data groups

1. Menus: collection of forms is nothing but menus
2. Request security groups: collection of programs.
3. Data groups: is a group of modules to be made accessible by the user through Responsibility.

[/et_pb_toggle][et_pb_toggle _builder_version=”3.0.52″ title=”What are the validation types?” open=”off” use_background_color_gradient=”on” border_style=”ridge” background_color=”#ffffff” title_font=”Montserrat|on||on|” title_text_color=”#ffffff” body_font=”Montserrat||||” body_font_size=”15″ background_color_gradient_end=”#000000″ background_color_gradient_direction=”181deg” use_border_color=”on” icon_color=”#0c71c3″ title_font_size=”18″ body_line_height=”1em” border_width=”3px” background_color_gradient_start=”#ffffff” open_toggle_text_color=”#ff0000″ body_text_color=”#ffffff”]

None:   validation is minimal.

Independent ——input must exist on previously defined list of values

Dependent    ——input is checked against a subset of values based on a prior value.

Table             —– input is checked against values in an application table

Special          ——values set uses a flex field itself.

Pair              —— two flex fields together specify a range of valid values.

Translatable independent —– input must exist on previously defined list of values; translated values can be used.

Translatable dependent ——- input is checked against a subset of values based on a prior values; translated value can be used.

[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section]