Explore topic-wise InterviewSolutions in .

ANSWER : PROCEDURE NAME (parameter list.....)
is
local variable declarations
BEGIN
Executable statements.
Exception.
exception handlers
end;

Oracle Label SECURITY (formerly called Trusted Oracle MLS RDBMS) uses the VPD (Virtual PRIVATE DATABASE) feature of Oracle8i to implement ROW level security. Access to rows are restricted according to a user's security sensitivity tag or label. Oracle Label Security is configured, controlled and MANAGED from the Policy Manager, an Enterprise Manager-based GUI utility.

Oracle Label Security (formerly called Trusted Oracle MLS RDBMS) uses the VPD (Virtual Private Database) feature of Oracle8i to implement row level security. Access to rows are restricted according to a user's security sensitivity tag or label. Oracle Label Security is configured, controlled and managed from the Policy Manager, an Enterprise Manager-based GUI utility.

Raise_application_error is a PROCEDURE of package DBMS_STANDARD which ALLOWS to issue an user_defined error MESSAGES from STORED sub-program or database trigger.

Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue an user_defined error messages from stored sub-program or database trigger.

Oracle 8i introduced the NOTION of a Virtual Private Database (VPD). A VPD offers Fine-Grained Access Control (FGAC) for secure separation of data. This ENSURES that users only have access to data that pertains to them. Using this option, one COULD even store multiple companies' data within the same schema, WITHOUT them knowing about it. VPD configuration is done via the DBMS_RLS (Row Level SECURITY) package. Select from SYS.V$VPD_POLICY to see existing VPD configuration.

Oracle 8i introduced the notion of a Virtual Private Database (VPD). A VPD offers Fine-Grained Access Control (FGAC) for secure separation of data. This ensures that users only have access to data that pertains to them. Using this option, one could even store multiple companies' data within the same schema, without them knowing about it. VPD configuration is done via the DBMS_RLS (Row Level Security) package. Select from SYS.V$VPD_POLICY to see existing VPD configuration.

The two parts of PACKAGE are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the SCHEMA. Package Body contains actual procedures and local declaration of the procedures and cursor declarations.

The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema. Package Body contains actual procedures and local declaration of the procedures and cursor declarations.

There are two types of cursors, Implicit Cursor and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. User DEFINED cursors are called Explicit Cursors. They can be DECLARED and USED.

There are two types of cursors, Implicit Cursor and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.

User_objects, User_Source and User_error.

User_objects, User_Source and User_error.

WHERE CURRENT OF CLAUSE in an UPDATE,DELETE statement refers to the LATEST row FETCHED from a CURSOR. Database Triggers.

WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers.

.pll,.lib,.PLD
The library pll files is a portable design file comparable to an fmb form file
The library lib file is a plat form specific, generated library file comparable to a fmx form file
The pld file is Txt format file and can be USED for source controlling your library files PARAMETER.

.pll,.lib,.pld
The library pll files is a portable design file comparable to an fmb form file
The library lib file is a plat form specific, generated library file comparable to a fmx form file
The pld file is Txt format file and can be used for source controlling your library files Parameter.

