1) Write procedure based upon scenario. 2) Write function to count vowels of a string. 3) Index conceptual questions (data will be inserted faster on table with index or without index table, purpose of indexing) 4) Oracle Data Dictionary questions (oracle supplied packages, tables etc.)