Tata Consultancy Services Assistant System Engineer interview questions

1) Tell me about your self 2) What is your two favourite subjects 3) What is DDL, DML, TCL, DCL 4) Why select query put in DML 5) What is index 6) Type of index 7) Explain type of indexes 8) How index work in background 9) Query for finding 5 largest salary 10) What is Cloud computing 11) What is AWS 12) Platform provided by AWS 13) What is Saas, Paas, Iaas 14) What is Salesforce 15) What is CRM 16) How to identify performance of queries 17) Analysis of Database 18) Debugging in Database 19) You have 10 query how can you find which query run fastest 20) puzzle - There are 10 black socks and 10 white socks in a drawer. Now you have to go out wearing your shoes. So how many maximum number of times you need to remove the sock from drawer so that you can go out? You can remove only 1 sock at a time. 21) Are you willing to reallocate 22) Do you have any backlog 23) Why logo of TCS is blue 24) Tell me about new technology 25) 1 question for new technology 26) Do you have any question