| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is meant by recursive hints ? | | 1 |
| what is primary key? | | 4 |
| What is mean by Program Global Area (PGA) ? | Bajaj | 2 |
| Can a View based on another View ? | | 1 |
| how to truncate date and get only time part 9:20:00 | | 4 |
| What is the difference between Outer join and Full outer join? | | 1 |
| a query to select maxmun 3 salaries of employee table | Polaris | 5 |
| what is Table ? | | 1 |
| what r tyhe major differences between oracle 9i & 10g? | | 2 |
| can u call user defined functions in select statements | | 1 |
| waht is referencial integrity? | Semantic-Space | 2 |
| after installatio of ORACLE 8i, work properly, but after
restarting the system, it throw an error ORA 01034: ORACLE
not availble | | 1 |
| how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as only NN,but not other
alphabets, if NN is thre means i should display , otherwise
leave that blank or empty Its some urgent
requirement ,thanks in advance | | 1 |
| which is the best training centre for learning oracle? | | 3 |
| 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 | 6 |
| What are the type of Synonyms? | | 1 |
| what is foreign key? | | 4 |
| Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table | | 3 |
| When does a Transaction end ? | | 1 |
| when do u go for hash partitioning? | | 1 |
| |
| For more Oracle General Interview Questions Click Here |