Oracle Concepts Interview Questions

Try thisCREATE OR REPLACE FUNCTION FIN2008.rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2AUTHID CURRENT_USER ASTYPE c_refcur IS REF CURSOR;lc_str VARCHAR2(4000)...

we can also do this by insert all statement.....INSERT ALLINTO sales_info VALUES (employee_id,week_id,sales_MON)INTO sales_info VALUES (employee_id,week_id,sales_TUE)INTO sales_info VALUES (employee_i...

Dude Remember!when its your first job you should say"It doesnt matter if you pay me less or more i believe with my good work I would get a handsome salary today or tomorrow and I am sure organisation ...

Well,

It depends upon your company policies.I liked this figure 10000 so i demanded if ur company wants to pay more u r welcomed.

and it depends on year exp.

if ur exp then alwaz ask >  30% hike

It can be some application interacting the oracle as a server/database. Forms, Toad etc.

If you are talking about Developer/2000 then this is not Property Clause rather Property Class. One more thing is that change of visual attribute of an item is possible programatically but the same is...

There are three builtins asociated with timer
create_timer
set_timer
delete_timer

Check is there any high CPU using , u can find the infomartion by using below commands in SOLARIES/AIX servers.

nmon
sudo topas
vmstat 1 10
sar 1 10
top

Regards
Srinivas Ellendula

First  of all check the process running on that server...if the idle process is 0, look  if there are any run away processes taking most of the CPU and find exactly what it is doing... ...

Lists of Values (LOVs) enable end users to choose entry field values in a form or database portlet customization form.

LOV is list of values, used to popup the single or multiple values at run time

we can do this by cartesian product

no condition to be here in querry

select e.name,e.id

from emp e, emp p

I think there are 2 types of images one is Boiler Plate Images and another Image Items.

In oracle,DDL command,if u give TRUNCATE command,storage of data will get lost and structure of table will be there as it,roll back option is not there once u truncate the table

Truncate is a DDL Command. When used in SQL Statement Deletes the data of the table permanently i.e It Cannot be rolledback Leaving only the structure behind.

Ex.truncate table tablename;

if the needs to be restored than use the delete command .

Ex.Delete *or columns from tablename;

Canvas is associated with windows , where we can define different items and Attributes.

On_clear_details -form level-> calls Clear_All_Master_Details proc.

on_populate_details block level->calls Query_Master_Details proc. after checking foriegn key of null value.

A modal window is any type of window that is a child (secondary window) to a parent window and usurps the parent's control. It is commonly associated with an Internet Web site pop-up window&...

There are 3types of trigger available in report

1.Report trigger

before parameter form

After parameter form

Before report

Between page

After report

2.Data Model Trigger

Formula trigger

Group filter

3.Layout Trigger

Format Trigger

sequence of execution of the various report triggers

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

Generally oracle uses Cost_based optimisation. In this method it will calculate all the execution plans for the query to execute and chooses the best optimal plan. Sometimes we may know the best execu...

HINTS  are nothing but the comments used in a SQL statement to pass instructions to the Oracle optimizer.The optimizer uses these hints as suggestions for choosing an execution plan for the state...

It's like pre-defined box having a list of value & operator can select any of them...for an example "Sex:" or "State" here you can use combo box..as you can pre-define these values.

the suggested size of SGA should be half of RAM i.e 1GB in this case.For OLTP database

what is the answer?

Hai

Before report trigger fires after, the parameter trigger raises and before data

fetch for that query.

Krishna Mohan

A user Exit is the program that can be written and linked into the Report builder Executable. We normally get information from the Multi Organization Views ( in Reports). We have 5 different types o...

Immediate

Differred->Yes  Autoquery->Yes

Differred->Yes  Autoquery->No