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
- 5776 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 |
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What are the type of Synonyms?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
How to convert csv to table in oracle?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What is integrity and what is constraint??Explain with example
Explain coalesce function?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How to retrieve data from an explicit cursor?
What are set operators?
Oracle General 
