Simple sql questions

[indurkar]

Hi Geek,

Could you please answer these simple questions.Thanks.

Questions:-
1. What are triggers and explain their types?

2. How to encrypt a procedure?

3. What is a PL/SQL Table? Explain.

4. Index by table, nested table, varray?

5. What are cursors?

6. Types of cursors.

7. Packages.

8. Oracle supplied packages.

9. What is the difference between procedure and function?

10. If function can return a value, then why use function?

11. What is synonym? Types.

12. String functions?

13. Materialized views?

14. Exceptions and their types.

15. Partitioning and their types?

16. Bulk collect?

17. How to debug a procedure?

18. How to optimize a query? Explain Plan and Indexing.

19. How will you find a pattern in a file in Unix?

20. How to determine the file space usage in Unix?

21. How to find a file in Unix?

22. Analytic functions in SQL.

23. Hints in Oracle.

[debasisdas]

Your question is too much theoritical to explain over here. It is beyond the scope of this discussion to expalin all that here. Please go through some good book for the same. You can easily find all that by little web searching. I'd suggest you have a look around the web for tutorials. You see, we're not really much of a tutorial or "getting started" site. We're more geared toward helping developers who run into bugs in their code.

[prabhu_81]

thanks for ur reference

[HenryBStinson]

All of these questions can be answered straight from the Oracle "Concepts" manual, which you can find online under the Oracle documents.

Look under:
http:// www . oracle.com/technology/documentation/database10gR2 . html

--and find the particular version of Oracle you're dealing with, and download the documentation. You should already have the documentation somewhere on a server on your network.

For example, if you are using Oracle 10G, look here:
http:// www . oracle.com/technology/documentation/database10gR2 . html

and then if you click "View Documentation" (instead of downloading the whole 458 MB file and unzipping that), you can get to this:

http:// download . oracle . com/docs/cd/B19306_01/server.102/b14220 . pdf

which is the Concepts manual, which every Oracle DBA or developer should read.