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
- 4908 Views
- HDFC, I also Faced
- E-Mail Answers
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
What is columnar storage what is the advantage?
What is a nvl function?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How to call a sub procedure?
What is parameterized cursor in oracle?
What is a tns service name?
Whether any commands are used for months calculation? If so, what are they?
what is port in oracle? how is it related to database application.
How to define an oracle cursor variable?
Where do we use decode and case statements?
How to login to the server without an instance?
Explain oracle data types with examples?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is a system tablespace and when it is created?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
