Infinite Computer Solutions Interview Questions, Process, and Tips

Q1. Basic SQL based Questions
Add your answer
Q2. Machine Learning RNN LSTM related questions
Add your answer

Q1. What is joins in SQL?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer
Q2. Difference between DROP and TRUNCATE?
Ans. 
DROP deletes the table structure and data, while TRUNCATE deletes only the data.
• DROP removes the table from the database, including all data and structure.

• TRUNCATE removes all data from the table, but keeps the table structure intact.

• DROP is a DDL (Data Definition Language) command, while TRUNCATE is a DML (Data Manipulation Language) command.
Answered by AI
Add your answer
Q3. What is substring in SQL?
Ans. 
Substring in SQL is a function that extracts a portion of a string based on a specified starting position and length.
• Substring function is used to extract a part of a string based on the starting position and length provided.

• Syntax: SUBSTRING(string_expression, start, length)

• Example: SELECT SUBSTRING('Hello World', 1, 5) will return 'Hello'
Answered by AI
Add your answer

Topic:-
Budget in a tip
time:- 20 mins

90 mins
Quantitative(time and work, distance , ratio, percentage)
java
database

Q1. Java Collection framework
Add your answer
Q2. Static Keyword?
Add your answer

Q1. What is MVC Pattern.
Ans. 
MVC is a software design pattern that separates an application into three main components: Model, View, and Controller.
• Model represents the data and business logic of the application.

• View is responsible for displaying the data to the user.

• Controller acts as an intermediary between Model and View, handling user input and updating the Model accordingly.

• MVC helps in achieving separation of concerns, making the code more o...read more
Answered by AI
Add your answer

Q1. Basics of Java and Python, along with Merge sort optimization and Algorithm concepts and some domain knowledge depending on project
Add your answer

Q1. Basic discussion along with salary break down
Add your answer

Q1. What is STP full form ?
Ans. 
STP stands for Spanning Tree Protocol.
• STP is a network protocol used to prevent loops in Ethernet networks.

• It works by creating a loop-free logical topology by blocking redundant paths.

• STP elects a root bridge and calculates the shortest path to it for each network segment.

• It uses Bridge Protocol Data Units (BPDU) to exchange information between switches.

• STP is defined by the IEEE 802.1D standard.
Answered by AI
View 1 more answer
Q2. What is the main function of the Root bridge switch ?
Ans. 
The main function of the Root bridge switch is to control the flow of data traffic in a spanning tree network.
• The Root bridge switch is elected as the central point of the spanning tree network.

• It determines the shortest path for data traffic to reach all other switches in the network.

• The Root bridge switch sends Bridge Protocol Data Units (BPDUs) to other switches to exchange information and maintain the spanning tree...read more
Answered by AI
View 1 more answer
Q3. In which layer the Ip address is working on if it working on L3 so how can we assisgn an Ip address on Layer 2 Switch descibe in the details ?
Ans. 
The IP address works at Layer 3 of the OSI model. Assigning an IP address on a Layer 2 switch is not possible.
• IP addresses are used for network layer communication (Layer 3)

• Layer 2 switches operate at the data link layer (Layer 2)

• Layer 2 switches use MAC addresses for communication within a local network

• IP addresses are assigned to devices connected to Layer 2 switches, not to the switch itself
Answered by AI
Add your answer
Q4. What is the port number of dns and how it's work?
Ans. 
DNS uses port number 53. It works by translating domain names into IP addresses and vice versa.
• DNS stands for Domain Name System.

• Port number 53 is used for both TCP and UDP protocols.

• DNS works by resolving domain names to their corresponding IP addresses.

• It uses a hierarchical distributed database system.

• DNS queries and responses are sent over port 53.

• DNS operates through a client-server model.

• Example: When you type a ...read more
Answered by AI
Add your answer
Q5. What is the dhcp dora process?
Ans. 
DHCP DORA process is the sequence of steps followed by a client to obtain an IP address from a DHCP server.
• DORA stands for Discover, Offer, Request, and Acknowledge.

