| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Describe Referential Integrity ? | | 1 |
| after installatio of ORACLE 8i, work properly, but after
restarting the system, it throw an error ORA 01034: ORACLE
not availble | | 1 |
| Please help me how to write a Query to change the primary
key constraint from 1 attribute to another attribute in a
table | | 2 |
| What is meant by recursive hints ? | | 1 |
| What is an Index ? How it is implemented in Oracle Database ? | | 2 |
| Query to get max and second max in oracle in one query ? | Keane-India-Ltd | 20 |
| 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 a data segment ? | | 1 |
| Do View contain Data ? | | 6 |
| what is difference between cartesian join & cross join even
they give same result? | | 2 |
| Difference between primary key and unique key ? | Keane-India-Ltd | 19 |
| Find all employees in Dept “Marketing”. | | 2 |
| In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error | HCL | 2 |
| what is Table ? | | 1 |
| what is primary key? | | 5 |
| What are the factors that affect OPTIMIZER in choosing an
Optimization approach ? | | 1 |
| what is the syntax of DELETE command? | | 6 |
| What is COST-based approach to optimization ? | | 4 |
| what are indexes..how many types of index's are there and
what are they? | TCS | 5 |
| how to use sequence and what use of sequence cache | | 1 |
| |
| 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
