Friday, April 14, 2017

Genpact PLSQL/SQL Interview Questions

Tell about your experience and your skills.
SQL Loader how it is used.
when External tables are used.
Difference between external tables and SQL loader.
Can i have the same name for a procudure and function? Explain the reason.
What is bitmap index.
is view updatable.
How to make view non updatable.
What are the conditions in which view is not  updatable.
What is materializabe view, In  which scenario will you use materializable view.
What is instead of trigger.
How do you generated 1 to 9 numbers.
I have a table with values in a column from 1 to 9. I want to show all the values from 1 to 9 in a single one column of a row.
There is a name called 'ALEXANDER'. How do u find the count of A in that name.
From the above question find the count of a with out using regular expression.
What is the difference between RANK and DENSE_RANK.
I have  a histroy table , where it will have the history of the rates daily. I want to keep the data for 90 days and from 91 onwards no need to keep in the table. How will you desing a table.
What is the cost in SQL Explain Plan.
What other things you look while checking the SQL plan.
If the plan Cost is low , does that mean the sql query is faster. Explain .

No comments :

Post a Comment