What is an Alert ?
An alert is window that appears in the middle of the screen overlaying a portion of the current display. Read more »
‘Database Interview Questions’ - KyaPoocha.com
Explain types of Block in forms4.0?
Base table Blocks,Control Blocks.A base table block is one that is associated with a specific database table or view.A control block is a... Read more »
What is a Navigable item?
A navigable item is one that operators can navigate to with the keyboard during default navigation, or that Oracle forms can navigate to by executing ... Read more »
What is a stored procedure ?
A stored procedure is a sequence of statements that perform specific function. Read more »
What are the two parts of a procedure ?
Procedure Specification and Procedure Body. The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, ... Read more »
What is an Extent ?
An Extent is a specific number of contiguous data blocks, obtained in a single allocation, used to store a specific type of information. Read more »
What is a Segment ?
A segment is a set of extents allocated for a certain logical structure. Read more »
What is a Data Segment ?
Each Non-clustered table has a data segment. All of the table’s data is stored in the extents of its data segment. Each Eluster has a data segment. The ... Read more »
What is an Index Segment ?
Each Index has an Index segment that stores all of its data. Read more »
What is Rollback Segment ?
A Database contains one or more Rollback Segments to temporarily store “undo” information. Read more »
What is a Temporary Segment ?
Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes... Read more »
What is difference between SQL and SQL*PLUS ?
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to... Read more »
When you use WHERE clause and when you use HAVING clause ?
HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause The WHERE clause is used when you want... Read more »
What is a OUTER JOIN ?
Outer Join–Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition. Read more »
What is the purpose of a cluster ?
Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance,... Read more »
How you were passing cursor variables in PL/SQL 2.2 ?
In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version... Read more »
Difference between procedure and function ?
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... Read more »
What is difference between a formal and an actual parameter ?
The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain... Read more »
What is an UTL_FILE.What are different procedures and functions associated with it ?
UTL_FILE is a package that adds the ability to read and write to operating system files Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to... Read more »
What is index ?
INDEX is a general term for an ORACLE / SQL feature used primarily to speed execution an impose UNIQUENESS upon certain data. INDEX provides a faster access method... Read more »