Explore topic-wise InterviewSolutions in .

MODAL windows are usually used as DIALOGS, and have restricted FUNCTIONALITY COMPARED to modalless windows. On some platforms for example operators cannot resize, scroll or iconify a modal WINDOW.

Modal windows are usually used as dialogs, and have restricted functionality compared to modalless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.

• Modalless WINDOWS,
• MODAL windows.

No.

No.

No.

No.

No.

No.

No.

No.

One can select from the SYS.V_$PWFILE_USERS view to SEE which users are listed in the password file. New users can be added to the password file by GRANTING them SYSDBA or SYSOPER privileges, or by USING the orapwd utility. GRANT SYSDBA TO scott;

One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility. GRANT SYSDBA TO scott;

No.

No.

No.

No.

• On-Check_delete_master,
• On_clear_details,
• On_populate_details.

ONE down REPEATING FRAME below one ACROSS repeating frame.

One down repeating frame below one across repeating frame.

Oracle DBAs and OPERATORS typically use administrative accounts to MANAGE the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA and SYSOPER ALLOW ACCESS to a database instance even if it is not RUNNING. Control of these privileges is managed outside of the database via password files and special operating system groups. This password file is created with the orapwd utility.

Oracle DBAs and operators typically use administrative accounts to manage the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA and SYSOPER allow access to a database instance even if it is not running. Control of these privileges is managed outside of the database via password files and special operating system groups. This password file is created with the orapwd utility.

Only one WINDOW in a form can DISPLAY the CONSOLE, and you cannot change the console assignment at runtime.

Only one window in a form can display the console, and you cannot change the console assignment at runtime.

1. ORACLE PRECOMPILER exits,
2. Oracle call INTERFACE,
3. NonOracle user exits.

Parameters PROVIDE a simple MECHANISM for defining and setting the values of inputs that are required by a form at startup. Form parameters are VARIABLES of type CHAR, number, date that you define at design time.

Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type char, number, date that you define at design time.

PERCENTAGE of TOTAL FUNCTIONS.

percentage of total functions.

PERFORMING the CALCULATION in the QUERY is FASTER.

performing the calculation in the query is faster.

• Pop_list,
• Text_list,
• COMBO BOX.

POST-form commit fires once during the post and commit transactions process, after the database commit OCCURS. The post-form-commit trigger fires after inserts, updates and deletes have been POSTED to the database but before the transactions have been finalized in the issuing the COMMAND. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

Previewer.

Previewer.

• QUERY RECORD GROUPS,
• NonQuery Record Groups,
• STATE Record Groups.

READ only.

Read only.

Record group COLUMN NAMES cannot exceed 30 CHARACTERS.

Record group column names cannot exceed 30 characters.

Oracle will stop updating file headers, but will CONTINUE to WRITE data to the database files even if a tablespace is in backup mode. In backup mode, Oracle will write out complete changed blocks to the REDO log files. NORMALLY only deltas (changes) are logged to the redo logs. This is done to enable reconstruction of a block if only half of it was backed up (split blocks). Because of this, one should notice increased log activity and archiving during on-line BACKUPS.

Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode. In backup mode, Oracle will write out complete changed blocks to the redo log files. Normally only deltas (changes) are logged to the redo logs. This is done to enable reconstruction of a block if only half of it was backed up (split blocks). Because of this, one should notice increased log activity and archiving during on-line backups.

RECORD GROUP.

Record Group.

• REP FILE and,
• RDF file.

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.

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.

Stacked canvas view is displayed in a WINDOW on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the UNDERLYING content canvas view, and or OFTEN shown and hidden PROGRAMMATICALLY.

Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

• SUMMARY,
• FORMULA,
• PLACEHOLDER COLUMN.

• System.mouse_button_pressed,
• System.mouse_button_shift.

• TEXT PARAMETERS and,
• DATA Parameters.

The console includes the STATUS line and MESSAGE line, and is displayed at the bottom of the window to which it is assigned.To specify that the console should be displayed, SET the console window FORM PROPERTY to the name of any window in the form. To include the console, set console window to Null.

The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.

The coordination properties are:

• DEFERRED.
• Auto-Query.

These Properties DETERMINE when the population PHASE of block coordination should OCCUR.

The coordination properties are:

These Properties determine when the population phase of block coordination should occur.

The default file extensions indicate the library MODULE type and storage format.pll - pl/sql library module BINARY.

The default file extensions indicate the library module type and storage format.pll - pl/sql library module binary.

The maximum no of chars the parameter can store is only valid for CHAR parameters, which can be upto 64K. No parameters DEFAULT to 23 Bytes and DATE parameter default to 7 Bytes.

The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23 Bytes and Date parameter default to 7 Bytes.

The pop list style list item appears initially as a single FIELD (similar to a TEXT item field). When the operator SELECTS the list icon, a list of AVAILABLE choices appears.

The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.

The TERM file which key is correspond to which ORACLE REPORT FUNCTIONS.

The term file which key is correspond to which oracle report functions.

The term is terminal definition file that DESCRIBES the terminal FORM which you are using r20run.

The term is terminal definition file that describes the terminal form which you are using r20run.

The text list style list item appears as a rectangular box which displays the fixed NUMBER of VALUES. When the text list contains values that can not be displayed, a vertical SCROLL bar appears, ALLOWING the operator to view and select undisplayed values.

The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select undisplayed values.

There are three most common TYPES of complex MASTER-DETAIL relationships:

• master with DEPENDENT details
• master with independent details
• detail with TWO masters

There are three most common types of complex master-detail relationships:

There are TWO phases of block COORDINATION:

1. The clear phase and.
2. The population phase.

During, the clear phase, Oracle Forms navigates INTERNALLY to the detail block and flushes the obsolete detail records. During the population phase, Oracle Forms issues a SELECT statement to repopulate the detail block with detail records associated with the new master record. These operations are accomplished through the execution of TRIGGERS.

There are two phases of block coordination:

During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete detail records. During the population phase, Oracle Forms issues a SELECT statement to repopulate the detail block with detail records associated with the new master record. These operations are accomplished through the execution of triggers.

TIMER is an "internal TIME CLOCK" that you can programmatically create to perform an ACTION each time the times.

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

To MANIPULATE IMAGES in IMAGE ITEMS.

To manipulate images in image items.

To specify the ORDER of INDIVIDUAL group EVALUATION in a CROSS PRODUCTS.

To specify the order of individual group evaluation in a cross products.

TOOL bar canvas views are used to CREATE tool bars for INDIVIDUAL WINDOWS. Horizontal tool bars are DISPLAY at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window.

Tool bar canvas views are used to create tool bars for individual windows. Horizontal tool bars are display at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window.

True.

True.

Two group that is above are the LEFT most RANK HIGHER than the group that is to right or below it.

Two group that is above are the left most rank higher than the group that is to right or below it.

USE reports profile executable statement. Use SQL TRACE facility.

Use reports profile executable statement. Use SQL trace facility.

Using open_form built-in SETTING the session option Ex. Open_form('Stocks', active, session). when invoke the mulitiple forms with OPEN FORM and call_form in the same application, STATE whether the following are true/False

Using open_form built-in setting the session option Ex. Open_form('Stocks', active, session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False

Using TRANSACTIONAL triggers we can control or modify the DEFAULT FUNCTIONALITY of the ORACLE forms.

Using transactional triggers we can control or modify the default functionality of the oracle forms.