DBMS ( 5 )

401. What are the different types of Package Procedure ?

1. Restricted package procedure.
2. Unrestricted package procedure.

402. What are the types of TRIGGERS ?

1. Navigational Triggers.
2. Transaction Triggers.

403. 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?

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

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

Yes. Set_item_proprety

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

Yes

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

Yes

406. List the windows event triggers available in Forms 4.0?

When-window-activated,
when-window-closed,
when-window-deactivated,
when-window-resized

407. What are the triggers associated with the image item?

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)

408. What is a visual attribute?

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

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

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

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

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.

411. What is a Layout Editor?

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

412. List the Types of Items?

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

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

System.cordination_operation
System Date_threshold
System.effective_Date
System.event_window
System.suppress_working

414. What are the display styles of an alert?

Stop, Caution, note

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

Show_alert.

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

Set_window_property
Canvas-View

417. What are the different types of windows?

Root window, secondary window.

418. What is a predefined exception available in forms 4.0?

Raise form_trigger_failure

419. What is a radio Group?

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

419. What are the different type of a record group?

Query record group
Static record group
Non query record group

420. What are the menu items that oracle forms 4.0 supports?

Plain, Check,Radio, Separator, Magic

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

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

422. What triggers are associated with the radio group?

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

423. What are the triggers associated with a check box?

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

424.Can you attach an alert to a field?

No

425. Can a root window be made modal?

No

426. What is a list item?

It is a list of text elements.

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

Image_add
Image_and
Image_subtract
Image_xor
Image_zoom

428. Can you change the alert messages at run-time?

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

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

Get_lov_property
Set_lov_property
Record Group

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

Get_group _row_count
System Variables

431. Give the Types of modules in a form?

Form
Menu
Library

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

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

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

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

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

Find_canvas
Get-Canvas_property
Get_view_property
Hide_View
Replace_content_view
Scroll_view
Set_canvas_property
Set_view_property
Show_view
Alert

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

Find_alert
Editors

436. List the editors availables in forms 4.0?

Default editor
User_defined editors
system editors.

437. What buil-in routines are used to display editor dynamicaly?

Edit_text item
show_editor
LOV

438. What is an Lov?

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

439. What is a record Group?

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

440. Give built-in routine related to a record groups?

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)

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

Find_canvas
Get-Canvas_property
Get_view_property
Hide_View
Replace_content_view
Scroll_view
Set_canvas_property
Set_view_property
Show_view
Alert


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

False

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

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

444. what is a display item?

Display items are similar to text items but store only fetched or
assigned values. Operators cannot navigate to a display item or edit
the value it contains.

445. What are the design facilities available in forms 4.0?

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

446. What are the types of visual attribute settings?

Custom Visual attributes Default visual attributes Named Visual
attributes. Window

447. What are the types of canvas-views?

Content View, Stacked View.

448. What are the two ways to incorporate images into a oracle forms
application?

Boilerplate Images
Image_items

449. What do you mean by a block in forms4.0?

Block is a single mechanism for grouping related items into a
functional unit for storing, displaying and manipulating records.

450. Explain types of Block in forms4.0?

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

451. What is an Alert?

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

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

Add_parameter
Create_Parameter_list
Delete_parameter
Destroy_parameter_list
Get_parameter_attr
Get_parameter_list
set_parameter_attr

456 .What is a record Group?

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

457 What is a Navigable item?

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.

458. What is a library in Forms 4.0?

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

460. How image_items can be populate to field in forms 4.0?

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.

461. What is the content view and stacked view?

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

462. What is a Check Box?

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

463. What is a canvas-view?

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.

464. Explain the following file extension related to library?

.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

465. Explain the usage of WHERE CURRENT OF clause in cursors ?

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

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

User_objects, User_Source and User_error.

467. Explain the two type of Cursors ?

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.

468. What are two parts of package ?

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.

469. What are two virtual tables available during database trigger
execution ?

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.

470. What is Overloading of procedures ?

The Same procedure name is repeated with parameters of different
datatypes and parameters in different positions, varying number of
parameters is called overloading of procedures. e.g. DBMS_OUTPUT
put_line

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

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)

472. What are the return values of functions SQLCODE and SQLERRM ?
What is Pragma EXECPTION_INIT ? Explain the usage ?

SQLCODE returns the latest code of the error that has occurred.
SQLERRM returns the relevant error message of the SQLCODE.

473. What are the datatypes a available in PL/SQL ?

Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG,
BOOLEAN. Some composite data types such as RECORD & TABLE.

474. What is Raise_application_error ?

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.

475. What are the two parts of a procedure ?

Procedure Specification and Procedure Body.

476. Give the structure of the procedure ?

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

477. What is the basic structure of PL/SQL ?

PL/SQL uses block structure as its basic structure. Anonymous blocks
or nested blocks can be used in PL/SQL.

478. Question What is PL/SQL ?

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

479. What is PL/SQL table ?

Objects of type TABLE are called "PL/SQL tables", which are modeled
as (but not the same as) database tables, PL/SQL tables use a
primary PL/SQL tables can have one column and a primary key. Cursors

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

Mutation of table occurs.

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

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.

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

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.

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

IN,OUT,IN-OUT parameters.

484. Where the Pre_defined_exceptions are stored ?

In the standard package.
Procedures, Functions & Packages ;

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

I & ii.

486. Give the structure of the function ?

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

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

Function is called as part of an __expression.
sal := calculate_sal ('a822');
procedure is called as a PL/SQL statement
calculate_bonus ('A822');

488. What are advantages fo Stored Procedures?

Extensibility,Modularity, Reusability, Maintainability and one time
compilation.

489. What is an Exception ? What are types of Exception ?

Exception is the error handling part of PL/SQL block. The types are
Predefined and user defined. Some of Predefined exceptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.

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

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

491. What are the components of a PL/SQL Block ?

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

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

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.

493. What is a cursor ? Why Cursor is required ?

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.

494. What is a cursor for loop ?

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.
eg. FOR emp_rec IN C1 LOOP
salary_total := salary_total +emp_rec sal;
END LOOP;

495. What will happen after commit statement ?

Cursor C1 is
Select empno,
ename from emp;
Begin
open C1; loop
Fetch C1 into
eno.ename;
Exit When
C1 %notfound;-----
commit;
end loop;
end;
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.

496. 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??


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

497. What is a stored procedure ?

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

498. What are the components of a PL/SQL block ?

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

499. What is difference between a PROCEDURE & FUNCTION ?

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.

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

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.