| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ... | Verizon | 6 |
| what is the bitmap index? | | 1 |
| How many different types of indexes we have in oracle? | | 2 |
| what is the difference between primary key & foreign key? | Sparsh | 15 |
| What is a heap related to database ? | TCS | 1 |
| why pl sql doesn't support retrieving multiple records | Mphasis | 1 |
| What is STATSPACK tool? | Wipro | 1 |
| What is a materialised view? | | 2 |
| How can we manage the gap in a primary key column created
by a sequence?
Ex:a company has empno as primary key generated by a
sequence and some employees leaves in between.What is the
best way to manage this gap? | Infosys | 1 |
| Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table | | 3 |
| What is an Integrity Constrains ? | | 1 |
| What is an Index Segment ? | | 1 |
| HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET? | | 1 |
| what is the syntax of SELECT command? | | 5 |
| SELECT * FROM
(SELECT TITLE FROM MOVIE ORDER BY RANK DESC)
WHERE ROWNUM > 4;
when i run the above query .it produces output as NO ROWS
SELECTED.why ?plz any one help me | TCS | 5 |
| Can we create index on views? | | 5 |
| Can objects of the same Schema reside in different tablespaces.? | | 1 |
| 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 |
| can a view be updated? | | 1 |
| What are the different type of Segments ? | | 1 |
| |
| For more Oracle General Interview Questions Click Here |