GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle Interview Questions


Oracle Interview Questions

Questions: 210
Comments: 98
 Oracle Tags
 Showing Questions 1-10 of 210 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 Oracle Interview Questions
Sorting Options :  

If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem? 
View Question | Asked by : sanjayocp

Explain how the cursor can become stuck between two items, resulting in a navigation trap. 
View Question | Asked by : Ivana

Latest Answer: It can be some application interacting the oracle as a server/database. Forms, Toad etc. ...
Read Answers (1) | Asked by : lokesh

Latest Answer: 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 of your repute doesnt have salary indifferences I am ...
Read Answers (2) | Asked by : mohammad

Latest Answer: 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);lc_colval VARCHAR2(4000);c_dummy c_refcur;l number;BEGINOPEN ...
Read Answers (5) | Asked by : dillip sahu

Latest Answer: with triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table ...

hi how to place different column in on columneg:if we have address column in that we have to place addr1,addr2,addr3.
Read Answers (5) | Asked by : vijay

Latest Answer: 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 execution plan to you rather which is selected by optimisation ...
Read Answers (2) | Asked by : raj

Latest Answer: B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap ...

Latest Answer: nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function returns the value of second parameter 'returned_value'.In ...
Read Answers (7) | Asked by : senthil

View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 
Sponsored Links



 

 
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape