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.
1575Post New Prodapt SQL PLSQL Interview Questions
What do you understand by bootstrap container?
tell us about your qualification?
What is passing by reference in java?
what is mutation testing, Difference between system and End to End testing,Give examples of bug having high priority but low severity except spelling mistakes and logo symbol.
Why python is better?
What is the use of real-time infocube? How do you enter data in real-time infocubes?
What are the Types of object in asp
If a warning lamp will operate with the ground circuit is bypassed with a jumper wire to ground, what should you check?
What is ip multicast?
Name the types of motors used in vacuum cleaners, phonographic appliances, vending machines,refrigerators, rolling mills, lathes, power factor improvement and cranes.
How will you do the 'copy a process chain'
What is null indicator in db2?
what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance
What is persistent lookup cache?
important question on stones