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
- 5703 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 are the predefined tablespaces in a database?
How to define a record variable to store a table row?
Why does Oracle not permit the use of PCTUSED with indexes?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Is java required for oracle client?
What is the difference between online and offline backups?
Query to retrieve record for a many to many relationship ?
Give the various rollback segment states.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to end the current transaction in oracle?
how to join query for one source type is oracle another source type is sql server ?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the fastest query method to fetch data from the table?
How do you find current date and time in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
