prodapt placement paper - sql, plsql



prodapt placement paper - sql, plsql..

Answer / palanivel

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling

Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Placement Papers Interview Questions

my question is : reverse a string in COBOL program (please write a code asap) input file: 1234abcdef output file: 8765_____ abc*$#1___ 1_2_3_4__ cdef____ghi h_k_z_a__ a_z_k_h___ ihg____ghi 4_3_2_1___ 1#$*cba__ ______5678 fedcb4321

0 Answers  


candidates experience....accenture 18 aug 07 landran

10 Answers   Accenture,


job seeking . .

1 Answers   BPCL Bharat Petroleum,


Hellosoft placement papers --------- placement paper 1

2 Answers   Hellosoft,


HCL placement papers ---------placement paper 2

3 Answers   HCL,






Consagous Technologies Selection Process

1 Answers   Consagous,


Accenture Placements with Freshers Campus June 30 2007

3 Answers   Accenture,


IBM PAPER - 29 JUL 2006

2 Answers   IBM,


IBM [Kolkata Placement Paper] : : My Personal Experience [2007 March 17]

1 Answers   CTS, IBM, Ontrack,


InterGraph Placement Papers ------ Intergraph placement Paper 2

1 Answers   InterGraph,


what is the use of air in gc

0 Answers  


what you will do when you struck in traffic ?

0 Answers   Genpact,


Categories