| Other Database Management Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| What are the basic elements of Base configuration of an
oracle Database ? |
| 1 |
| Are Constraints exported through Export command? |
| 1 |
| Can the SNAPSHOTS be refreshed automatically ? |
| 1 |
| What is the use of GRANT option in IMP command ? |
| 1 |
| Oracle precompiler translates the EMBEDDED SQL statemens into ? |
| 1 |
| 1)what is the difference between view and materilized view?
2)what is the difference between delete and truncate?
3)what is the difference between migration and upgration?
4)what is the difference between RMAN HOT BACKUP and normal
hot backup? |
3i-Infotech | 2 |
| Hi how to import oracle sequence in Informatica? Please
write stored procedure code that will import oracle sequence
in Informatica SP transformation as per below scenario
Oracle table product list
Pro_id, pro_name, price
101, LED Lights,200
102, 20 watt CFL Lights, 145
103, 30 watt CFL lights,155
Now a new flat file with new product list needs to be added
to oracle table product list with oracle sequence
flat file product list has two column
pro_name, price
20 watt tube light ,45
30 watt tube light ,60
|
TCS | 1 |
| What are the different file extensions that are created by
Oracle ? |
| 2 |
| what is datapump? Difference between exp and expdp? |
WNS | 2 |
| If I delete a table and then rollback it, do the index on
the table remains?
What if I drop the table and roll back?Do index on the
table remains?
What if I truncate the table and roll back? Do the index on
the table remains |
Wipro | 2 |
| What are the different Sequence of events takes place while
starting a Database ? |
KPSC-Karnataka-Public-Service-Corporation | 1 |
| what is the difference between securityand protection in dbms? |
| 2 |
| |
| For more Database Management Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
