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.
1580Post New Prodapt SQL PLSQL Interview Questions
Can you define cics task?
What is the impact of signed numbers on the memory?
What are the first 100 shortcut keys of ms word ?
What is meant by method chaining?
Why 4-20 amps is being used in instruments? Why cant we use any other range instead of 4-20 amps? Why only 4 amps is taken as lower limit and why 20 amps is taken as the higher limit?
What is biotic potential?
Why shouldn't I use mysql_* functions in php?
What alternate way does HDFS provides to recover data in case a Namenode, without backup, fails and cannot be recovered?
What is semantic elements in html5? List some semantic elements
What do you understand by sstabl in cassandra?
There are also other operators, more linguistic in nature, called __________ that can be applied to fuzzy set theory. a) Hedges b) Lingual Variable c) Fuzz Variable d) None of the mentioned
What is the use of lazy loading in angular 6?
What does the standard journal entry includes?
Why is there more friction when you push an object than when you pull it?
What are Uses While Using the properties of Request instance ?