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.
1573Post New Prodapt SQL PLSQL Interview Questions
Can you define big data analytics?
Is there a way to set up a toolbar button in excel to access page setup?
How do you insert a sum formula in word?
Describe the difference between being a manager and a leader and a follower?
what is portmapper,pam and xinetd
Explain what are the database objects? : SQL Server Architecture
What is meant by human security?
Which annotation is used as a substitute of destroy method?
How many data types are supported?
Differentiate between late binding and early binding.
Where do you use sampling procedures?
Have you ever had a problem with your peer? Tell us how you handled it.
what is the importance of CV in the control valves? how it is calculated?
Mention the types of authentications available for sharepoint 2010?
how can i prevent the backfire occurrence in copper shaft furnaces?