How do I call oracle stored procedures that take no parameters?
can you write commit in triggers?
State some uses of redo log files?
When do you get a .pll extension in oracle? Explain its importance
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is the difference between alert log file and trace file ?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What are advantages of dateset in datastage?
What is an Oracle index?
How to check the oracle tns settings?
What is the difference between post-database commit and post-form commit?
How to invoke the data pump import utility?
Are truncate and delete commands same? If so why?