How to export your connection information to a file?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
How to turn on or off recycle bin for the instance?
How to start a specific oracle instance?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
How to define a variable to match a table column data type?
Explain the difference between a procedure and a function?
How are extents allocated to a segment?
How to do a full database export?
Explain the use of ignore option in imp command.
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
What is memory advisor in Oracle?
What are the logical operations?