A canvas-view is the background OBJECT on which you LAYOUT the interface items (text-items, check BOXES, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been ASSIGNED to a specific canvas. Each canvas, in term, must be displayed in a specific WINDOW.

A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been assigned to a specific canvas. Each canvas, in term, must be displayed in a specific window.

A Check Box is a two STATE control that indicates whether a CERTAIN condition or VALUE is on or off, true or false. The DISPLAY state of a check box is always either "CHECKED" or "unchecked".

A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or false. The display state of a check box is always either "checked" or "unchecked".

A content view is the "Base" view that occupies the ENTIRE content PANE of the window in which it is displayed. A stacked view DIFFERS from a content canvas view in that it is not the base view for the window to which it is assigned.

A content view is the "Base" view that occupies the entire content pane of the window in which it is displayed. A stacked view differs from a content canvas view in that it is not the base view for the window to which it is assigned.

A fetch from a LONG RAW database COLUMN PL/Sql ASSIGNMENT to executing the read_image_file built_in procedure to get an image from the file system.

A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.

A LIBRARY is a collection of Pl/SQL program UNITS, including USER NAMED procedures, functions & packages.

A library is a collection of Pl/SQL program units, including user named procedures, functions & packages.

A NAVIGABLE item is ONE that operators can navigate to with the keyboard during default navigation, or that ORACLE forms can navigate to by EXECUTING a NAVIGATIONAL built-in procedure.

A navigable item is one that operators can navigate to with the keyboard during default navigation, or that Oracle forms can navigate to by executing a navigational built-in procedure.

• Add_parameter
• Create_Parameter_list
• Delete_parameter
• Destroy_parameter_list
• Get_parameter_attr
• Get_parameter_list
• set_parameter_attr

An alert is a MODAL WINDOW that displays a MESSAGE notifies the operator of some APPLICATION CONDITION.

An alert is a modal window that displays a message notifies the operator of some application condition.

BASE table Blocks:
A base table block is one that is ASSOCIATED with a SPECIFIC DATABASE table or view.
CONTROL Blocks:
A control block is a block that is not associated with a database table.

Base table Blocks:
A base table block is one that is associated with a specific database table or view.
Control Blocks:
A control block is a block that is not associated with a database table.

A field is a position on a FORM that one uses to enter, view, update, or DELETE information. A field prompt describes each field by telling what kind of information appears in the field, or alternatively, what kind of information should be entered in the field.

A flexfield is an Oracle Applications field MADE up of segments. Each segment has an ASSIGNED name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization. There are two TYPES of flexfields: key flexfields and descriptive flexfields.

A field is a position on a form that one uses to enter, view, update, or delete information. A field prompt describes each field by telling what kind of information appears in the field, or alternatively, what kind of information should be entered in the field.

A flexfield is an Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization. There are two types of flexfields: key flexfields and descriptive flexfields.

MultiOrg or Multiple Organizations Architecture allows multiple operating units and their relationships to be defined within a single installation of Oracle Applications. This keeps each operating UNIT's TRANSACTION DATA separate and secure.

Use the FOLLOWING QUERY to determine if MuliOrg is intalled:

select multi_org_flag from fnd_product_groups;

MultiOrg or Multiple Organizations Architecture allows multiple operating units and their relationships to be defined within a single installation of Oracle Applications. This keeps each operating unit's transaction data separate and secure.

Use the following query to determine if MuliOrg is intalled:

select multi_org_flag from fnd_product_groups;

CONTENT VIEW, STACKED View.

Content View, Stacked View.

The GENERAL Ledger (GL) MODULE is the basis for all other Oracle FINANCIAL modules. All other modules provide information to it. If you implement Oracle Financials, you should SWITCH your current GL system first.GL is relatively easy to implement. You should go live with it first to give your implementation team a CHANCE to be familiar with Oracle Financials.

The General Ledger (GL) module is the basis for all other Oracle Financial modules. All other modules provide information to it. If you implement Oracle Financials, you should switch your current GL system first.GL is relatively easy to implement. You should go live with it first to give your implementation team a chance to be familiar with Oracle Financials.

• Default BLOCK facility.
• Layout Editor.
• MENU Editor.
• OBJECT Lists.
• Property Sheets.
• PL/SQL Editor.
• TABLES COLUMNS Browser.
• Built-ins Browser.

• Error_type RETURN CHARACTER
• Error_code return NUMBER
• Error_text return CHAR
• Dbms_error_code return no.
• Dbms_error_text return char.

• Find_canvas
• Get-Canvas_property
• Get_view_property
• Hide_View
• Replace_content_view
• Scroll_view
• Set_canvas_property
• Set_view_property
• Show_view
• ALERT.

• Create_group (FUNCTION)
• Create_group_from_query(Function)
• Delete_group(PROCEDURE)
• Add_group_column(Function)
• Add_group_row(Procedure)
• Delete_group_row(Procedure)
• Populate_group(Function)
• Populate_group_with_query(Function)
• Set_group_Char_cell(procedure).

• Edit_text ITEM
• show_editor
• LOV.

• DEFAULT EDITOR
• User_defined EDITORS
• SYSTEM editors.

• Find_alert
• EDITORS.

• Find_window,
• get_window_property,
• hide_window,
• move_window,
• resize_window,
• set_window_property,
• show_View.

• FMB ----- Form Module BINARY.
• MMB ----- MENU Module Binary.
• PLL ------ PL/SQL LIBRARY Module Binary.

• FORM
• MENU
• LIBRARY.

• Get_group _row_count
• SYSTEM VARIABLES.

• Get_lov_property
• Set_lov_property
• RECORD GROUP.

If YES, give the name of the built-in to CHANGE the alert MESSAGES at run-time. Yes. Set_alert_property.

If yes, give the name of the built-in to change the alert messages at run-time. Yes. Set_alert_property.

• Image_add
• Image_and
• Image_subtract
• Image_xor
• Image_zoom.

It is a LIST of TEXT ELEMENTS.

It is a list of text elements.

No.

No.

No.

No.

Only When-checkbox-activated TRIGGER ASSOCIATED with a CHECK BOX.

Only When-checkbox-activated Trigger associated with a Check box.

Only when-RADIO-changed trigger ASSOCIATED with radio group VISUAL ATTRIBUTES.

Only when-radio-changed trigger associated with radio group Visual Attributes.

• PAGE - Canvas-View
• Page 0 - Canvas-view NULL.

PLAIN, CHECK,RADIO, SEPARATOR, MAGIC.

Plain, Check,Radio, Separator, Magic.

• QUERY RECORD GROUP
• STATIC record group
• NON query record group.

Radio groups DISPLAY a fixed no of options that are MUTUALLY EXCLUSIVE. User can select one out of N number of options.

Radio groups display a fixed no of options that are mutually Exclusive. User can select one out of n number of options.

RAISE form_trigger_failure.

Raise form_trigger_failure.

ROOT WINDOW, SECONDARY window.

Root window, secondary window.

• Set_window_property
• Canvas-View.

Show_alert.

Show_alert.

STOP, CAUTION, NOTE.

Stop, Caution, note.