Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best
2 6734Post New L&T Interview Questions
What are anonymous inner classes?
How do you calculate the rate of return on a stock?
what is the diff. bw separate database testers and manual testers with sql knowledge guys... iam confusing so much ,,in cmpny database testers are not working on manual..? both positions are same are not? explian clesly with example? thank u
What did adobe announce regarding flex?
What is chronic lymphocytic leukemia?
for compensate 315mh inductance ,how many capaciance required?
When should you use an instead of trigger?
Can we override the jspinit(), _jspservice() and jspdestroy() methods?
What is document center?
What is gradle.properties?
How will you get all the values from the dictionary ?
How can you count the total number of records of any table?
How is blockchain distributed database different from traditional databases?
What is the significance of store in redux?
Loop again? Is [loop count]>[max loops]. Count is [loop count]+1, once ran loop count value is what?