Can a formula column referred to columns in higher group? Category General Orac

YES

Can a repeating frame be created without a data group as a base?

NO.

What are the different modals of windows? Category Gen

Modalless windows
Modal windows

Atleast how many set of data must a data model have before a data model can be base on it?

four

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

Show editor is the generic built-in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built-in needs the input focus to be in the text item before the built-in is executed.

What is the use of place holder column?

A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.

What is a timer?

Timer is an "internal time clock" that you can programmatically create to perform an action each time the timer expires.

---

Timer is an "internal time clock" that you can programmatically create to perform an action each time the timer expires.

How do you reference a parameter indirectly?

To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SUR','Parameter my_param')

Is the After report trigger fired if the report execution fails?

yes

What is the "LOV of Validation" Property of an item? What is the use of it?

When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs.
If the value in the text item matches one of the values in the first column of the LOV, validation succeeds, the LOV is not displayed, and processing continues normally. If the value in the text item does not match one of the values in the first column of the LOV, Oracle Forms displays the LOV and uses the text item value as the search
criteria to automatically reduce the list.

Can you have more than one content canvas view attached with a window?

Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.

What is a Static Record Group?

A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at run time.

What are the types of calculated columns available?

Summary, Formula, Placeholder column.

What is new_form built-in?

When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second. If there are changes pending in the first form, the operator will be prompted to save them before the new form is loaded.

What are the Built-ins used for sending Parameters to forms?

You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

What are the two ways by which data can be generated for a parameters list of values?

1. Using static values.
2. Writing select statement.

What are the built-ins used for processing rows?

Get_group_row_count(function)
Get_group_selection_count(function)
Get_group_selection(function)
Reset_group_selection(procedure)
Set_group_selection(procedure)
Unset_group_selection(procedure)

Why is it preferable to create a fewer no. of queries in the data model?

Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time.I) TRUE II)FALSE

false.because we can add colomn after constructing table also using alter command as
SQL>alter table<table_name>(add <col_name> datatype(size));

How can I get 5th highest sal. from employee tab?

SELECT employee_id
, salary
FROM (SELECT employee_id
, salary
, dense_rank() over (order by salary desc) poradi -- 5th value
--, row_number() over (order by salary desc) poradi -- 5th row
FROM employees)
WHERE poradi = 5;

Difference between DBMS & RDBMS?

DBMS : Data Base Management System
..... for storage of data and efficient retrieval of data.
Eg: Foxpro

1)A DBMS has to be persistent (it should be accessible when
the program created the data donot exist or even the
application that created the data restarted).
2) DBMS has to provide some uniform methods independent of a
specific application for accessing the information that is
stored.
3)DBMS does not impose any constraints or security with
regard to data manipulation. It is user or the programmer
responsibility to ensure the ACID PROPERTY of the database
4)In DBMS Normalization process will not be present

RDBMS: Relational Data Base Management System
.....the database which is used by relations(tables) to
acquire information retrieval
Eg: oracle, SQL..,

1)RDBMS is based on relational model, in which data is
represented in the form of relations, with enforced
relationships between the tables.
2)RDBMS defines the integrity constraint for the purpose of
holding ACID PROPERTY.
3)In RDBMS, normalization process will be present to check
the database table cosistency
4)RDBMS helps in recovery of the database in case of loss of
database due to system failure or any other reason