Explore topic-wise InterviewSolutions in .

A PRIMARY KEY and a FOREIGN key.

A primary key and a foreign key.

A BITMAP INDEX.

A Bitmap index.

FASTER ACCESS to DATA BLOCKS in a table.

Faster access to data blocks in a table.

Both the truncate and delete command have the DESIRED outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL OPERATION and just moves the high water MARK and produces a now rollback. The delete command, on the other HAND, is a DML operation, which will produce a rollback and THUS take longer to complete.

Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. The delete command, on the other hand, is a DML operation, which will produce a rollback and thus take longer to complete.

In the ALERT LOG.

In the alert log.

USE the DESCRIBE COMMAND or use the dbms_metadata.get_ddl PACKAGE.

Use the describe command or use the dbms_metadata.get_ddl package.

ISSUE the CREATE SPFILE from PFILE COMMAND.

Issue the create spfile from pfile command.

I WOULD create a TEXT based backup control file, stipulating where on disk all the data files where and then issue the RECOVER command with the using backup control file CLAUSE.

I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

By USING DISTINCT.

By using DISTINCT.

Cursor For Loop is a loop where ORACLE IMPLICITLY DECLARES a loop variable, the loop INDEX that of the same record type as the cursor's record.

Cursor For Loop is a loop where oracle implicitly declares a loop variable, the loop index that of the same record type as the cursor's record.

-Data base trigger(DBT) FIRES when a DML OPERATION is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen
-Can be row level or statement level No distinction between row level and statement level.
-Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.
-Can be fired from any SESSION executing the triggering DML statements. Can be fired only from the form that define the trigger.
-Can cause other database triggers to FIRE.Can cause other database triggers to fire, but not other form triggers.

-Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen
-Can be row level or statement level No distinction between row level and statement level.
-Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.
-Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger.
-Can cause other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.

DROP PROCEDURE procedure_name.
Drop FUNCTION function_name.

Drop Procedure procedure_name.
Drop Function function_name.

FUNCTIONS are NAMED PL/SQL BLOCKS that return a value and can be called with arguments PROCEDURE a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as PART of an expression.

Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

Installing and upgrading the Oracle Server and application tools. Allocating system storage and planning future storage requirements for the database system. Managing primary database structures (TABLESPACES) Managing primary objects (table,views, indexes) Enrolling users and MAINTAINING system security. Ensuring compliance with Oralce license agreement Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database. Planning for backup and recovery of database information. Maintain archived data on tape Backing up and restoring the database. CONTACTING Oracle Corporation for technical SUPPORT.

Installing and upgrading the Oracle Server and application tools. Allocating system storage and planning future storage requirements for the database system. Managing primary database structures (tablespaces) Managing primary objects (table,views, indexes) Enrolling users and maintaining system security. Ensuring compliance with Oralce license agreement Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database. Planning for backup and recovery of database information. Maintain archived data on tape Backing up and restoring the database. Contacting Oracle Corporation for technical support.

COST and RULE.

COST and RULE.

The COMBINATIONS of the STEPS the optimizer CHOOSES to execute a statement is called an EXECUTION plan.

The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.

The goal of the optimizer is to choose the most EFFICIENT WAY to EXECUTE a SQL statement.

The goal of the optimizer is to choose the most efficient way to execute a SQL statement.

CHOOSING an executing planbased on the ACCESS paths available and the ranks of these access paths.

Choosing an executing planbased on the access paths available and the ranks of these access paths.

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 USER NAMED editor can be DISPLAYED PROGRAMMATICALLY with the BUILT in procedure SHOWEDITOR, EDIT_TETITEM independent of any particular text item.

A user named editor can be displayed programmatically with the built in procedure SHOWEDITOR, EDIT_TETITEM independent of any particular text item.

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.

An ANCHORING object is a PRINT condition object which used to explicitly or IMPLICITLY anchor other OBJECTS to itself.

An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

A BREAK group is USED to DISPLAY ONE record for one group ones. While multiple RELATED records in other group can be displayed.

A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

EXECUTE TRIGGER (trigger-name).

Execute Trigger (trigger-name).

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.

ERASE REMOVES an INDICATED GLOBAL VARIABLE.

Erase removes an indicated global variable.

It is USED to SET the optimal length of a ROLLBACK segment.

It is used to set the optimal length of a rollback segment.

NAME of the PARAMETER FILE to be PASSED for EXPORT.

Name of the parameter file to be passed for export.

Object Linking & Embedding provides you with the capability to integrate objects from MANY Ms- Windows APPLICATIONS into a single compound DOCUMENT CREATING integrated applications enables you to USE the features form .

Object Linking & Embedding provides you with the capability to integrate objects from many Ms- Windows applications into a single compound document creating integrated applications enables you to use the features form .

PROCEDURE SPECIFICATION and Procedure BODY.

Procedure Specification and Procedure Body.

Display ITEMS are SIMILAR to TEXT items but store only fetched or assigned VALUES.

Display items are similar to text items but store only fetched or assigned values.

BOILERPLATE IMAGES.
Image_items.

Boilerplate Images.
Image_items.

Block is a SINGLE MECHANISM for grouping related items into a functional UNIT for storing, displaying and manipulating records.

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

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.

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

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

Because, in a where CLAUSE the CONDITION is APPLIED during DATA retrievalthan after RETRIEVING the data.

Because, in a where clause the condition is applied during data retrievalthan 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:

When this CLAUSE is used with the DROP command, a parent table can be dropped even when a child table exists.

When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.

DROP TABLE &TABLE_NAME; VARIABLE NAMES should start with an alphabet. Here the table name STARTS with an '&' symbol.

DROP TABLE &TABLE_NAME; Variable names should start with an alphabet. Here the table name starts with an '&' symbol.

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD.

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD.

The privilege RECEIVER can further GRANT the PRIVILEGES he/she has OBTAINED from the owner to any other user.

The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.

RUN.

RUN.

MONTHS_BETWEEN.

MONTHS_BETWEEN.

LIKE OPERATOR.

LIKE operator.

It is USED to DROP CONSTRAINTS SPECIFIED on the table.

It is used to drop constraints specified on the table.

IS NULL OPERATOR.

IS NULL operator.

INSERT, update, DELETE, SELECT, REFERENCES, index, EXECUTE, alter, all.

Insert, update, delete, select, references, index, execute, alter, all.

FLOOR.

FLOOR.