Scribd
Upload
9 views2 pages

Oracle MSW

The document contains a comprehensive list of SQL and PL/SQL concepts, including differences between various query types, functions, constraints, and database objects. It also covers advanced topics such as triggers, cursors, collections, and performance tuning. Additionally, it addresses features specific to Oracle 9i and provides insights into SQL execution sequences and predefined packages.

Uploaded by

tahermazerp
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
9 views2 pages

Oracle MSW

The document contains a comprehensive list of SQL and PL/SQL concepts, including differences between various query types, functions, constraints, and database objects. It also covers advanced topics such as triggers, cursors, collections, and performance tuning. Additionally, it addresses features specific to Oracle 9i and provides insights into SQL execution sequences and predefined packages.

Uploaded by

tahermazerp
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

1. Diff Betwn subquery & co-related query?

2. Diff Betwn EXISTS & IN ?


3. Diff Betwn single row functions & group functions?
4. Constraints in SQL ?
5. Diff Betwn primary key, Not Null, composite key, & foreign key ?
6. Column level constraints and table level constraints ?
7. Diff Betwn function & procedure ?
8. Advantages of Packages?
9. concept of over loading in Packages ?
10. what is pl/sql table ? Diff Betwn varray & nested tables ?
11. what are collections in pl/sql ?
12. how can u update a varrays ? give an example ?
13. what is cursor ? Diff types of cursors?
14. what are the cursor attributes ?
15. what is REF cursor ? syntax ? what is bulk collect(Binding) ?
16. what is weak cursor and strong cursor?
17. what is exception and diff types of exceptions?
18. what is pragma? what is raise_appl_error ?
19. Give some pre-defined exceptions?
20. what is view?
21. Diff Betwn simple view & complex view ?
22. what is inline view ?
23. what is TOP-N analysis?
24. what is trigger ?
25. Diff types of triggers with syntax?
26. Compenents of triggers?
27. how many No of triggers we have ?
28. what is mutating trigger, mutating Error & mutating Table ? example ?
29. what is autonomous transaction ?
30. what is execute immediate ?
31. specify some predefined packages in sql?
32. what is diff betwn Where clause & Having clause ?
33. what is the execution sequence of SELECT, FROM, WHERE, GROUPBY,
HAVING & ORDER BY ?
34. what is decode & code ?
35. what is groupby & grouping?
36. Diff btwn UNION & UNION ALL ?
37. set operators in sql ?
38. what is Merge statement in sql ?
39. New features of oracle 9i ?
40. what is partition table with syntax ?
41. what is sequence with syntax & attributes ?
42. what is synonym ? Diff btwn public & private synonym ?
43. what is hint?
44. how can u tune the sql statement ?
45. what is autotrace ?
46. what is tkprof ?
47. where will be the trace file stored ? location?
48. what the trace file contains ?
49. what are external tables in oracle 9i ?
50. what is index ?
51. Diff types of indexes?
52. Advantages of indexes ?
53. what is snapshot ?
54. what is materialized view ?
55. what are invokers rights ? current_user, authorizational_id, .....etc ?

You might also like