interview questions with answer for cts
No Answer is Posted For this Question
Be the First to Post Answer
How can you Enforce Referential Integrity in snapshots ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What is meant by joins? List out the types of joins.
what is the use of system.effective.date variable in oracle?
Explain what are the different type of segments?
How to create a testing table in oracle?
Write a syntax for update query in oracle?
Is insert autocommit in oracle?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
what is the difference between data migration and production migration.
What is the difference between alert log file and tarce file ?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?