ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Databases >> Oracle >> Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions (720)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (265)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (183)
Question
1.What is inline function in oracle and its purpose? 
2.What is the equivalent operator for "different from
pattern" in oracle? 
3. If you define a variable in oracle, how it will be
available? [a. Until database shut down b. Until table deleted
c. until session get expired]

 Question Submitted By :: Oracle-General
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
c.until session get expired. 
Is This Answer Correct ?    13 Yes 1 No
Rohit
 
Answer
# 2
3.until the table deleted. 
Is This Answer Correct ?    4 Yes 12 No
Rasmi
 
 
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is a Sequence ?   3
HOW CAN RETURN MAX DATE ROW A B C D E 1 2 1-Mar-09 5 10 1 2 10-Mar-09 5 10 ONLY USING ORACLE PREDEFINED FUNCTION. NOT USER DEFINED. OUTPUT:-- A B C D E 1 2 10-Mar-09 5 10   1
what is the difference between rollback & commit? can a foreign key has null value?   6
what is exact difference between drop and truncate table.   3
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?   3
Please explan Why static query is more faster than dynamic query ?   2
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column? IBM 1
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario? Wipro 3
what is null value? Oracle 11
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?   1
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ? IBM 2
After update how do u know how many records got updated TCS 4
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com