1.How to tune the Sql Query? What are the things you are following?
2.How to Analyze the table? explain with Syntax?
3.What are the types we can analyze the given object explain with syntax?
4.Where we have to see statistics after analysing the Object?
5.What are the frequent errors you are getting in your Product? How you are fixing those?
6.If suppose your junior have written some pkg, How you review that pkg? What are the suggestions you will give to your junior?
7.If suppose, you have more than 20 indexes on table which is having more than 1 lakh records?
Which performance will go down?
8.How to select the Other users data?
9.If suppose in the data base Schemas A,B are there. Schema A is having DBA rights those are
giving to B and if we drop the schema A then schema B is having DBA rights on all objects in that database?
10.If suppose in the data base Schemas A,B,C are there. Schema A is having Emp table. He is giving all rights on Emp table to B and B is giving all rights on Emp table, Whether C Schema can drop the Emp table in A?
11.If suppose in the data base Schemas A,B are there. Schema A is having Emp table. He is giving all rights on Emp table to B and A is deleting records from Emp table at the same time B is truncating the Emp table in A. What will Happen?
12.If suppose in the data base Schemas A,B are there. Schema A is having Emp table. He is giving all rights on Emp table to B and A is deleting records from Emp table based on condition.
after one minute B is Updating same records in the Emp table in A. What will Happen?
13.If suppose in the data base Schemas A,B are there. Schema A is having Emp table. He is giving all rights on Emp table to B. and created one index with 2 columns on Emp table B can add third column for the index which is created by A? What is the right he have to take from A?
14. There are so many Q''s on DCL commands. If I remwmber I will send to you others?
15. What is Locking mechanism? How you are handling those?
16. Logging Vs No Logging.
