|
|
|
|
|
|
|
|
|
Re: re:interview questions on pl/sql [message #84192 is a reply to message #84187] |
Thu, 12 February 2004 03:04 |
Chandu Reddy
Messages: 1 Registered: February 2004
|
Junior Member |
|
|
1) Materialized Views
2) Nested tables and V-Arrays - diff.
3) Pl/Sql Tables.
4) Explicit and Implicit cursors
5) Cursor Attributes
6) Ref Cursors
7) Instead-of Triggers
8) utl_file_directory and its Exception handling
9) Trace file locations -- user_dump_dest and other init.ora settings
10)Pragma Autonomous transaction
11)Uses of Packages and functions
12)Pragma Init Exceptions
13)Bulk Collect and Insert/update/delete
14)DDL/DCL/DML and TCL statements.
15)For Update of Clause
16)Functional Indexes and Composite Indexes
17)Synonyms
18)More Emphasis on Exception handling and Triggers.
19)Global Temperory tables.
20)Trigger and general packages -- diff.
21)Overview of RBO and CBO.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|