Sterna Security Interview Questions and Answers

Java is an object-oriented language while C is a procedural language.

• Java is platform-independent while C is platform-dependent.

• Java has automatic garbage collection while C requires manual memory management.

• Java has built-in support for multithreading while C requires external libraries.

• Java has a larger standard library compared to C.

• Java is more secure than C due to its strong type checking and exception handling.

• C ...read more

Aggregation functions are used to perform calculations on groups of data in a database.

• Aggregation functions include COUNT, SUM, AVG, MAX, and MIN.

• They are used with the GROUP BY clause to group data based on a specific column.

• COUNT function returns the number of rows in a table or the number of non-null values in a column.

• SUM function returns the sum of values in a column.

• AVG function returns the average of values in ...read more

Two ways to write a sentence in mirror image form in Java: reverse string function and array conversion.

• Use the reverse() method of the String class to reverse the sentence

• Convert the sentence to a character array, then swap the first and last characters, second and second-to-last characters, and so on until the middle is reached

• Example: 'Hello World' becomes 'dlroW olleH'

Static is used in public static void main to allow the method to be called without creating an instance of the class.

• Static methods belong to the class and not to any instance of the class.

• The main method is the entry point of a Java program and needs to be called without creating an object of the class.

• The static keyword allows the main method to be called directly from the class, without creating an instance of the c...read more

Abstract classes, interfaces, and enums provide abstraction and modularity in Java.

• Abstract classes provide a partial implementation of a class and cannot be instantiated.

• Interfaces define a set of methods that a class must implement and can be used for multiple inheritance.

• Enums provide a set of named constants.

• All three are used for abstraction and modularity in Java.

• Abstract classes and interfaces are used for polym...read more

Object-oriented software engineering is a framework for designing and developing software using objects.

• Object-oriented software engineering is a methodology for designing and developing software using objects.

• It involves creating classes and objects that encapsulate data and behavior.

• Frameworks are pre-built structures that provide a foundation for building software applications.

• Frameworks can include libraries, APIs,...read more

Java is an object-oriented language with features like inheritance, encapsulation, and polymorphism.

• Inheritance allows classes to inherit properties and methods from other classes.

• Encapsulation hides the implementation details of a class from other classes.

• Polymorphism allows objects to take on multiple forms or behaviors.

• Java also supports abstraction, interfaces, and exception handling.

• Example: class Car extends Vehi...read more

Normalization is a process of organizing data in a database to reduce redundancy and dependency.

• Normalization is used to eliminate data redundancy and improve data integrity.

• It involves dividing a database into two or more tables and defining relationships between them.

• There are different levels of normalization, such as first normal form (1NF), second normal form (2NF), and so on.

• Normalization helps in efficient data ...read more

ADBMS stands for Advanced Database Management System which is an extension of DBMS with additional features.

• ADBMS has advanced features like data mining, data warehousing, and online analytical processing.

• ADBMS is used for handling large and complex data sets.

• DBMS is a basic system for managing data and is used for small and simple data sets.

• DBMS does not have advanced features like ADBMS.

• Examples of ADBMS are Oracle, ...read more

I am a software engineer with 5 years of experience in developing web applications.

• Proficient in programming languages such as Java, Python, and JavaScript

• Experience in developing RESTful APIs and microservices

• Familiarity with front-end technologies such as HTML, CSS, and React

• Strong understanding of database management systems like MySQL and MongoDB

• Experience in Agile development methodologies

I want to gain practical experience and contribute to the industry while also learning on the job.

• I believe that hands-on experience is invaluable in the software engineering field

• I am eager to apply my skills and knowledge to real-world projects

• I am excited to work with a team and learn from experienced professionals

• I am not currently pursuing post-graduation as I feel that gaining industry experience is more importan

I tend to overthink and can be too self-critical at times.

• I often spend too much time analyzing details and can lose sight of the bigger picture.

• I sometimes struggle with making decisions quickly due to overthinking.

• I can be too hard on myself and take criticism too personally.

• For example, in my previous job, I spent too much time perfecting a project and missed the deadline.

• Another example is when I received construct...read more

Launching a new product involves several steps, from ideation to market launch.

• Conduct market research to identify customer needs and preferences

• Develop a product concept and create a prototype

• Test the product with focus groups and make necessary adjustments

• Create a marketing plan and determine pricing strategy

• Launch the product and monitor sales and customer feedback

• Make any necessary improvements or adjustments based...read more

Primary research is original research conducted by the researcher, while secondary research is based on existing research.

• Primary research involves collecting new data through surveys, interviews, experiments, etc.

• Secondary research involves analyzing existing data from sources like books, journals, websites, etc.

• Primary research is more time-consuming and expensive than secondary research.

• Secondary research is useful ...read more

There are approximately 50-60 traffic signals between Aurangabad and Pune.

• Consider the distance between Aurangabad and Pune is around 235 km.

• Assuming an average distance of 4 km between two signals, there would be around 58-59 signals.

• However, the number may vary based on the route taken and the traffic density.

• Also, the number of signals may have increased or decreased over time due to road development projects.

• Hence,...read more

I am a highly motivated individual with a passion for problem-solving and continuous learning.

• I have a degree in computer science and have worked as a software engineer for 3 years.

• I enjoy taking on new challenges and have experience working in both team and individual settings.

• In my free time, I enjoy reading books on technology and attending tech conferences to stay up-to-date with the latest trends.

• I am also an avid...read more

Market research involves gathering and analyzing information about a target market to make informed business decisions.

• Identify research objectives and target audience

• Choose research methods (surveys, focus groups, etc.)

• Collect and analyze data

• Draw conclusions and make recommendations

• Continuously monitor and update research

• Example: Conducting a survey to determine customer satisfaction with a product

• Example: Analyzing ...read more

Intern is a leading company in the tech industry, specializing in software development and digital solutions.

• Specializes in software development and digital solutions

• Known for innovative projects and cutting-edge technology

• Offers internship opportunities for students and recent graduates