Sofmen interview question

Test: 15 question were there. 4 DSA, 1 SQL Query, 10 basic MCQs(pattern, query,operator conditions etc). DSA: 1: Rotate array right by k. 2. Return non repeating string. 3. Count n of characters occuring in string. s = "aaabbbccccd" output = "3a3b3c1d". SQL. Left Join query. to extract some data. Technical Round 1: Java, Constructor, OOPS, Collection Framework, DSA 1 problem, 1 SQL join query. Technical Round 2: SQL 2 Join questions to extract some data based as they are linked by foreign key, Java OOPS, Collection Framework, 1 DSA problem. CEO round: Mostly question was asked in my project how i developed how the functionalities are working, how my server is handling requests and generating response, how DB is connected. question based on Floyed Warshal Algo. a linkedlist question. HR round: All discussions about work salary etc. Tips: Master DSA, atleast Array, String, LinkedList, Matrix , 1 language and its fundamental, OOPS, most important Databases, Mysql.