Qualcomm Software Developer interview questions

find the two unique number in array that sums y. (two sum)

1st round- 1-SQL- There is a student table with student id and other params, get alternative ids as output. 2- SQL- There is a Orders table, which has customer_id, order_id and etc. get customer_id who placed maximum orders, if its equal get lexiographically smallest customer_id 3- https://leetcode.com/problems/minimum-add-to-make-parentheses-valid/description/ - same but bracket ‘(’ can be added to ‘)’ to make valid, not vice versa, if not possible return -1 4- Longest common subsequence problem 5- Didnt asked to code for this question, just the logic- https://leetcode.com/problems/course-schedule/description/ 2nd round: 1-Sql indexes and types of indexes, stored procedures, disadvantage of having too many non clustered index. 2-If a table has many unnecessary columns, which is not used for retrieval(like for indexing), but should present in db, how will u change the format. 3-Gave a scenario of data, asked to design tables and relations. Student has multiple phone numbers, and can take multiple subjects 4-Asked to get phone numbers of the student, who took subject as Maths. 5-Asked to create classes and its object for scenario, Directory, each directory has folders, and each folders has files. A folder obj is passed to a function print all the files and subsequent files.