| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Query to get max and second max in oracle in one query ? | Keane-India-Ltd | 20 |
| 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 ? | HDFC | 1 |
|
hai,
I am searching job on Oracle10g and PL/sql,Unix...
can any one send me resume format.
an suggest me how to prepare..
ann books..
| | 1 |
| what is the difference between primary key & foreign key? | Sparsh | 26 |
| what is null value? | Oracle | 7 |
| Can an Integrity Constraint be enforced on a table if some
existing table data does not satisfy the constraint ? | | 2 |
| Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3 | | 2 |
| SELECT * FROM
(SELECT TITLE FROM MOVIE ORDER BY RANK DESC)
WHERE ROWNUM > 4;
when i run the above query .it produces output as NO ROWS
SELECTED.why ?plz any one help me | TCS | 5 |
| what is primary key and foreign key when and where have to use | | 4 |
| What is a heap related to database ? | TCS | 1 |
| what is the exact definition for pointer? | Wipro | 3 |
| What are the Limitations of a CHECK Constraint ? | | 4 |
| What is Database Link ? | | 2 |
| what is the syntax of update command? | Semantic-Space | 1 |
| What is an Integrity Constrains ? | | 1 |
| What are the composite date types in oracle?
| | 2 |
| waht is referencial integrity? | Semantic-Space | 2 |
| what is difference between cartesian join & cross join even
they give same result? | | 2 |
| what is kernel? | Microsoft | 2 |
| What is a materialised view? | | 3 |
| |
| For more Oracle General Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
