prodapt placement paper - sql, plsql

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of air in gc

1431


Sks Microfinance

976


What were the occupations of the people who lived within the Mauryan Empire?

578


what you will do when you struck in traffic ?

1044


Hi.. Guys Im pranitha, presently im working in a organisation & im look for job at MNC's like DELL, Delloitte, Bank of America, Genpect, etc., I have completed B.com . Pls help me...

1141






why didn't get placed so far?

1188


i want the sample placement paper of goldman sachs urgently. please send it to me

3922


Do we have vacancy for HR RECRUITER ?

1376


What are the frequently asked questions for interview in capital iq company ?

1317


speak 1min on topic Travelling,memorable moment ,memorable day?

1736


printf("%d",printf("%d",printf("%d",printf("%s","ILOVECPROGRAM")))); whats the output

1393


what is bidirectional?

1385


Zero setting of sejong rottary press

1194


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

1187


Recently conducted Apptitude test

1408