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 / 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 hide the stored procedure inside a package
How to run create database statement?
What is mean by Program Global Area (PGA) ?
what is the exact definition for pointer?
What is the function of Optimizer ?
What is oracle and what are its different editions?
How do I manually uninstall oracle client?
What types of joins are used in writing subqueries?
if you ctreate table identity
Differentiate between post-database commit and post-form commit?
What is null value in oracle?
Youre getting high busy buffer waits - how can you find whats causing it?