| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a Temporary Segment ? | | 1 |
| Can a property clause itself be based on a property
clause ? | Oracle | 1 |
| What are the advantages of Views ? | | 1 |
| what are views? | TCS | 5 |
| Can we create more than one index on particular column? | | 1 |
| What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ? | | 1 |
| What is a heap related to database ? | TCS | 1 |
| What is the difference between Outer join and Full outer join? | | 1 |
| what diffrence between function and procedure? | | 3 |
| What is a Segment ? | | 1 |
| a query to select maxmun 3 salaries of employee table | Polaris | 5 |
| What is an Extent ? | | 2 |
| Difference between sub query and nested query ? | Keane-India-Ltd | 5 |
| Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer:select length(trim('ram charan singh')) - length
(replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
The above query working properly when space between the
words is only one &similar
But ,If the space between the words is nonuniform.
Ex:'ram charan singh is good' ans:5
i am not getting this answer using above query. | | 1 |
| What is Row Chaining ? | | 1 |
| what are the differen between key flexifild and discriptive
fiexifild. | | 1 |
| Can Multiple instances be run on Single Machine??? | | 2 |
| What are the different type of Segments ? | | 1 |
| Can anyone give me information about oracle certification | | 1 |
| Is primary key = unique key,not null?
If yes,please explain
IF No,please explain | | 3 |
| |
| For more Oracle General Interview Questions Click Here |