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.
1572Post New Prodapt SQL PLSQL Interview Questions
How to use "while" statements in oracle?
Is windows 10 a free upgrade from windows 7?
Explain the tdd in gsm technology?
What is session c#?
What do you know about Regional Rural Banks? How many RRBs are there in the country?
What is abstract class php?
List default packages of laravel 5.6?
redundant connection in contactor?
what are the components has to be done in fpga board (altera)?
Why asp is used?
How do you delay in python?
What is namespace laravel?
What is a caas?
Explain different types of data inputs in splunk?
Design a view in a map such that if the user selects any state, the cities under that state has to show profit and sales?