What are the properties of the transaction?

1069

Why should you use or avoid select * statements?

1108

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1210

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

How to Change a users password from unix shell.

1214

How can I check that whether automatic statistic update is enabled or not?

1110

Can delete statement be rollbacked?

1053

If a cursor is open, how can we find in a pl/sql block?

1235

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

What is normalization and what are the advantages of it?

1054

How do I remove duplicates in two columns?

1180

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1954

What are the types of database explain each of them briefly?

1057

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2211

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1984