| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to delete all duplicate records from a table using
subquery? | Cap-Gemini | 3 |
| Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3 | | 2 |
| 10)In an RDBMS, the information content of a table does not
depend on the order of the rows and columns. Is this
statement Correct?
A)Yes
B)No
C)Depends on the data being stored
D)Only for 2-dimensional tables | Mind-Tree | 5 |
| What are the uses of Rollback Segment ? | | 2 |
| What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ? | | 1 |
| What is a materialised view? | | 2 |
| What is RULE-based approach to optimization ? | | 1 |
| what is primary key? | | 4 |
| ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ? | | 2 |
| what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots? | | 1 |
| What is the difference between column level constraints and
table level constraints? | IBM | 3 |
| difference between oracle8i and oracle9i | NIIT | 3 |
| how to use sequence and what use of sequence cache | | 1 |
| what is the use of rank function? | | 1 |
| find out the second highest salary? | | 5 |
| What is COST-based approach to optimization ? | | 4 |
| How to create DSN..Explain? | BeBo-Technologies | 1 |
| What is Private Database Link ? | | 1 |
| What is the diff between Oracle and SQL Server | | 1 |
| What is Trace File ? | Thermotech | 4 |
| |
| For more Oracle General Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map