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
- 5781 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 |
What are the database administrators utilities available?
how to get second highest sal of emp table
How do you rate yourself in oracle and sql server ?
How to open a cursor variable?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
what are the default admin accounts in Oracle 10g ?
What is Public Database Link ?
What happens if you lost a data file?
How to write a query with an inner join in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
How to call a stored function with parameters?
which clause we are not used in where clause?
Oracle General 
