Set - 5

Question 1 :

Identify package function from the following ?
1. Error-Code
2. Break
3. Call
4. Error-text
5. Form-failure
6. Form-fatal
7. Execute-query
8. Anchor View
9. Message_code?

Answer :

1. Error_Code
2. Error_Text
3. Form_Failure
4. Form_Fatal
5. Message_Code

Question 2 :

Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Answer :

Yes. Set_item_proprety

Question 3 :

Is it possible to attach same library to more than one form?

Answer :


Question 4 :

Can you attach an lov to a field at design time?

Answer :


Question 5 :

List the windows event triggers available in Forms 4.0?

Answer :


Question 6 :

What are the triggers associated with the image item?

Answer :

When-Image-activated(Fires when the operator double clicks on an image Items)
When-image-pressed(fires when the operator selects or deselects the image item)

Question 7 :

What is a visual attribute?

Answer :

Visual Attributes are the font, color and pattern characteristics of objects that operators see and intract with in our application.

Question 8 :

How many maximum number of radio buttons can you assign to a radio group?

Answer :

Unlimited no of radio buttons can be assigned to a radio group

Question 9 :

How do you pass the parameters from one form to another form?

Answer :

To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically. Create a parameter list to execute the add parameter built-in procedure to add one or more parameters list. Execute the call_form, New_form or run_product built_in procedure and include the name or id of the parameter list to be passed to the called form.

Question 10 :

What is a Layout Editor?

Answer :

The Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application's interface.

Question 11 :

List the Types of Items?

Answer :

Text item.
Chart item.
Check box.
Display item.
Image item.
List item.
Radio Group.
User Area item.

Question 12 :

List system variables available in forms 4.0, and not available in forms 3.0?

Answer :

System Date_threshold

Question 13 :

What are the display styles of an alert?

Answer :

Stop, Caution, note

Question 14 :

What built-in is used for showing the alert during run-time?

Answer :


Question 15 :

What built-in is used for changing the properties of the window dynamically?

Answer :


Question 16 :

What are the different types of windows?

Answer :

Root window, secondary window.

Question 17 :

What is a predefined exception available in forms 4.0?

Answer :

Raise form_trigger_failure

Question 18 :

What is a radio Group?

Answer :

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

Question 19 :

What are the different type of a record group?

Answer :

Query record group
Static record group
Non query record group

Question 20 :

What are the menu items that oracle forms 4.0 supports?

Answer :

Plain, Check,Radio, Separator, Magic

Question 21 :

Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Answer :

Page - Canvas-View
Page 0 - Canvas-view null.

Question 22 :

What triggers are associated with the radio group?

Answer :

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

Question 23 :

What are the triggers associated with a check box?

Answer :

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

Question 24 :

Can you attach an alert to a field?

Answer :


Question 25 :

Can a root window be made modal?

Answer :


Question 26 :

What is a list item?

Answer :

It is a list of text elements.

Question 27 :

List some built-in routines used to manipulate images in image_item?

Answer :


Question 28 :

Can you change the alert messages at run-time?

Answer :

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

Question 29 :

What is the built-in used to get and set lov properties during run-time?

Answer :

Record Group

Question 30 :

What is the built-in routine used to count the no of rows in a group?

Answer :

Get_group _row_count
System Variables

Question 31 :

Give the Types of modules in a form?

Answer :


Question 32 :

Write the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL?

Answer :

FMB ----- Form Module Binary.
MMB ----- Menu Module Binary.
PLL ------ PL/SQL Library Module Binary.

Question 33 :

List the built-in routine for controlling window during run-time?

Answer :


Question 34 :

List the built-in routine for controlling window during run-time?

Answer :


Question 35 :

What is the built-in function used for finding the alert?

Answer :

List the editors availables in forms 4.0?
Default editor
User_defined editors
system editors.
What buil-in routines are used to display editor dynamically?
Edit_text item

Question 36 :

What is an Lov?

Answer :

A list of values is a single or multi column selection list displayed in a pop-up window

Question 37 :

What is a record Group?

Answer :

A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

Question 38 :

Give built-in routine related to a record groups?

Answer :

Create_group (Function)

Question 39 :

List the built-in routines for the controlling canvas views during run-time?

Answer :


Question 40 :

System.effective_date system variable is read only True/False?

Answer :


Question 41 :

What are the built_in used to trapping errors in forms 4?

Answer :

Error_type return character
Error_code return number
Error_text return char
Dbms_error_code return no.
Dbms_error_text return char

Question 42 :

What is Oracle Financials? (for DBA)

Answer :

Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with:
Oracle Assets: Ensures that an organization's property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.
Oracle General Ledger: Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.
Oracle Inventory: Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.
Oracle Order Entry: Provides organizations with a sophisticated order entry system for managing customer commitments.
Oracle Payables: Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payment.
Oracle Personnel: Improves the management of employee- related issues by retaining and making available every form of personnel data.
Oracle Purchasing: Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.
Oracle Receivables:. Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.
Oracle Revenue Accounting Gives an organization timely and accurate revenue and flexible commissions reporting.
Oracle Sales Analysis: Allows for better forecasting, planning. and reporting of sales information.

