GeekInterview.com
Series: Subject: Topic:

Oracle Concepts Interview Questions

Showing Questions 21 - 40 of 216 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Dear friendi want to know that in a table how to change the column to row.

Asked By: dillip sahu | Asked On: Oct 26th, 2006

Answered by: sreekumar_nair_it on: Nov 30th, 2007

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

Answered by: ora.nachs on: Feb 5th, 2007

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

Why should we pay you 10k salary? Why not less or more?

Asked By: mohammad | Asked On: Oct 29th, 2006

Answered by: Mohammed Sameer on: Nov 27th, 2007

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

Answered by: Gururaj on: Nov 30th, 2006

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

What do you mean by Oracle interface?

Asked By: lokesh | Asked On: May 12th, 2007

Answered by: parthokonar1 on: Sep 26th, 2007

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

What is a property clause?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

A  property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on  it.  an  object  based  on  a  property  can inherit the setting of any property in the clause that...

Answered by: fastfreeeasy on: Jul 26th, 2007

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

What are built-ins associated with timers?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

Find_timercreate_timerdelete_timer

Answered by: shiraaz on: Jul 13th, 2007

There are three builtins asociated with timer
create_timer
set_timer
delete_timer

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

Asked By: j.w | Asked On: Jul 19th, 2006

Answered by: Srinivas Ellendula on: May 13th, 2007

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

Answered by: Srinivas Ellendula on: May 13th, 2007

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

What is an lov?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

An lov is a scrollable popup window that provides the operator with EIther a single or multi column selection list.

Answered by: vinodsahani on: Feb 3rd, 2007

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

Answered by: E.gomathi on: Feb 7th, 2006

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

How can a cross product be created?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

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

Answered by: raju on: Jan 23rd, 2007

we can do this by cartesian product

no condition to be here in querry

select e.name,e.id

from emp e, emp p

What are different types of images?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

Boiler plate imagesimage items

Answered by: Srinivasa V Rao on: Dec 29th, 2006

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

Explain truncate with restore option with example

Asked By: Subbu Ramesh | Asked On: Dec 19th, 2005

Answered by: sangeetha on: Dec 27th, 2006

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

Answered by: gouthami on: Aug 15th, 2006

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;

What is relation between the window and canvas views?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

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.

Answered by: Kishor Wadhi on: Dec 20th, 2006

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

What are the different default triggers created when master deletes property is set to isolated?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

Master deletes property resulting triggers ---------------------------------------------------isolated on-clear-details on-POpulate-details

Answered by: Manikandan on: Dec 18th, 2006

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.

What are modal windows?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

Modal windows are usually used as dialogs, and have restricted functionality compared to modelless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.

Answered by: Harish on: Dec 15th, 2006

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

What are the triggers available in the reports?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

Before report, before form, after form , between page, after report.

Answered by: Prasant on: Nov 22nd, 2006

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

Answered by: imran zaher on: May 23rd, 2006

sequence of execution of the various report triggers

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

What are hints in Oracle?

Asked By: raj | Asked On: Aug 10th, 2006

Answered by: giridhar on: Nov 3rd, 2006

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

Answered by: Tejaswini Mohanty on: Sep 12th, 2006

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

What is a combo box?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

A combo box style list item combines the features found in list and text item. Unlike the pop list or the text list style list items, the combo box style list item will both display fixed values and accept one operator entered value.

Answered by: HiTen Kotak on: Sep 20th, 2006

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.

I have a server with 2gb ram.Who is the optimal size for the shared pool size the shared pool reserved size is 1/10 to shared pool size is there a mathematic type for compute the shared pool size ?

Asked By: pagath | Asked On: Mar 5th, 2006

Answered by: jatinder on: Jun 6th, 2006

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

Answered by: sapna on: Apr 4th, 2006

what is the answer?

At what point of report execution is the before report trigger fired?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

After the query is executed but before the report is executed and the records are displayed.

Answered by: krishna631 on: May 31st, 2006

Hai

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

fetch for that query.

Krishna Mohan

What is an user exit used for?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

Answered by: Phani on: May 13th, 2006

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

What are the different types of coordinations of the master with the detail block?

Asked By: Interview Candidate | Asked On: Sep 12th, 2004

Answered by: RATIKANTA MOHANTY on: May 12th, 2006

Immediate

Differred->Yes  Autoquery->Yes

Differred->Yes  Autoquery->No

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.