- 
                    
 - 
                    
UTL File Package
What parameter must be set in init.ora file for utl_file package?
 - 
                    
Citrus Call
What is Citrus Call?
 - 
                    
Query based Database Tuning
What is query based database tuning?
 - 
                    
Store image, music and multimedia formats
How to store .jpg ,and .mp3, .mov formats in Oracle database?
 - 
                    
Procedure Parameter
How to take a Table Name as Parameter in Procedure?
 - 
                    
Global Index
In Oracle 10g How will you define global index?
 - 
                    
Rebuild Index
Why do we have to rebuild an index?
 - 
                    
System Parameter
What are the System Parameter in Reports 6i? Where do we make use of these paramaters?
 - 
                    
Convert Oracle 10g Report
How to convert Oracle 10g Report from pdf to excel format?
 - 
                    
SQL*Loader Procedure
How to call a procedure in SQL*Loader?
 - 
                    
Timezone of database
How to find the timezone of the database?
 - 
                    
Savepoint Names List
How do we can see savepoint names list?
 - 
                    
Clasify Constraints
How to clasify the constraints in a table? Which columns are associated to primary, composite primary, unique, and not null constraints while the inserting rows into a table?
 - 
                    
Configuration of Oracle 10g on Solaris 10
How to configure Oracle 10g on Sun Solaris 10 platform?
 - 
                    
Special character's in Oracle
How to identify the special character's in the table?
 - 
                    
New DATABASE in TOAD
How to create New DATABASE in TOAD (Oracle Application Development TOOL)
 - 
                    
Oracle Objects
What do you mean by objects in Oracle and how do they differ from Java objects?
 - 
                    
Oracel 9i and 10g Configuration file
Where is the configuration file is stored in Oracle 9i and 10g
 - 
                    
Change Label Text Dynamically
In D2K How to change the label text of a boilerplate object dynamically, using conditional triggers?
 
Oracle Basics Interview Questions

		
Ans