1) Write procedure based upon scenario. 2) Write function to count vowels of a string. 3) Index conceptual questions (data will be inserted faster on table with index or without index table, purpose of indexing) 4) Oracle Data Dictionary questions (oracle supplied packages, tables etc.)
sql queries joins indexes views
Introduction SSIS transformation Difference between union all and merge Difference between conditional split and multicast Scenario based questions Query to delete duplicate records
what are M views. How do you refresh them
Are you looking for a change? We can help you find a job within a week. We work directly with IT Giants in US and we have a very good and dedicated marketing team. maximum it would take 10-15 days for us to find a job for you.
time and distance
Explain DR strategy for SQL Server
They will ask you about random pl/sql queries and simple question like group by, having clause and indexing etc.
Ask several sql concepts
Q: In case a query is slow sometimes, but quick other times, what is the reason?
Viewing 1551 - 1560 interview questions