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.
1540Post New Prodapt SQL PLSQL Interview Questions
Explain what is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?
non cash or bank income or expense
What is menu bar in ms excel?
What are the different variables present in linux shell?
What are the steps to send and receive JMS message ?
List some of the database support by hibernate?
Can an sap hana one backup be restored into an on-premise instance of sap hana?
In statistics, what is the common term for the square root of the variance?
What is difference between if and guard in swift?
can we override a native sql query within informatica? How do we do it?
What specific features and functionality do I get with olap services?
Describe laravel service provider?
Explain the process of trasferring an applicant?
how to create a table index in mysql? : Sql dba
Give me a SQL Query to find out the second largest company?