Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 1 Answers
- 5691 Views
- HDFC, I also Faced
- E-Mail Answers
Answer / karthik
What is the purpose of init.ora. ?
this is used for the start up and maintanence of the
databse also for security purposes.u can hv only 1 init.ora
per database.
what is a fuction based index?
There will be some situation where u always use two colums
of a table in a querey(always combined) for getting rows or
getting some fn ie:getting sal+comm point of a
employee.what we usually do is creating 2 indexes seperately
for sal and comm point.instead u write a fn for adding sal
+comm pt and creating index for that.hope u will be clear
now.but unless and until ur data results is large dont use
it.
| Is This Answer Correct ? | 6 Yes | 1 No |
How to connect ms access to oracle servers?
How to define an anonymous procedure with variables?
How to concatenate two text values in oracle?
can u call user defined functions in select statements
What are the uses of linked server and explain it in detail?
What is the function of Optimizer ?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
How to loop through data rows in the implicit cursor?
Define 'view' advantage ?
how many types of index?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the difference between a primary key & a unique key?
Oracle General 
