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.
1579Post New Prodapt SQL PLSQL Interview Questions
What are IP Tunnels?
When thomas edison was promoting the wide use of direct current, this personal enemy of edisons was the chief proponent and expert in alternating current?
what is flashing?
how to genernate 21 sencondary index
What is @componentscan in spring boot? : Spring Boot
Where is layout in powerpoint?
What are the output types and Tcodes ?
What does ctrl f2 do in excel?
How to generate it on homestead?
Does html5 work on internet explorer?
Can extension methods access private members?
Which organizational element is central in shipping?
how to prepare the balance sheet of private ltd. company & what roll should be play by Income tax, compnay law & accounting standard in India & world.
Can you explain apache ambari?
What are “strong” and “weak” references? Why are they important and how can they be used to help control memory management and avoid memory leaks?