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 ?
Answer Posted / 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 |
Post New Answer View All Answers
IS it possible to built the oracle database without setting the kernal parameters?
Why use resource manager in Oracle?
How to find out what oracle odbc drivers are installed?
What is Undo Management Advisor in Oracle?
How to define an anonymous block?
What is the exact use of Collections?
Explain the use of rows option in imp command.
What are the limitations oracle database 10g xe?
How to experiment a data lock in oracle?
What is oracle join syntax?
Explain the difference between a procedure and a function? What do you understand by those terms?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is a read write transaction in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is transport network substrate (tns) in oracle?