Question 43 :

What are the design facilities available in forms 4.0?

Answer :

Default Block facility.
Layout Editor.
Menu Editor.
Object Lists.
Property Sheets.
PL/SQL Editor.
Tables Columns Browser.
Built-ins Browser.

Question 44 :

What is the most important module in Oracle Financials? (for DBA)

Answer :

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.

Question 45 :

What are the types of canvas-views?

Answer :

Content View, Stacked View.

Question 46 :

What is the MultiOrg and what is it used for? (for DBA)

Answer :

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;

Question 47 :

What is the difference between Fields and FlexFields? (for DBA)

Answer :

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.

Question 48 :

Explain types of Block in forms4.0?

Answer :

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

Question 49 :

What is an Alert?

Answer :

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

Question 50 :

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Answer :


Question 51 :

What is a record Group?

Answer :

A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

Question 52 :

What is a Navigable item?

Answer :

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.

Question 53 :

What is a library in Forms 4.0?

Answer :

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

Question 54 :

How image_items can be populate to field in forms 4.0?

Answer :

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.

Question 55 :

What is the content view and stacked view?

Answer :

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

Question 56 :

What is a Check Box?

Answer :

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".

Question 57 :

What is a canvas-view?

Answer :

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.

Question 58 :

Explain the following file extension related to library?

Answer :

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

Question 59 :

Explain the usage of WHERE CURRENT OF clause in cursors ?

Answer :

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

Question 60 :

Name the tables where characteristics of Package, procedure and functions are stored ?

Answer :

User_objects, User_Source and User_error.

Question 61 :

Explain the two type of Cursors ?

Answer :

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.

Question 62 :

What are two parts of package ?

Answer :

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.

Question 63 :

What are two virtual tables available during database trigger execution ?

Answer :

The table columns are referred as OLD.column_name and NEW.column_name.
For triggers related to INSERT only NEW.column_name values only available.
For triggers related to UPDATE only OLD.column_name NEW.column_name values only available.
For triggers related to DELETE only OLD.column_name values only available.

Question 64 :

What is Fine Grained Auditing? (for DBA)

Answer :

Fine Grained Auditing (DBMS_FGA) allows auditing records to be generated when certain rows are selected from a table. A list of defined policies can be obtained from DBA_AUDIT_POLICIES. Audit records are stored in DBA_FGA_AUDIT_TRAIL. Look at this example:
o Add policy on table with autiting condition...
execute dbms_fga.add_policy('HR', 'EMP', 'policy1', 'deptno > 10');
o Must ANALYZE, this feature works with CBO (Cost Based Optimizer)
analyze table EMP compute statistics;
select * from EMP where c1 = 11; -- Will trigger auditing
select * from EMP where c1 = 09; -- No auditing
o Now we can see the statments that triggered the auditing condition...
select sqltext from sys.fga_log$;
delete from sys.fga_log$;

Question 65 :

What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Answer :

The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

Question 66 :

What is a Virtual Private Database? (for DBA)

Answer :

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.

Question 67 :

What is Raise_application_error ?

Answer :

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.

Question 68 :

What is Oracle Label Security? (for DBA)

Answer :

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.

Question 69 :

Give the structure of the procedure ?

Answer :

PROCEDURE name (parameter list.....)
local variable declarations
Executable statements.
exception handlers

Question 70 :

What is OEM (Oracle Enterprise Manager)? (for DBA)

Answer :

OEM is a set of systems management tools provided by Oracle Corporation for managing the Oracle environment. It provides tools to monitor the Oracle environment and automate tasks (both one-time and repetitive in nature) to take database administration a step closer to "Lights Out" management.

Question 71 :

Question What is PL/SQL ?

Answer :

PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching.

Question 72 :

What are the components of OEM? (for DBA)

Answer :

Oracle Enterprise Manager (OEM) has the following components:
. Management Server (OMS): Middle tier server that handles communication with the intelligent agents. The OEM Console connects to the management server to monitor and configure the Oracle enterprise.
. Console: This is a graphical interface from where one can schedule jobs, events, and monitor the database. The console can be opened from a Windows workstation, Unix XTerm (oemapp command) or Web browser session (oem_webstage).
. Intelligent Agent (OIA): The OIA runs on the target database and takes care of the execution of jobs and events scheduled through the Console.

Question 73 :

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

Answer :

Mutation of table occurs.

Question 74 :

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Answer :

It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.

Question 75 :

How many types of database triggers can be specified on a table ? What are they ?

Answer :

