Is it possible to have clustered index on separate drive from original table location?

1036

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

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?

1208

How to rebuild the master database?

1160

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1065

What are the different types of subquery?

1232

Were you involved in any data conversion, which one?

53

How can we solve concurrency problems?

1120

What are the advantages of database?

1009

Have you created fact table and dimension tables?

709

Suppose database is running slow, what will you do?

2590

List the ways in which dynamic sql can be executed?

1083

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

1897

Explain system functions or built-in functions? What are different types of system functions?

1060

please send me oracle pl/sql exp resume. and also faqs...

2567