Explore topic-wise InterviewSolutions in .

We have CONTROL over the FIRING of a STORED PROCEDURE but we have no control over the firing of a TRIGGER.

We have control over the firing of a stored procedure but we have no control over the firing of a trigger.

The parts of a TRIGGER are:

A TRIGGERING event or STATEMENT, A trigger RESTRICTION, A trigger ACTION.

The parts of a trigger are:

A triggering event or statement, A trigger restriction, A trigger action.

YES. You can pass parameters to PROCEDURES or functions in a PACKAGE.

Yes. You can pass parameters to procedures or functions in a package.

So that GRANTS are not DROPPED.

So that Grants are not dropped.

The constructs of a procedure, function or a PACKAGE are :

VARIABLES and CONSTANTS, cursors, EXCEPTIONS.

The constructs of a procedure, function or a package are :

variables and constants, cursors, exceptions.

No.

No.

Yes.

Yes.

Over Loading means an object performing different functions DEPENDING UPON the number of PARAMETERS or the data TYPE of the parameters passed to it.

Over Loading means an object performing different functions depending upon the number of parameters or the data type of the parameters passed to it.

IN, OUT AND INOUT.

IN, OUT AND INOUT.

No.

No.

Yes.

Yes.

Yes.

Yes.

FUNCTIONS return a single variable by VALUE WHEREAS procedures do not return any variable by value. Rather they return multiple VARIABLES by passing variables by reference through their OUT PARAMETER.

Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.

No.

No.

USER DEFINED and PREDEFINED EXCEPTIONS.

User defined and Predefined Exceptions.

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. More information about the RESTRICTIONS of direct path loading can be obtained from the Utilities USERS GUIDE.

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. More information about the restrictions of direct path loading can be obtained from the Utilities Users Guide.

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

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

Boiler plate Images are static images (Either vector or bit map) that you import from the file SYSTEM or DATABASE to use a GRAPHICAL elements in your form, such as company logos and maps. Image items are special types of interface controls that store and display either vector or BITMAP images. Like other items that store values, image items can be either base table items(items that relate directly to database columns) or control items. The definition of an image item is stored as part of the form MODULE FMB and FMX files, but no image file is actually associated with an image item until the item is populate at run time.

Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a graphical elements in your form, such as company logos and maps. Image items are special types of interface controls that store and display either vector or bitmap images. Like other items that store values, image items can be either base table items(items that relate directly to database columns) or control items. The definition of an image item is stored as part of the form module FMB and FMX files, but no image file is actually associated with an image item until the item is populate at run time.

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

CUSTOM Visual ATTRIBUTES Default visual attributes NAMED Visual attributes. WINDOW.

Custom Visual attributes Default visual attributes Named Visual attributes. Window.

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:

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.

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.

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.

INTERSECT - returns all distinct ROWS SELECTED by both QUERIES.

MINUS - returns all distinct rows selected by the first query but not by the second.

UNION - returns all distinct rows selected by either query.

UNION ALL - returns all rows selected by either query, including all duplicates.

INTERSECT - returns all distinct rows selected by both queries.

MINUS - returns all distinct rows selected by the first query but not by the second.

UNION - returns all distinct rows selected by either query.

UNION ALL - returns all rows selected by either query, including all duplicates.

Recovery Manager is a TOOL that MANAGES the process of creating backups and ALSO manages the process of RESTORING and recovering from them.

Recovery Manager is a tool that manages the process of creating backups and also manages the process of restoring and recovering from them.

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.

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.

PL/SQL USES BLOCK structure as its basic structure. Anonymous BLOCKS or nested blocks can be used in PL/SQL.

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

PROCEDURE SPECIFICATION and Procedure BODY.

Procedure Specification and Procedure Body.

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.

SQLCODE - RETURNS the latest code of the ERROR that has occurred.

SQLERRM - returns the RELEVANT error message of the SQLCODE.

SQLCODE - returns the latest code of the error that has occurred.

SQLERRM - returns the relevant error message of the SQLCODE.

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.

No.

No.

No.

No.

OBJECTS of different modules, Another object groups, Individual block DEPENDENT ITEMS, Program UNITS.

Objects of different modules, Another object groups, Individual block dependent items, Program units.

Only for 10 RECORDS.

Only for 10 records.

LIST of TABLES should be exported.ze).

List of tables should be exported.ze).

Oracle user accounts can be LOCKED, UNLOCKED, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB DATABASE using the DB Configuration Assistant (dbca). DBA's must UNLOCK these accounts to make them available to users.

Look at these examples:

ALTER USER scott ACCOUNT LOCK -- lock a user account.
ALTER USER scott ACCOUNT UNLOCK; -- unlocks a locked users account.
ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password.

Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB Configuration Assistant (dbca). DBA's must unlock these accounts to make them available to users.

Look at these examples:

ALTER USER scott ACCOUNT LOCK -- lock a user account.
ALTER USER scott ACCOUNT UNLOCK; -- unlocks a locked users account.
ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password.

The static lov CONTAINS the PREDETERMINED values while the dynamic lov contains values that COME at run time.

The static lov contains the predetermined values while the dynamic lov contains values that come at run time.

The minimum NUMBER of GROUPS in MATRIX report are 4.

The minimum number of groups in matrix report are 4.

We can use the same LOV for 2 columns by passing the return values in GLOBAL values and USING the global values in the code.

We can use the same lov for 2 columns by passing the return values in global values and using the global values in the code.

The INLINE and PRECOMPILER directives DETECT the values DIRECTLY.

The inline and precompiler directives detect the values directly.

There are 2 TYPES of exceptions. They are

1. SYSTEM Exceptions

e.g. When no_data_found, When too_many_rows

2. USER DEFINED Exceptions

e.g. My_exception exception, When My_exception then

There are 2 types of exceptions. They are

e.g. When no_data_found, When too_many_rows

e.g. My_exception exception, When My_exception then

We can IMPLEMENT the if statement in the SELECT statement by USING the Decode statement.

e.g. select DECODE (EMP_CAT,'1','First','2','Second'Null);

Here the Null is the ELSE statement where null is done .

We can implement the if statement in the select statement by using the Decode statement.

e.g. select DECODE (EMP_CAT,'1','First','2','Second'Null);

Here the Null is the else statement where null is done .

It is a MEASURE of WELL the data cache buffer is handling requests for data. Hit RATIO = (Logical Reads - Physical Reads - Hits MISSES) / Logical Reads.

It is a measure of well the data cache buffer is handling requests for data. Hit Ratio = (Logical Reads - Physical Reads - Hits Misses) / Logical Reads.

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.

BREAK, SYSTEM VARIABLES.

Break, SYSTEM VARIABLES.

CALL (E.g. Call(FORMNAME).

Call (E.g. Call(formname).

Copy is package procedure and writes VALUES into a field. NAME in is a package FUNCTION and RETURNS the CONTENTS of the variable to which you apply.

Copy is package procedure and writes values into a field. Name in is a package function and returns the contents of the variable to which you apply.