| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is cluster Key ? | | 1 |
| What are the components of Physical database structure of
Oracle Database? | | 1 |
| What is a Public Synonyms ? | | 1 |
| What are the Referential actions supported by FOREIGN KEY
integrity constraint ? | | 1 |
| i must get table name, constraint type, constrain name with
using concads "||" and it must be in string type, then with
join processes i need code
please help immidiately | | 1 |
| 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 |
| What is Public Database Link ? | | 1 |
| how will I find the first 5 highest salaried employees in
each dept in oracle. | IBM | 6 |
| what is view? | Accenture | 6 |
| Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table | | 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 |
| Can we create more than one constraint to column ? | | 1 |
| what is the use of composite key constraint? | | 1 |
| Hi All,
Recently I attended a interview for a developer position in
an educational university. They asked me the a question, I
answered somehow but I was not not satisfied myself. Can
anybody reply for it? The question is:
A business user comes to you directly with an urgent
request:: there is a problem with some students not being
able to re-enrol. It appears that ?something has gone wrong
with the end-dating of some previous courses they had
enrolled in, and this is preventing them from completing
their on-line re-enrolments?. Fortunately the user has done
some analysis on the situation, and has developed some code
to change the end dates. They tell you that they have
tested this code in the ?dev? environment, and it works
fine. They are asking you to please get this implemented in
production as soon as possible.
What steps would you take in response to their request ?
Thanks
| | 1 |
| how do u know the total no of rows in a table? | | 2 |
| How to create DSN..Explain? | BeBo-Technologies | 1 |
| What is mean by Program Global Area (PGA) ? | Bajaj | 2 |
| 9)When information has to be stored w.r.t employees and
their respective departments, which of the following is the
Correct formulation of entries?
A)Employee and department would together be represented as
an entity.
B)This is too less information to decide on entities.
C)An employee would be one entity and a department would be
another.
D)Such a scenario cannot be modelled in RDBMS | Mind-Tree | 2 |
| What is Index Cluster ? | | 1 |
| Explain 1st, 2nd, 3rd normalization form of data base | Thermotech | 2 |
| |
| For more Oracle General Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map