- 1. How can variables be passed to a SQL routine?
- 10. What is a Cartesian product?
- 11. You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic?
- 13. What is tkprof and how is it used?
- 14. What is explain plan and how is it used?
- 15. How do you set the number of lines on a page of output? The width?
- 3. How can you call a PL/SQL procedure from SQL?
- 4. How do you execute a host operating system command from within SQL? Level: Low
- 5. You want to use SQL to build SQL, what is this called and give an example
- 6. What SQLPlus command is used to format output from a select?
