1500+ Johnson Controls Interview Questions and Answers

The .NET Framework is a traditional framework for Windows applications, while .NET Core is a cross-platform, open-source framework.

• The .NET Framework is primarily for Windows applications, while .NET Core is cross-platform and can run on Windows, macOS, and Linux.

• The .NET Framework is closed-source, while .NET Core is open-source.

• The .NET Framework is not modular, while .NET Core is modular and allows developers to include only the necessary components in their applications.

• T...read more

YOLO (You Only Look Once) algorithm is a real-time object detection system that processes images in a single pass.

• YOLO divides the image into a grid and predicts bounding boxes and probabilities for each grid cell.

• It uses a single neural network to predict multiple bounding boxes and class probabilities simultaneously.

• YOLO is known for its speed and accuracy in object detection tasks.

• Example: YOLO can detect objects like cars, people, and animals in images or videos.

HSIT stands for Hardware and Software Integration Testing.

• HSIT is a type of testing that verifies the compatibility and functionality of hardware and software components.

• It is usually performed after unit testing and before system testing.

• HSIT can help identify any issues with the integration of hardware and software, such as driver conflicts or compatibility issues.

• Examples of HSIT include testing the compatibility of a new graphics card with existing software or testing the...read more

MC/DC stands for Modified Condition/Decision Coverage, a testing technique used to ensure that each condition in a decision statement is tested independently.

• MC/DC is a type of coverage criteria used in software testing.

• It ensures that each condition in a decision statement is tested independently.

• It requires that each condition be shown to independently affect the outcome of the decision.

• MC/DC is commonly used in safety-critical systems such as aviation and medical devices.

• A...read more

Singleton class is a class that can only have one instance at a time.

• It is used to ensure that there is only one instance of a class in the system.

• It is often used in situations where a single object needs to coordinate actions across the system.

• Example: Database connection class, logger class, configuration class.

• It can be implemented using private constructors, static methods, and static variables.

Android AIDL Communication is a mechanism for inter-process communication between Android components.

• AIDL stands for Android Interface Definition Language

• It allows different Android components to communicate with each other across different processes

• AIDL files define the interface that the client and server components will use to communicate

• AIDL is commonly used for communication between activities, services, and content providers

Polymorphism in programming refers to the ability of a single function or method to operate on different types of data.

• Compile-time polymorphism (static binding): achieved using function overloading and operator overloading

• Run-time polymorphism (dynamic binding): achieved using function overriding and virtual functions

• Ad-hoc polymorphism: achieved using templates or generics

• Parametric polymorphism: achieved using inheritance and interfaces

Components in electric vehicle include battery, motor, controller, charger, and regenerative braking system.

• Battery: stores energy to power the motor

• Motor: converts electrical energy into mechanical energy to propel the vehicle

• Controller: manages the flow of electricity between the battery and motor

• Charger: recharges the battery when plugged into an external power source

• Regenerative braking system: converts kinetic energy into electrical energy to recharge the battery

Retest refers to the process of testing again to ensure that the previous test results were accurate.

• Retesting is done to confirm the accuracy of previous test results.

• It is often done when the initial test results were inconclusive or questionable.

• Retesting can also be done as part of quality control measures.

• Examples of retesting include blood tests, software testing, and product quality testing.

Lists and dictionaries are data structures used in programming to store collections of items.

• Lists are ordered collections of items that can be accessed by index. Example: [1, 2, 3, 4]

• Dictionaries are unordered collections of key-value pairs. Example: {'name': 'John', 'age': 30}

Enhancement framework is a tool to modify standard SAP applications without changing the original code.

• Enhancement framework provides a way to add custom code to standard SAP applications.

• Customer exits are predefined hooks in the standard code that allow custom code to be added.

• Badis are similar to customer exits but provide more flexibility and can be implemented multiple times.

• Enhancement framework is used to avoid modifying standard code and to make upgrades easier.

• Exampl...read more

Java find eligible is a method used to filter elements in a collection based on certain criteria.

• Java find eligible is typically used with streams and lambda expressions.

• It can be used to filter out elements that meet a specific condition.

• For example, finding all employees eligible for a bonus based on their performance ratings.

