Business Technology Analyst

Schema for a Banks Management System was given and few cases were given and by using the information we need to write the queries and fetch the results. Since there were lot of details and tables and schema i cannot put it here. But you can practice such things on Leetcode.

You have been given a sorted array/list 'arr' consisting of ‘n’ elements. You are also given an integer ‘k’.

Now the array is rotated at some pivot point unknown to you.

For example, if 'arr' = [ 1, 3, 5, 7, 8], then after rotating 'arr' at index 3, the array will be 'arr' = [7, 8, 1, 3, 5].

Now, your task is to find the index at which ‘k’ is present in 'arr'.

Note :

1. If ‘k’ is not present in 'arr', then print -1.
2. There are no duplicate elements present in 'arr'. 
3. 'arr' can be rotated only in the right direction.

Example:

Input: 'arr' = [12, 15, 18, 2, 4] , 'k' = 2

Output: 3

Explanation:
If 'arr' = [12, 15, 18, 2, 4] and 'k' = 2, then the position at which 'k' is present in the array is 3 (0-indexed).

One of the project was based on Amazon Web Services (AWS), about the components i used in my projects like EC2, Virtual Private Cloud, Load Balancers.
Another Project Was Based on Machine Learning so he asked me about Different ML Algorithms.

What is the difference between foreign key and primary key and candidate key?
What is difference between SQL and No - SQL Databases?
What is 1NF , 2NF in DBMS?
Write a Query to find the details of the employee having second largest salary among all employees in the table.
How does "group by" work write a sql Query to support your answer.

What is a data structures?
Give different examples of linear and non linear data structures?
what is a linked list how it is different from arrays?

An organization wants build a mall in West Delhi, they want to know an estimate number of parking space required for four wheelers.

What Do you know About ZS? Why you want to join?