How to get a create statement for an existing table?
After update how do u know how many records got updated
What is the difference between substr and instr?
What are transaction isolation levels supported by oracle?
How to import one table back from a dump file?
Give the various rollback segment states.
What is a data lock in oracle?
Explain the use of Merge statement in oracle 11g
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Can you use a commit statement within a database trigger?
Describe Referential Integrity ?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?