| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are joins..how many types of joins are there? | TCS | 9 |
| What is meant by recursive hints ? | | 1 |
| What is Row Chaining ? | | 1 |
| What are virtual columns? | TCS | 2 |
| What is Hash Index? | | 1 |
| What is the diff between Oracle and SQL Server | | 1 |
| What are the composite date types in oracle?
| | 2 |
| how many triggers we can create on a table | TCS | 3 |
| What is a Data Segment ? | | 2 |
| after installatio of ORACLE 8i, work properly, but after
restarting the system, it throw an error ORA 01034: ORACLE
not availble | | 1 |
| What are the uses of Rollback Segment ? | | 2 |
| What is a materialised view? | | 2 |
| Differnce between view and index | | 1 |
| Difference between sub query and nested query ? | Keane-India-Ltd | 5 |
| What is the difference between column level constraints and
table level constraints? | IBM | 3 |
| can a table has a column that has only view data and in
other columns we can change data? | Secon | 1 |
| what is the syntax of SELECT command? | | 5 |
| what is the use of ondelete cascade? | | 1 |
| consider some table with 4 r 5 columns in that 1 col is
DATE type. The data is like that,For each date in that col
some 3 fields r there but all the records r having
different data. Now i want to display all the columns by
performing grouping on the date field ( as SELECTION
Operator(*) cannot be used with group function having only
one "group by clause". how to do this? can any one help me
in finding out the solution plss? | | 1 |
| What is the maximum number of CHECK constraints that can be
defined on a column ? | | 3 |
| |
| For more Oracle General Interview Questions Click Here |
Site Map
