: 1.Tell me about ur self. 2.what are all new things you learned last one year. 3. What is meatrialized view. 4.Diff b/w partition table and index. 5.write function to calculate square root, cube root with two parameter. 6.How to delete dupilicate records. 7.Difficulties faced in your project. 8.indexes 1.joins. 2.Joins scenario question. 3.join trouble shooting in query. 4.how natural join works. 5.Table partition. 6.diff procedure and function. 7.adv of packages. 8.cursor. 9.cursor attributes 10.Exception handling. 11.rxample for predefined exception. 12.Triggers 13.procedurr vs trigger 14 . Indexes 15. Write procedure for 1 to 100 addition 1What is constraints 2.Joins and it’s types 3.How will you debug your code 4.Write a procedure that will give sum of 1-10 numbers 5.tell me about your current project 6.can we use packages on procedures and functions