Bosch Global Software Technologies IT Service Engineer Interview Questions and Answers

Q1. Couple of questions on joins. Two tables were given and result was asked for different joins.
Add your answer
Q2. Different window functions and analytical functions.
Ans. 
Window functions are used to perform calculations across a set of rows in a table, while analytical functions compute values based on a group of rows.
• Window functions include functions like ROW_NUMBER, RANK, and LAG.

• They are used to calculate running totals, moving averages, and cumulative sums.

• Analytical functions include functions like SUM, AVG, and COUNT.

• They are used to compute aggregate values within a group of ro
Answered by AI
Add your answer
Q3. Create table with foreign keys and primary keys
Ans. 
A table with foreign keys and primary keys is created to establish relationships between tables.
• Foreign keys are used to link a column in one table to the primary key of another table.

• Primary keys uniquely identify each record in a table.

• Foreign keys ensure referential integrity and maintain data consistency.

• Example: Creating a 'Orders' table with a foreign key 'customer_id' referencing the 'Customers' table's primary
Answered by AI
Add your answer
Q4. Get only select few data from table based on requirement given
Add your answer

Q1. Situation vs approach questions. If such and such situation happens, how would you approach it.
Add your answer

Q1. Asked about experience
Add your answer

Q1. SQL, Unix and Javascript.
Add your answer

Q1. Salary discussion
Add your answer

Q1. LDAP - SSO - OAUTH EMAIL INBOUND ACTIONS NOTIFICATIONS IN SERVICENOW WEBSERVICES - REST and SOAP response codes majorly and header and query parameters basic linux commands good to have SQL or javascript...read more
Add your answer

Q1. Difficult scenario faced , why do you want to change company
Add your answer

Customer support related

Profit and loss, numerals, algebra

Q1. Introduction, tell me about yourself, and installations of virtualization and many..
Add your answer