Cascade is a technique used in engineering to control multiple processes or systems in a sequential manner.

• Cascade is used to ensure that the output of one system becomes the input of another system.

• It helps in achieving better control and coordination between interconnected systems.

• Cascade control is commonly used in industries like chemical processing, power generation, and water treatment.

• An example of cascade control is in a heating system where the temperature of the wat...read more

Code to build a pyramid in Java using nested loops

• Use nested loops to print spaces and stars in each row

• Increment the number of stars and decrease the number of spaces in each row

• Handle the pyramid height dynamically

The annotation used to display text element in CDS is @Semantics.text

• The @Semantics.text annotation is used to display text elements in CDS views

• It is used in combination with the element name and the label for the text

• Example: @Semantics.text.label: 'Product Description';

• The label can be customized to display any desired text

Express is a popular Node.js web application framework.

• It provides a robust set of features for web and mobile applications.

• It allows for easy routing and middleware creation.

• It supports various templating engines and database integrations.

• It has a large community and extensive documentation.

• Example: const express = require('express'); const app = express();

Answers to various questions related to Scrum framework and Agile methodology.

• Velocity trend is the rate at which the team is delivering the product increment.

• Metrics used in Scrum framework include burndown chart, velocity, sprint goal, etc.

• Types of conflicts in Scrum are personal, technical, and domain-related. They can be resolved through communication, negotiation, and compromise.

• INVEST model is used for creating user stories that are Independent, Negotiable, Valuable, Es...read more

Handling models involves understanding their structure, making necessary modifications, and ensuring they are properly integrated into the system.

• Understand the model's purpose and requirements

• Modify the model as needed based on feedback or changes in requirements

• Integrate the model into the system and test its functionality

• Document the model's design and implementation for future reference

HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on their keys.

• HashMap internally uses an array to store the key-value pairs.

• When a key-value pair is added, the key is hashed to determine its index in the array.

• If multiple keys hash to the same index, a linked list or a balanced tree is used to handle collisions.

• To retrieve a value, the key is hashed again to find its index and then the linked list or tree is traver...read more

A LinkedList is a data structure where each element points to the next element in the sequence.

• LinkedList is a linear data structure.

• Each element in a LinkedList is called a node.

• Nodes in a LinkedList are connected through pointers or references.

• LinkedList can be singly linked (each node points to the next node) or doubly linked (each node points to the next and previous nodes).

• Examples: Singly LinkedList: 1 -> 2 -> 3 -> 4, Doubly LinkedList: 1 <-> 2 <-> 3 <-> 4

I have a Bachelor's degree in Computer Science and 5 years of experience in system engineering.

• Bachelor's degree in Computer Science

• 5 years of experience in system engineering

• Experience with network design and implementation

• Proficient in programming languages such as Java and Python

• Familiarity with cloud computing platforms like AWS and Azure

Remove duplicate data in pivot table

• Identify the duplicate data in the pivot table

• Delete or filter out the duplicate data

• Refresh the pivot table to reflect the changes

• Use conditional formatting to highlight duplicate data

• Merge the duplicate data if necessary

The method called in backend to handle deep entity call is GET_DEEP_ENTITY.

• GET_DEEP_ENTITY method is used to retrieve a deep entity from the backend system.

• It is used to retrieve a single entity with its related entities in one request.

• It is called when a deep entity is requested in OData service.

• It is used to retrieve data from multiple tables in one request.

Table function in CDS is a reusable database function that can be used to define complex logic and calculations.

• Table function is defined in CDS (Core Data Services) using the @EndUserFunction annotation.

• It allows you to define complex logic and calculations that can be used in CDS views or ABAP programs.

• Table functions can have input parameters and return a table of data as the result.

• They can be used to perform data transformations, aggregations, filtering, and more.

• A pract...read more

Abstract class is a class that cannot be instantiated. Interface is a collection of abstract methods.

• Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.

• Abstract class can have instance variables, while interface cannot.

• A class can implement multiple interfaces, but can only inherit from one abstract class.

