What are the ways tablespaces can be managed and how do they
differ?
No Answer is Posted For this Question
Be the First to Post Answer
What is a snapshot log?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
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 ?
What is a trigger and what are its types in oracle?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How to define an explicit cursor in oracle?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
12 RULES OF RDBMS
How to delete a column in an existing table in oracle?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
How many categories of data types?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?