Celstream Technologies Interview Questions and Answers

General knowledge and logical mathematics.

Q1. 2 week training with review
Add your answer
Q2. Based on your review task.
Add your answer

Q1. What are oops concepts in java, explain real time scenario
Ans. 
OOPs concepts in Java include inheritance, polymorphism, encapsulation, and abstraction.
• Inheritance allows a subclass to inherit properties and methods from a superclass.

• Polymorphism allows objects to take on multiple forms and behave differently based on their context.

• Encapsulation hides the implementation details of an object and only exposes necessary information.

• Abstraction allows for the creation of abstract class...read more
Answered by AI
View 1 more answer
Q2. Uses of interface, inheritance
Ans. 
Interfaces define contracts for behavior, while inheritance allows for code reuse and polymorphism.
• Interfaces allow for loose coupling and abstraction, enabling multiple implementations of the same behavior.

• Inheritance allows for code reuse and extension of existing classes, reducing code duplication.

• Polymorphism allows objects of different classes to be treated as if they were of the same class, simplifying code and i
Answered by AI
Add your answer
Q3. SQL query for join of tables
Ans. 
SQL query for joining tables
• Use JOIN keyword to combine two or more tables based on a related column

• Specify the columns to be selected using SELECT keyword

• Use ON keyword to specify the condition for joining the tables

• Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
Answered by AI
Add your answer
Q4. Java concepts used in your project
Ans. 
Used Java concepts such as inheritance, polymorphism, and exception handling in my project.
• Implemented inheritance to create a base class and derived classes with specific functionalities.

• Utilized polymorphism to allow objects of different classes to be treated as if they were of the same class.

• Implemented exception handling to handle errors and prevent program crashes.

• Used interfaces to define a set of methods that a ...read more
Answered by AI
Add your answer
Q5. Overloading vs overriding, practical uses
Ans. 
Overloading is having multiple methods with the same name but different parameters. Overriding is having a method in a subclass with the same name and parameters as a method in the superclass.
• Overloading is used to provide different ways to call a method with different parameters

• Overriding is used to provide a specific implementation of a method in a subclass

• Overloading is resolved at compile-time while overriding is r...read more
Answered by AI
Add your answer

Q1. Detailed discussion on the projects worked on
Add your answer

Q1. Technical questions and answers
Add your answer

Q1. Face to face interview
Add your answer

Q1. General HR questions
Add your answer

Questions related to AWS were ask in the test, total question were around 15+ and time given is 30 min-1hour

Q1. Questions related to AWS Services like S3 Lifecycle, CIDR, Public and Private Instance, full form of pem and ppk, what is placement group, what is nat gateway and nat instance
Add your answer
Q2. What is Placement Group
Ans. 
Placement Group is a logical grouping of instances within a single Availability Zone.
• It helps to achieve low-latency network performance by grouping instances in a single rack.

• It is used to deploy a group of instances that need to be in close proximity to each other.

• It is only available for certain instance types and cannot span multiple Availability Zones.
Answered by AI
Add your answer
Q3. What is S3 Lifecycle
Ans. 
S3 Lifecycle is a feature that automates the transition of objects between different storage classes based on their age and usage.
• S3 Lifecycle can be used to automatically move objects from Standard storage class to Infrequent Access (IA) or Glacier storage class based on their age.

• It can also be used to automatically delete objects that have reached the end of their retention period.

• S3 Lifecycle policies can be applie...read more
Answered by AI
Add your answer

Q1. What is java ?
Ans. 
Java is a high-level programming language known for its portability, security, and object-oriented features.
• Java is platform-independent, meaning it can run on any device with a Java Virtual Machine (JVM).

• It is object-oriented, allowing for modular and reusable code.

• Java is known for its security features, such as sandboxing and encryption.

• Popular frameworks and libraries like Spring and Hibernate are commonly used in
Answered by AI
Add your answer
Q2. Opps concepts collections
Add your answer
Q3. Data structures
Add your answer

Q1. Opps and collections
Add your answer
Q2. Must know about collections
Add your answer

Q1. What is different between router and switches?
Ans. 
Routers connect different networks, switches connect devices within a network.
• Routers operate at the network layer and use IP addresses to forward packets between networks.

• Switches operate at the data link layer and use MAC addresses to forward frames within a network.

• Routers can prioritize traffic and perform network address translation (NAT).

• Switches can create virtual LANs (VLANs) to segment a network.

• Example of a r...read more
Answered by AI
Add your answer
Q2. What is different between windows 10 and windows 7
Ans. 
Windows 10 has a more modern interface, better security features, and improved performance compared to Windows 7.
• Windows 10 has a Start menu with live tiles, while Windows 7 has a traditional Start menu.

• Windows 10 has Cortana, a virtual assistant, while Windows 7 does not.

• Windows 10 has better security features such as Windows Hello, biometric authentication, and improved Windows Defender.

• Windows 10 has improved perfor...read more
Answered by AI
Add your answer

Q1. Analytical thinking Attention to details Customer service best practices Knowledge of hardware and networking knowledge of networking troubleshooting
Add your answer