• Example of abstract class: Animal (cannot be instantiated). Example of interface: Runnable (collection of abstrac...read more

Delta merge is a process in data management where changes are merged into a target dataset incrementally.

• Delta merge is used in data warehouses and databases to efficiently update large datasets.

• It involves identifying the changes (deltas) between the source and target datasets and applying them to the target.

• Delta merge helps in reducing the time and resources required for updating datasets compared to full rewrites.

• Example: In a data warehouse, new sales data is merged into...read more

Questions related to cucumber, defects found, functional and automation testing tools.

• Cucumber is a BDD tool used for testing

• Found defects related to UI, functionality, and performance

• Functional testing involves testing the application's features and functionality

• Worked on automation tools like Selenium, Appium, and TestNG

• Used automation tools to create test scripts and execute them

• Integrated automation scripts with CI/CD pipeline for continuous testing

Docker is a platform for developing, shipping, and running applications in containers. k8s is a container orchestration tool.

• Docker allows developers to package their applications and dependencies into a container, which can be easily deployed on any platform.

• k8s (Kubernetes) is a tool for managing and orchestrating containers at scale, providing features like automatic scaling, load balancing, and self-healing.

• Docker and k8s are often used together to create a complete conta...read more

Partner profile in Idocs is used to define communication partners and their settings.

• Partner profile contains information about the communication partner such as their ID, address, and communication protocol

• Partner profile is used to determine the outbound and inbound processing of Idocs

• To create a custom Idoc, define the segments and fields using WE31 transaction

• Create a message type using WE81 transaction and link it to the Idoc type

• Create a process code using WE42 transact...read more

JVM is the Java Virtual Machine that executes Java bytecode, JRE is the Java Runtime Environment that includes JVM and libraries, JDK is the Java Development Kit that includes JRE and development tools.

• JVM is the virtual machine that runs Java bytecode and provides a runtime environment for Java programs.

• JRE includes JVM along with libraries and other components necessary to run Java applications.

• JDK is a development kit that includes JRE and development tools like compilers ...read more

SQL query to find the 2nd largest value in a table

• Use the ORDER BY clause to sort the values in descending order

• Use the LIMIT clause to retrieve the second row

Indexes in SQL server improve query performance by reducing the number of data pages that need to be scanned.

• Indexes are created on one or more columns of a table.

• They can be clustered or non-clustered.

• Clustered indexes determine the physical order of data in a table.

• Non-clustered indexes create a separate structure that includes the indexed columns and a pointer to the data.

• Indexes should be used judiciously as they can slow down data modification operations.

• Indexes can be c...read more

Explanation of REST API, Spring Boot controller annotation, and Spring MVC project flow.

• REST API is a web service that uses HTTP requests to GET, POST, PUT, and DELETE data.

• To achieve it, we need to define endpoints, HTTP methods, and data formats.

• In Spring Boot, we use the @RestController annotation to create a controller.

• The @RequestMapping annotation is used to map HTTP requests to methods.

• The flow of creating a Spring MVC project involves defining a model, view, and contr...read more

I am currently working on SAP ECC 6.0 and SAP S/4HANA systems.

• Working on implementation and support projects for SAP MM module

• Configuring and customizing SAP MM functionalities

• Creating and maintaining master data for materials, vendors, and purchasing info records

• Performing testing and resolving issues during system upgrades and enhancements

A hobby is an activity done for pleasure in one's leisure time, often pursued for relaxation or enjoyment.

• Hobbies can include activities such as painting, gardening, playing musical instruments, cooking, hiking, etc.

• They are not done for monetary gain but for personal satisfaction and enjoyment.

• Hobbies can help reduce stress, improve mental well-being, and provide a sense of accomplishment.

• Some people turn their hobbies into professions or side businesses.

• Hobbies can also be ...read more

Strength is the ability to overcome challenges, both physical and mental, with resilience and determination.

• Physical strength involves muscle power and endurance, allowing one to lift heavy objects or perform physically demanding tasks.

• Mental strength involves emotional resilience, the ability to stay focused and positive in the face of adversity.

• Strength can also refer to inner strength, the ability to stay true to one's values and beliefs even in difficult situations.

Explaining the use of NULL indicator and VSAM file in Mainframe development and resolving SOC7 abend.

• NULL indicator is used to indicate the absence of data in a field

• VSAM file is used to store and retrieve data in a program

• SOC7 abend occurs due to invalid numeric data and can be resolved by identifying and correcting the error

• NULL indicator can be checked using IF statement or COBOL verb SET

• VSAM file can be accessed using COBOL verbs like READ, WRITE, START, etc.

Questions related to accounting principles and responsibilities for Senior Associate position.

• Golden rule is to treat others as you would like to be treated.

• Deferred revenue is revenue received in advance but not yet earned. Journal entry is to credit revenue and debit deferred revenue account.

• Depreciation is the decrease in value of an asset over time. Entry is to debit depreciation expense and credit accumulated depreciation account.

• Prepaid expenses are expenses paid in adv...read more

PL/SQL program to print numbers in descending order from 103 to 3

• Use a loop to iterate from 103 to 3

• Print each number in the loop

• Decrement the loop counter by 3 in each iteration

A mutating table or mutating trigger occurs when a trigger tries to update a table that is currently being modified.

• Mutating table occurs when a trigger references the table that is being modified.

• It can happen when a trigger is fired by an INSERT, UPDATE, or DELETE statement on the table.

• This can lead to unpredictable results or errors, such as ORA-04091: table is mutating, trigger/function may not see it.

• To avoid mutating table errors, use row-level triggers instead of stat...read more

To load data from a tab delimiter file instead of csv, change the delimiter setting in the data loading process.

• Change the delimiter setting in the data loading process to ' ' for tab delimiter

• Specify the delimiter parameter as ' ' when using functions like read_csv in Python pandas library

• Ensure that the file is saved with tab delimiters before attempting to load it

Yes, it is allowed to write NO DATA FOUND after WHEN OTHERS in PL/SQL block.

• It is allowed to handle exceptions using WHEN OTHERS in PL/SQL block.

• You can customize the error message to display 'NO DATA FOUND' after handling the exception.

• It is a good practice to provide informative error messages for better debugging.

Azure services are cloud computing services provided by Microsoft for building, testing, deploying, and managing applications and services.

• Azure Virtual Machines - allows users to create and manage virtual machines in the cloud

• Azure App Service - a platform-as-a-service offering for building, deploying, and scaling web apps and APIs

• Azure SQL Database - a fully managed relational database service

• Azure Blob Storage - a scalable object storage service for large amounts of unstru...read more

Truncate removes data from the end of a string or file, while delete removes data from the middle of a string or file.

• Truncate removes data from the end of a string or file, while delete removes data from the middle.

• Truncate operation is irreversible, while delete operation can be undone.

• Example: Truncating a file to reduce its size, deleting a specific character from a string.

Achieving concurrency involves executing multiple tasks simultaneously to improve system performance.

• Use multithreading or multiprocessing to run tasks concurrently

• Implement synchronization mechanisms to prevent race conditions

• Utilize parallel processing for tasks that can be divided into independent subtasks

The script is a bash script that automates the process of backing up files to a remote server.

• Uses rsync command to sync files from local machine to remote server

• Includes variables for source and destination directories

• Uses SSH key authentication for secure connection

Explaining the difference between Roles & Profiles, Workflow-ProcessBuilder-Flow, types of Workflow, and Trigger context variables.

• Roles define the level of access a user has to records in an organization, while profiles define the level of access a user has to objects and fields.

• Workflow, Process Builder, and Flow are automation tools used to automate business processes in Salesforce.

• Workflow rules are used to automate standard internal procedures and processes to save time ...read more

Cut a cake into 8 pieces with 3 cuts.

• Make two perpendicular cuts through the center of the cake, dividing it into quarters.

• Make a third cut horizontally through the middle of the cake, dividing each quarter into two pieces.

• Each quarter will now be divided into two pieces, resulting in 8 total pieces.

Oops concepts are the fundamental concepts of Java programming language.

• Encapsulation - wrapping data and code together in a single unit

• Inheritance - creating a new class from an existing class

• Polymorphism - ability of an object to take many forms

• Abstraction - hiding implementation details and showing only functionality

• Example: A car is an object that encapsulates data like speed, color, and code like start, stop, and accelerate

• Example: A child class can inherit properties an...read more

A procedure is a set of instructions that performs a specific task, while a function is a procedure that returns a value.

• Procedures are used to perform actions, while functions are used to calculate and return values.

• Procedures do not have a return statement, while functions always have a return statement.

• Functions can be called within expressions, while procedures cannot.

• Procedures can have input parameters, while functions can have both input parameters and a return value.

Java elements in Selenium can be found using various methods like findElement, findElements, etc.

• Use findElement method to locate a single element in the DOM

• Use findElements method to locate multiple elements in the DOM

• Locate elements by ID, class name, name, tag name, xpath, css selector, etc.

List is mutable, tuple is immutable in Python.

• List can be modified, tuple cannot be modified

• List uses square brackets [], tuple uses parentheses ()

• List is slower than tuple for iteration and indexing

• List is used for homogeneous elements, tuple for heterogeneous elements

Cascade and joins are used in database management to establish relationships between tables and retrieve data efficiently.

• Cascade is used to automatically perform a certain action on related records when a primary record is modified or deleted.

• Joins are used to combine rows from two or more tables based on a related column between them.

• Types of joins include inner join, outer join, left join, and right join.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2...read more

List is mutable, tuple is immutable in Python.

• List can be modified, tuple cannot be modified

• List uses square brackets [], tuple uses parentheses ()

• List is used for collections of items that may change, tuple is used for fixed collections

Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.

• OOP is based on the concept of classes and objects.

• It focuses on encapsulation, inheritance, and polymorphism.

• Encapsulation hides the internal details of an object and provides a public interface.

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

• Polymorphism allows objects of different classes to be treated as objects of a common super...read more

Answers to interview questions for a Python developer.

• 1. Tuples are immutable while lists are mutable.

• 2. Decorators are functions that modify the behavior of other functions.

• 3. 'to' object is not a standard term in Python, so it's unclear.

• 4. Pass does nothing, break exits the loop, and continue skips to the next iteration.

• 5. Need the given program to identify the error.

• 6. Explain your projects in detail, highlighting your role and achievements.

Delete removes specific rows from a table, truncate removes all rows, and drop removes the entire table.

• Delete is a DML operation, while truncate and drop are DDL operations.

• Delete is slower as it logs individual row deletions, while truncate and drop are faster.

• Delete can be rolled back, while truncate and drop cannot be rolled back.

• Delete can have conditions to specify which rows to delete, while truncate and drop affect the entire table.

• Example: DELETE FROM table_name WHER...read more

Transfer milk between containers to get 4l in 5l container using 3l container twice.

• Use 3l container to fill 5l container with 1l milk

• Empty 5l container and put 1l milk in it

• Use 3l container to fill 5l container with 3l milk

• Total milk in 5l container is now 4l

To find if two tables have similar data, compare the records in both tables using a join or a subquery.

• Use a join operation to compare the records in both tables based on a common column.

• If the tables have a primary key, you can join them on that key to check for similar data.

• Alternatively, you can use a subquery to compare the data in both tables and check for matching records.

• Consider using the MINUS operator to find the differences between the two tables.

• You can also use t...read more

The candidate is asked to write SQL queries.

• Provide the necessary table schema and data for reference.

• Ask for clarification on the specific requirements of the queries.

• Consider the performance and optimization of the queries.

• Use appropriate SQL functions and operators to achieve the desired results.

• Test the queries against the given data to ensure correctness.

Types of sorting algorithms include bubble sort, selection sort, insertion sort, merge sort, quick sort, and heap sort.

• Bubble sort - repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order

• Selection sort - repeatedly finds the minimum element from the unsorted part and swaps it with the first unsorted element

• Insertion sort - builds the final sorted array one item at a time by inserting each element into its correct position

• M...read more

Java does not support multiple inheritance. It uses interfaces to achieve similar functionality.

• Java supports single inheritance, where a class can only inherit from one superclass.

• To achieve multiple inheritance-like behavior, Java uses interfaces.

• Interfaces allow a class to implement multiple interfaces, providing access to multiple sets of methods and constants.

• Unlike classes, interfaces cannot be instantiated and can only be implemented by classes.

• Example: class A impleme...read more

Joins in Oracle and how outer join works

• Joins are used to combine data from two or more tables in Oracle

• Inner join returns only matching rows from both tables

• Outer join returns all rows from one table and matching rows from the other table

• Left outer join returns all rows from the left table and matching rows from the right table

• Right outer join returns all rows from the right table and matching rows from the left table

A is important for business growth as it helps in streamlining processes and improving efficiency.

• AP (Accounts Payable) plays a crucial role in managing a company's cash flow and financial stability.

• Efficient AP processes ensure timely payments to vendors and suppliers, which helps in maintaining good relationships.

• AP automation can reduce errors and save time, allowing employees to focus on more strategic tasks.

• Proper AP management can also help in identifying cost-saving op...read more

Synchronization in Java is used to control access to shared resources by multiple threads.

• Synchronization can be achieved using synchronized keyword or locks.

• It ensures that only one thread can access the shared resource at a time.

• Synchronization can be applied to methods or blocks of code.

• Example: synchronized void method() { //code }

• Example: synchronized(obj) { //code }

Use the 5l container to fill the 3l container, then pour it out and fill it again. Pour the excess into the 3l container and repeat.

• Fill 5l container and pour into 3l container

• Empty 3l container and pour remaining 2l from 5l container

• Fill 5l container again and pour 1l into 3l container to get 4l

• Final state: 5l container has 4l, 3l container has 0l

To publish Odata service by consumption view, create a consumption view and expose it as an Odata service.

• Create a consumption view using SE11 transaction

• Activate the view and generate the runtime object

• Create an Odata service using SEGW transaction

• Add the consumption view to the Odata service

• Activate and publish the Odata service

No, the view will not exist if the base table is deleted.

• Views are dependent on the base table.

• Deleting the base table will also delete the view.

• Views are virtual tables that depend on the existence of the base table.

Educating users about cybersecurity attacks is crucial for their protection.

• Conduct regular cybersecurity awareness training sessions

• Provide clear and concise guidelines on safe online practices

• Share real-life examples of cyber attacks and their consequences

• Encourage the use of strong and unique passwords

• Promote the use of multi-factor authentication

• Teach users how to identify phishing emails and suspicious links

• Advise against downloading files from unknown sources

• Highlight t...read more

Lists can be modified after creation, while tuples cannot be changed once created.

• Lists use square brackets [] while tuples use parentheses ()

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)

• Lists are more flexible but tuples are faster and consume less memory

Frameworks are pre-written code libraries that provide a structure and set of tools for developing software applications.

• Frameworks are reusable and provide a foundation for building applications.

• They offer predefined functions and classes to simplify development.

• Frameworks promote code organization and maintainability.

• Examples include AngularJS, Django, and Ruby on Rails.

Program to check if a number is a palindrome

• Convert the number to a string

• Reverse the string

• Compare the original string with the reversed string

• If they are the same, the number is a palindrome

Stream API is used to perform operations on collections in a functional programming style.

• Stream API provides a set of methods to perform operations on collections such as filtering, mapping, and reducing.

• It allows for concise and readable code by using lambda expressions.

• Stream API supports parallel processing for improved performance.

• Examples: stream.filter(x -> x > 5), stream.map(x -> x * 2), stream.reduce(0, (x, y) -> x + y)

Collections in Java are pre-built data structures that allow storing and manipulating groups of objects.

• Collections are part of the Java Collections Framework

• They provide interfaces like List, Set, and Map

• Collections can be used to store and manipulate objects of any type

• Examples of collections include ArrayList, HashSet, and TreeMap

A trigger is a special type of stored procedure that automatically executes in response to certain events.

• Triggers are used to enforce business rules or to perform complex calculations.

• Syntax: CREATE TRIGGER trigger_name {BEFORE | AFTER} {INSERT | UPDATE | DELETE} ON table_name FOR EACH ROW {trigger_body}

• Example: CREATE TRIGGER audit_log AFTER INSERT ON employees FOR EACH ROW INSERT INTO audit VALUES (NEW.id, 'inserted', NOW())

LAN stands for Local Area Network, which connects two or more devices in a limited area.

• LAN is a type of network that connects devices within a limited area such as a room, floor, or building.

• It allows devices to communicate with each other and share resources such as printers and files.

• LAN can be wired or wireless, and can be set up using Ethernet cables or Wi-Fi.

• Examples of LAN include home networks, office networks, and school networks.

HashMap and HashTable are both data structures in Java used to store key-value pairs, but HashMap is not synchronized and allows null keys/values.

• HashMap is not synchronized, while HashTable is synchronized.

• HashMap allows null keys and values, while HashTable does not.

• HashMap is generally preferred over HashTable for non-thread-safe applications.

• HashMap is part of the Java Collections Framework, while HashTable is a legacy class.

SQL drop is used to delete a table or a database, while truncate is used to delete all the data in a table.

• DROP command removes the table structure and its data, while TRUNCATE command only removes the data

• DROP command cannot be rolled back, while TRUNCATE command can be rolled back

• DROP command is DDL (Data Definition Language), while TRUNCATE command is DML (Data Manipulation Language)

• DROP command is slower than TRUNCATE command as it involves more operations

Answering questions related to nmap, IP addresses, firewall, and ping scan.

• Nmap uses various protocols such as TCP, UDP, ICMP, and ARP.

• Public IP addresses are globally unique and routable on the internet, while private IP addresses are used within a private network and not routable on the internet. Private IP ranges include 10.0.0.0/8, 172.16.0.0/12, and 192.168.0.0/16.

• To check connected devices and open ports, use the command 'nmap -sP ' and 'nmap -p ', respectively. To fil...read more

Ops concept refers to the operational aspects of a system, including maintenance, monitoring, and troubleshooting.

• Ops concept involves managing the day-to-day operations of a system to ensure its functionality and performance.

• It includes tasks such as monitoring system health, applying updates and patches, and troubleshooting issues.

• Ops concept also involves capacity planning, disaster recovery planning, and ensuring system security.

• Examples of ops concept tools include monit...read more

React hook is a feature in React that allows functional components to use state and other React features.

• React hooks were introduced in React 16.8 as a way to use state and other React features in functional components.

• Hooks are functions that let you use state and other React features without writing a class component.

• Some commonly used hooks are useState, useEffect, useContext, and useRef.

• Hooks can be used to manage component state, perform side effects, and access context ...read more

Autonomous transaction is a separate transaction initiated by a parent transaction.

• It allows a subtransaction to commit or rollback independently of the parent transaction.

• It is useful for logging or auditing purposes.

• It can be created using the PRAGMA AUTONOMOUS_TRANSACTION statement.

• Example: A parent transaction updates a table, while an autonomous transaction logs the changes made.

• Example: An autonomous transaction sends an email notification after a parent transaction com...read more

Tally accounting is an ERP software used for business functionalities like accounting, finance, inventory, payroll, etc.

• Tally accounting is an ERP software

• Used by small and large businesses

• Handles accounting, finance, inventory, payroll, etc.

• Helps in managing financial transactions

• Generates financial reports

• Provides real-time data

• Increases efficiency and accuracy

• Premises in accounting refer to fixed assets shown in the balance sheet

The authority in India for pharmacovigilance is the Central Drugs Standard Control Organization (CDSCO).

• The Central Drugs Standard Control Organization (CDSCO) is the national regulatory authority for pharmaceuticals and medical devices in India.

• CDSCO is responsible for the approval of new drugs, clinical trials, and post-marketing surveillance of drugs.

• It ensures the safety, efficacy, and quality of drugs and medical devices in the Indian market.

• CDSCO works under the Ministr...read more

When business doesn't agree with my design, I approach the situation by understanding their concerns, presenting data and research to support my design decisions, and collaborating to find a solution that meets both user and business needs.

• Listen to the business's concerns and understand their perspective

• Present data and research that supports the design decisions

• Explain the user-centered approach and the benefits it brings

• Collaborate with the business to find a solution that...read more

Questions on Spring Boot, Lambda expressions, and performance issues in cloud computing

• Spring Boot annotations and profiling

• Lambda expressions in Java 8

• Performance issues in cloud computing and where to start looking

• Triggering a schedule based on metrics

• Comparing cost of EC2 and Lambda

• When to choose Lambda

Implemented load balancing and failover mechanisms using AWS services.

• Used Amazon Elastic Load Balancer to distribute traffic across multiple instances.

• Configured Auto Scaling groups to automatically launch new instances in case of failure.

• Implemented Multi-AZ deployment for RDS instances to ensure high availability of database.

• Used Route 53 for DNS failover to redirect traffic to healthy instances in case of failure.

• Implemented S3 cross-region replication for disaster recove...read more

Depreciation is the decrease in value of tangible assets over time, while amortization is the decrease in value of intangible assets over time. Capital gains are profits made from selling assets at a higher price than their purchase price.

• Depreciation applies to tangible assets like buildings, machinery, and vehicles, while amortization applies to intangible assets like patents, copyrights, and trademarks.

• Depreciation and amortization are both methods of allocating the cost o...read more

Explanation of constraints, indexes, triggers, standalone and stored procedures.

• Constraints are rules that limit the type of data that can be inserted into a table.

• Indexes are used to speed up data retrieval by creating a pointer to the data.

• Triggers are used to automatically execute a set of instructions when a specific event occurs.

• Standalone procedures are independent procedures that can be executed on their own.

• Stored procedures are precompiled procedures that can be call...read more

In my current project, I implemented object-oriented programming (OOPs) principles to design and develop a banking application.

• Used encapsulation to protect sensitive customer data

• Implemented inheritance to create different types of bank accounts

• Utilized polymorphism to perform different operations on various account types

• Applied abstraction to hide complex implementation details from users

• Implemented interfaces to define common behaviors for different classes

I have used concepts like OOPs, Exception Handling, Collections, and Multithreading in my Selenium script.

• Used OOPs concepts like inheritance and polymorphism to create reusable code

• Implemented Exception Handling to handle unexpected errors and exceptions

• Used Collections like ArrayList and HashMap to store and retrieve data

• Implemented Multithreading to run tests in parallel for faster execution

• Used WebDriver interface to interact with web elements and perform actions

Using cursor in COBOL program, difference between cursor and SQL, and when to use JOINKEYS.

• Cursor is used to fetch data from a database table in COBOL program.

• SQL is a language used to interact with databases, while cursor is a mechanism to fetch data from a database table.

• JOINKEYS is used to join two or more files based on a common key.

• JOINKEYS is used when the files are too large to fit in memory.

• JOINKEYS is used when the files are sorted in ascending or descending order.

HTML is a markup language used for creating web pages, while JavaScript is a programming language used for adding interactivity to web pages.

• HTML is used for structuring content on web pages

• JavaScript is used for adding interactivity and dynamic behavior to web pages

• HTML is not a programming language, but JavaScript is

• Example: <html><head><title>Example</title></head><body><script>document.getElementById('demo').innerHTML = 'Hello World!';</script><p id='demo'></p></body></ht...read more

EMC Networker is a backup and recovery software tool used for data protection.

• EMC Networker provides centralized management of backup and recovery operations.

• It supports a wide range of platforms and applications.

• It offers features like data deduplication, replication, and snapshot management.

• EMC Networker also has integration with cloud storage providers like AWS and Azure.

• Examples of supported applications include Oracle, SAP, and Microsoft Exchange.

Communication between pods in different namespaces is possible through services or network policies.

• Use services to allow communication between pods in different namespaces

• Create network policies to control traffic flow between pods in different namespaces

• Ensure proper DNS resolution for pods in different namespaces

Automatic account determination is a process in SAP MM that determines the correct GL account for a transaction.

• It is based on the combination of transaction/event key and account modifier.

• The account modifier is determined based on the valuation class and account category assigned to the material.

• Examples of automatic account determination include determining the correct GL account for goods receipt, invoice receipt, and goods issue transactions.

• It helps ensure accurate fina...read more

Pragma_autonomous transaction is used to execute a transaction independently within a larger transaction.

• It allows a subtransaction to be committed or rolled back independently of the larger transaction.

• It is useful in situations where a subtransaction needs to be executed without affecting the larger transaction.

• It can be used in error handling, logging, or auditing.

• Example: A stored procedure that inserts data into multiple tables can use pragma_autonomous transaction to en...read more