IBS Software Services Product Support Lead Interview Questions and Answers

Q1. Few linux commands
Add your answer
Q2. Explain few, Any command for example
Ans. 
Some common commands for technical support engineers include ping, ipconfig, and tracert.
• Ping: Used to test the reachability of a host on an IP network.

• Ipconfig: Displays all current TCP/IP network configuration values.

• Tracert: Shows the route that packets take to reach a specified destination.
Answered by AI
Add your answer

Write some simple SQL queries and function,stored procedure

Q1. Difference between ddl and dml
Ans. 
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
• DDL is used to create, modify, and delete database objects like tables, indexes, etc.

• DML is used to insert, update, delete, and retrieve data from tables.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE.

• Examp...read more
Answered by AI
Add your answer
Q2. What is a subquery
Ans. 
A subquery is a query nested within another query in SQL.
• A subquery is enclosed within parentheses and is used to return data that will be used by the main query.

• It can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Answered by AI
Add your answer
Q3. What are you expectations
Add your answer

Q1. About project on overall experience and expertise
Add your answer

Basics test, maths and logical

Q1. Server and basics Linux comands
Add your answer
Q2. Are you good with night shifts
Add your answer