For web applications from which version of Oracle is suitable?1 3286
What are the main diff. between oracle 7.3 and oracle 8i?1 3123
How to call DDL statements from pl/sql?4 27047
How to maintain the history of code changes of pl/sql?2 10043
what are Dynamic SQL statements?9 16617
What is pl/sql and what is it used for?4 10961
what is constraining table?2 9685
How pl/sql source code can be protected?2 7395
What can be a size of a pl/sql block? Is there any limit?2 9148
How do you Implement SSIS Packages in your Project?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: firstname.lastname@example.org
can we delete autodiff back up that we have set through sql server agent.
What is a private synonym?
what is semphore explian it?
Explain the Normalized Relations?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
did u received a single file or multiple files
What is a Built_in subprogram ?
which backup strategy you are following at ur company
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
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?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
I have a few records all are same structures data, I want to store data in multiple targets how