| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is a cartition product? | | 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 |
| Please explain the difference between outer join and inner
join? With examples would be appreciable..! | IBM | 2 |
| What is a Shared SQL pool ? | | 1 |
| can u call user defined functions in select statements | | 2 |
| Can we create more than one index on particular column? | | 1 |
| what is query and types of query
| Reliance | 2 |
| Query to get max and second max in oracle in one query ? | Keane-India-Ltd | 8 |
| what is unique key? | Cap-Gemini | 4 |
| what is foreign key? | | 4 |
| What are the values that can be specified for
OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? | | 1 |
| What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ? | | 1 |
| What is Index Cluster ? | | 1 |
| i have a table and it has constraints and i want to get
"ALTER TABLE table_name
ADD CONSTRAINT constraint_name constraint type" this code
must be in string type
please help me
if you want, i can give more explainings
| | 2 |
| what is primary key? | | 5 |
| After update how do u know how many records got updated | | 3 |
| which sql command we can use to get a print out from
oracle? | iFlex | 2 |
| What is a Synonym ? | | 2 |
| What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ? | | 1 |
| what is RAID technology?which is better RAID 0+1 OR RAID 5? | | 1 |
| |
| For more Oracle General Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