• Discover: Client broadcasts a DHCP Discover message to find available DHCP servers.

• Offer: DHCP servers respond with DHCP Offer messages containing IP address lease information.

• Request: Client selects one DHCP Offer and sends a DHCP Request message to reques...read more
Answered by AI
Add your answer
Q6. What is the 2G and 3G and 5G service ?
Ans. 
2G, 3G, and 5G are different generations of mobile network technology.
• 2G refers to second-generation mobile network technology, which primarily provided voice and basic data services.

• 3G refers to third-generation mobile network technology, which introduced faster data speeds and enabled mobile internet access.

• 5G refers to fifth-generation mobile network technology, which offers significantly faster data speeds, lower l...read more
Answered by AI
Add your answer
Q7. Did you take a any participation in deployment activtiy if you have so described me about the roles and responsibilities for the deployment team ?
Add your answer
Q8. What is the HTTPS port number ?
Ans. 
The HTTPS port number is 443.
• HTTPS uses port 443 for secure communication.

• It is the default port for secure HTTP connections.

• HTTPS encrypts data using SSL/TLS protocols.

• Examples: https://www.example.com:443 or https://192.168.0.1:443
Answered by AI
Add your answer
Q9. What is the HTTP port number ?
Ans. 
The HTTP port number is 80.
• The default port number for HTTP is 80.

• It is used for communication between web servers and clients.

• Other common port numbers for HTTP include 8080 and 8888.
Answered by AI
Add your answer
Q10. What is the ssh port number and why we used the ssh service ?
Ans. 
SSH port number is 22. SSH service is used for secure remote access and secure file transfer.
• SSH port number is 22 by default

• SSH stands for Secure Shell

• SSH service provides secure remote access to servers

• It encrypts the data transmitted over the network

• SSH service is used for secure file transfer (SFTP) and remote command execution

• It provides authentication and encryption for secure communication
Answered by AI
Add your answer
Q11. What is the OSI model and describe about the each and every layer of that layer function and functionality?
Ans. 
The OSI model is a conceptual framework that standardizes the functions of a communication system into seven layers.
• Layer 1 (Physical): Deals with the physical transmission of data over the network.

• Layer 2 (Data Link): Provides error-free transmission of data frames between nodes on the same network.

• Layer 3 (Network): Handles routing and logical addressing to enable data transfer between different networks.

• Layer 4 (Tra...read more
Answered by AI
Add your answer
Q12. What is the tcp/ip model and why we used this model in current scenario?
Ans. 
The TCP/IP model is a network protocol suite that defines how data is transmitted over the internet.
• The TCP/IP model consists of four layers: Network Interface, Internet, Transport, and Application.

• It is used in the current scenario because it provides a standardized framework for communication between devices on a network.

• The TCP/IP model allows for reliable and efficient data transmission, ensuring that data packets ...read more
Answered by AI
Add your answer
Q13. What is the dtp porotocol ?
Ans. 
DTP (Dynamic Trunking Protocol) is a Cisco proprietary protocol used to negotiate trunking between switches.
• DTP is used to automatically negotiate trunking on a link between Cisco switches.

• It allows switches to dynamically form trunk links without manual configuration.

• DTP operates in three modes: dynamic auto, dynamic desirable, and trunk.

• Dynamic auto mode waits for the other end to initiate trunking.

• Dynamic desirable ...read more
Answered by AI
Add your answer
Q14. Which series you have worked on router device and the vendors?
Ans. 
I have worked on various router devices and vendors.
• Cisco routers (e.g. Cisco 2900 series)

• Juniper routers (e.g. Juniper MX series)

• Huawei routers (e.g. Huawei NE series)

• MikroTik routers (e.g. MikroTik RB series)
Answered by AI
Add your answer