Explore topic-wise InterviewSolutions in .

COST and RULE.

COST and RULE.

Each server and background process can WRITE an associated trace file. When an internal error is detected by a process or user process, it DUMPS INFORMATION about the error to its trace. This can be used for tuning the DATABASE.

Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.

A record group can have an UNLIMITED number of COLUMNS of type CHAR, LONG, NUMBER, or DATE provided that the TOTAL number of column does not EXCEED 64K.

A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

A panel is the no. of physical pages NEEDED to PRINT one LOGICAL page.

A panel is the no. of physical pages needed to print one logical page.

A MASTER detail relationship is an association between TWO base table BLOCKS- a master block and a detail block. The relationship between the blocks REFLECTS a PRIMARY key to foreign key relationship between the tables on which the blocks are based.

A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.

A LIBRARY is a collection of subprograms INCLUDING user named PROCEDURES, FUNCTIONS and packages.

A library is a collection of subprograms including user named procedures, functions and packages.

ERASE REMOVES an INDICATED GLOBAL VARIABLE.

Erase removes an indicated global variable.

It is AREA in memory that is USED by a SINGLE Oracle User PROCESS.

It is area in memory that is used by a Single Oracle User Process.

NAME of the PARAMETER FILE to be PASSED for EXPORT.

Name of the parameter file to be passed for export.

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

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

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

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

When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA (ORACLE Intelligent Agent). The OIA maintains a .jou file in the agent's subdirectory. When the console is launched communication with the Agent is established and the CONTENTS of the .jou file (BINARY) are reported to the console job SUBSYSTEM. Note that OEM will not be able to send e-mail and paging notifications when the Console is not started.

When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA (Oracle Intelligent Agent). The OIA maintains a .jou file in the agent's subdirectory. When the console is launched communication with the Agent is established and the contents of the .jou file (binary) are reported to the console job subsystem. Note that OEM will not be able to send e-mail and paging notifications when the Console is not started.

INSTR (STRING1,String2(n,(m)),INSTR returns the position of the MTH occurrence of the string 2 instring1. The SEARCH begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of SIZE m in string1, starting from nth position of string1.

INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

OEM comes with pre-defined JOBS like EXPORT, Import, run OS commands, run SQL scripts, SQL*Plus commands etc. It ALSO gives you the flexibility of scheduling CUSTOM jobs written with the TCL language.

OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a REMOTE node in the NETWORK to make the node OEM manageable. The Oracle Intelligent Agent is responsible for:

•  Discovering targets that can be managed (Database Servers, Net8 Listeners, etc.);
•  MONITORING of events registered in Enterprise Manager; and
•  Executing tasks associated with JOBS submitted to Enterprise Manager.

The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is responsible for:

One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more INFORMATION about TCL:

•  The Tcl Developer Xchange - download and learn about TCL
•  OraTCL at SOURCEFORGE - Download the OraTCL package
•  TOM Poindexter's Tcl PAGE - Oratcl was originally written by Tom Poindexter

One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL:

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.

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.

By SETTING the Restrict To LIST property to TRUE in the PARAMETER property SHEET.

By setting the Restrict To List property to true in the parameter property sheet.

SQL*Loader is a bulk loader utility used for moving data from external FILES into the Oracle database. Its SYNTAX is similar to that of the DB2 LOAD utility, but comes with more options.
SQL*Loader supports various load FORMATS, selective LOADING, and multi-table loads.

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options.
SQL*Loader supports various load formats, selective loading, and multi-table loads.

By selecting the cross products tool and DRAWING a new GROUP SURROUNDING the base group of the cross products.

By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.

Because, in a where clause the condition is APPLIED during DATA retrieval then after RETRIEVING the data.

Because, in a where clause the condition is applied during data retrieval then after retrieving the data.

One can create one logical record from multiple physical RECORDS using one of the following TWO CLAUSES:

•  CONCATENATE: - use when SQL*LOADER should combine the same number of physical records TOGETHER to form one logical record.
•  CONTINUEIF - use if a condition indicates that multiple records should be treated as one. Eg. by having a '#' character in column 1.

One can create one logical record from multiple physical records using one of the following two clauses:

The conventional PATH loader essentially loads the data by using standard INSERT STATEMENTS. The DIRECT path loader (DIRECT=TRUE) bypasses much of the logic involved with that, and loads directly into the Oracle data FILES. 

The conventional path loader essentially loads the data by using standard INSERT statements. The direct path loader (DIRECT=TRUE) bypasses much of the logic involved with that, and loads directly into the Oracle data files. 

Before FORM , After form , Before REPORT, Between PAGE, After report.

Before form , After form , Before report, Between page, After report.

Bind reference are used to replace the single VALUE in SQL, pl/sql statements a bind reference can be CREATED using a (:) before a column or a parameter NAME.

Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

By USING SRW.MESSAGE FUNCTION.

By using SRW.MESSAGE function.

By USING the link FILE PROPERTY in the LAYOUT boiler plate property SHEET.

By using the link file property in the layout boiler plate property sheet.

By using the rectangle TOOL while PRESSING the (CONSTRAINT) KEY.

By using the rectangle tool while pressing the (Constraint) key.

By USING the tables/columns BUTTON and then SPECIFYING the table and the COLUMN NAMES.

By using the tables/columns button and then specifying the table and the column names.

CALLS the USER exit NAMED in the user_exit_string. Invokes a 3Gl program by name which has been properly LINKED into your current oracle forms executable.

Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.

Canvas VIEWS are the BACK GROUND objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your FORM . Each canvas views displayed in a window.

Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

• CASCADE
• ISOLATE
• Non-isolate

• Content CANVAS views
• Stacked canvas views
• HORIZONTAL TOOLBAR
• vertical toolbar.

CREATE-GROUP (FUNCTION)
CREATE_GROUP_FROM_QUERY(function)
DELETE_GROUP(PROCEDURE)

CREATE-GROUP (function)
CREATE_GROUP_FROM_QUERY(function)
DELETE_GROUP(procedure)

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.

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.

By DRAGGING the COLUMN OUTSIDE the GROUP.

By dragging the column outside the group.

False

False

FIND_GROUP(FUNCTION)
FIND_COLUMN(function)

FIND_GROUP(function)
FIND_COLUMN(function)

FORMAT TRIGGER.

Format trigger.

Four.

Four.

In Reports 2.0 the link tool has to be selected and then two fields to be LINKED are selected and the link is automatically CREATED. In 2.5 the first FIELD is selected and the link tool is then USED to link the first field to the SECOND field.

In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

No.

No.

No.

No.

No.

No.

No.

No.

No.

No.

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.

RECORD GROUP.

Record Group.

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

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

True.

True.