Can we create database in oracle using command line ?
- 0 Answers
- 843 Views
- MCN Solutions, I also Faced
- E-Mail Answers
How to define an anonymous procedure without variables?
How to create additional tablespaces for an new database?
How to create a single index for multiple columns?
Explain a segment?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
What is tns service name?
How to count groups returned with the group by clause in oracle?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
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 ?
How to end the current transaction in oracle?
Give the different types of rollback segments.
Can we store pictures in the database and if so, how it can be done?
Oracle General 
