| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can a View based on another View ? | | 1 |
| Explain 1st, 2nd, 3rd normalization form of data base | Thermotech | 2 |
| When can Hash Cluster used ? | | 1 |
| can anyone help me ?
an index has been done on the primary key of a table. an
update operation was performed on that table.
now my question is
1> what abt the performance ? means faster or slower due to
indexing ?
2> does the operation affect to the primary key constraint ?
| Allfon | 2 |
| how to truncate date and get only time part 9:20:00 | | 4 |
| what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots? | | 1 |
| difference between oracle8i and oracle9i | NIIT | 3 |
| who is the father of oracle and send chodd rules | ME | 1 |
| What is COST-based approach to optimization ? | | 4 |
| What is a data segment ? | | 1 |
| Define the terms primary key foreign key and also the
difference between primary and the unique key | | 1 |
| What is STATSPACK tool? | Wipro | 1 |
| various types of joins | | 2 |
| what is pragma? | | 2 |
| what is analyze command ? what kind of statistics does it
generate? | | 1 |
| What is Data Block ? | | 1 |
| 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 |
| What is a cluster? | | 1 |
| what are pseudocolumns? | | 4 |
| what are different types of locks? | | 3 |
| |
| For more Oracle General Interview Questions Click Here |