Insert Update Delete
Before Row o.k. o.k. o.k.
After Row o.k. o.k. o.k.
Before Statement o.k. o.k. o.k.
After Statement o.k. o.k. o.k.
If FOR EACH ROW clause is specified, then the trigger for each Row affected by the statement.
If WHEN clause is specified, the trigger fires according to the returned Boolean value.

Question 76 :

What are the modes of parameters that can be passed to a procedure ?

Answer :

IN,OUT,IN-OUT parameters.

Question 77 :

Where the Pre_defined_exceptions are stored ?

Answer :

In the standard package.
Procedures, Functions & Packages ;

Question 78 :

Write the order of precedence for validation of a column in a table ?
I. done using Database triggers.
ii. done using Integarity Constraints.

Answer :

I & ii.

Question 79 :

Give the structure of the function ?

Answer :

FUNCTION name (argument list .....) Return datatype is
local variable declarations
executable statements
execution handlers

Question 80 :

Explain how procedures and functions are called in a PL/SQL block ?

Answer :

Function is called as part of an expression.
sal := calculate_sal ('a822');
procedure is called as a PL/SQL statement
calculate_bonus ('A822');
What are advantages fo Stored Procedures?
Extensibility,Modularity, Reusability, Maintainability and one time compilation.

Question 81 :

What is an Exception ? What are types of Exception ?

Answer :

Exception is the error handling part of PL/SQL block. The types are Predefined and user defined. Some of Predefined exceptions are.

Question 82 :

What are the PL/SQL Statements used in cursor processing ?

Answer :

DECLARE CURSOR name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

Question 83 :

What are the components of a PL/SQL Block ?

Answer :

Declarative part, Executable part and Exception part.
Datatypes PL/SQL

Question 84 :

What is a database trigger ? Name some usages of database trigger ?

Answer :

Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.

Question 85 :

What is a cursor ? Why Cursor is required ?

Answer :

Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.

Question 86 :

What is a cursor for loop ? 

Answer :

Cursor for loop implicitly declares %ROWTYPE as loop index, opens a cursor, fetches rows of values from active set into fields in the record and closes when all the records have been processed.
e.g.. FOR emp_rec IN C1 LOOP
salary_total := salary_total +emp_rec sal;
What will happen after commit statement ? 
Cursor C1 is
Select empno,
ename from emp;
open C1; loop
Fetch C1 into
Exit When
C1 %notfound;-----
end loop;
The cursor having query as SELECT .... FOR UPDATE gets closed after COMMIT/ROLLBACK.
The cursor having query as SELECT.... does not get closed even after COMMIT/ROLLBACK.

Question 87 :

How packaged procedures and functions are called from the following?
a. Stored procedure or anonymous block
b. an application program such a PRC *C, PRO* COBOL
c. SQL *PLUS??

Answer :

variable := PACKAGE NAME.FUNCTION NAME (arguments);
variable := PACKAGE NAME.FUNCTION NAME (arguments);
c. EXECUTE PACKAGE NAME.PROCEDURE if the procedures does not have any out/in-out parameters. A function can not be called.

Question 88 :

What is a stored procedure ?

Answer :

A stored procedure is a sequence of statements that perform specific function.

Question 89 :

What are the components of a PL/SQL block ?

Answer :

A set of related declarations and procedural statements is called block.

Question 90 :

What is difference between a PROCEDURE & FUNCTION ?

Answer :

A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.

Question 91 :

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

Answer :

A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package.
A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.

Question 92 :

What are the cursor attributes used in PL/SQL ?

Answer :

%ISOPEN - to check whether cursor is open or not
% ROWCOUNT - number of rows fetched/updated/deleted.
% FOUND - to check whether cursor has fetched any row. True if rows are fetched.
% NOT FOUND - to check whether cursor has fetched any row. True if no rows are featched.
These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.

Question 93 :

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Answer :

% TYPE provides the data type of a variable or a database column to that variable.
% ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the cursor.
The advantages are :
I. Need not know about variable's data type
ii. If the database definition of a column in a table changes, the data type of a variable changes accordingly.

Question 94 :

What is difference between % ROWTYPE and TYPE RECORD ?

Answer :

% ROWTYPE is to be used whenever query returns a entire row of a table or view.
TYPE rec RECORD is to be used whenever query returns columns of different table or views and variables.
E.g. TYPE r_emp is RECORD (eno emp.empno% type,ename emp ename %type );
e_rec emp% ROWTYPE
cursor c1 is select empno,deptno from emp;
e_rec c1 %ROWTYPE.

Question 95 :

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Answer :

Procedures and Functions,Packages and Database Triggers.

Question 96 :

What are the advantages of having a Package ?

Answer :

Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)

Question 97 :

What are the uses of Database Trigger ?

Answer :

Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.

Question 98 :

What is a Procedure ?

Answer :

A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.

Question 99 :

What is a Package ?

Answer :

A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.

Question 100 :

What is difference between Procedures and Functions ?

Answer :

A Function returns a value to the caller where as a Procedure does not.