Virtusa Consulting Services
300+ P. Puneet & Co Interview Questions and Answers
Q101. SQL error codes and their meanings
SQL error codes are numerical codes that indicate the type of error that occurred during SQL operations.
SQL error code 1062: Duplicate entry error
SQL error code 1045: Access denied error
SQL error code 1216: Foreign key constraint violation
Q102. using if else statements in JCL
Using if else statements in JCL
JCL does not have built-in support for if else statements like programming languages
Conditional logic in JCL is typically achieved using COND parameter in job control statements
Example: //STEP1 EXEC PGM=PROGRAM1,COND=(4,LT)
Q103. Design a delivery strategy to launch a new marketplace for electronics and consumer appliances?
Utilize a phased approach to launch the marketplace, focusing on product selection, vendor partnerships, marketing, and customer experience.
Research target market to identify popular electronics and appliances
Establish partnerships with reputable vendors for product sourcing
Create a marketing campaign to generate buzz and attract customers
Ensure seamless customer experience through user-friendly interface and efficient delivery logistics
Q104. How will you improve a model once it is trained
After training a model, I can improve it by fine-tuning hyperparameters, increasing the size of the training dataset, or implementing ensemble methods.
Fine-tune hyperparameters such as learning rate, batch size, and regularization strength to optimize model performance.
Increase the size of the training dataset by collecting more data or using data augmentation techniques to improve generalization.
Implement ensemble methods like bagging or boosting to combine multiple models f...read more
Q105. How did you applier OOPS concept in ur framework?
I applied OOPS concepts in my framework by using inheritance, encapsulation, polymorphism, and abstraction to create reusable and modular code.
Used inheritance to create parent classes with common functionality that child classes can inherit.
Implemented encapsulation by hiding internal implementation details and exposing only necessary methods and properties.
Leveraged polymorphism to allow objects of different classes to be treated as objects of a common superclass.
Utilized a...read more
Q106. difference between c and c++
C++ is an extension of C with object-oriented programming features.
C++ supports classes and objects while C does not.
C++ has better support for polymorphism and inheritance.
C++ has a standard template library (STL) while C does not.
C++ allows function overloading while C does not.
C++ has exception handling while C does not.
Q107. How to find a prime number?
A prime number is a number greater than 1 that is divisible only by 1 and itself.
Start by checking if the number is divisible by any number less than itself.
If it is divisible by any number other than 1 and itself, it is not prime.
Use a loop to iterate through numbers from 2 to the square root of the number being checked.
If the number is divisible by any of these numbers, it is not prime.
If the number is not divisible by any of these numbers, it is prime.
Q108. real time examples of object and class
Objects are instances of classes in object-oriented programming. Classes define the properties and behaviors of objects.
An example of a class is 'Car', which defines properties like color, make, and model, and behaviors like drive and stop.
An object of the class 'Car' could be 'myCar' with properties 'red', 'Toyota', 'Camry' and behaviors 'drive()' and 'stop()'.
Q109. What is the architecture of Apache Spark?
Apache Spark architecture includes a cluster manager, worker nodes, and driver program.
Apache Spark architecture consists of a cluster manager, which allocates resources and schedules tasks.
Worker nodes execute tasks and store data in memory or disk.
Driver program coordinates tasks and communicates with the cluster manager.
Spark applications run as independent sets of processes on a cluster, coordinated by the SparkContext object.
Data is processed in parallel across the worke...read more
Q110. Difference between Sdlc and Stlc, Defect life cycle, Test scenarios, Agile , Maven, Action class and Alert related questions etc
SDLC is Software Development Life Cycle, STLC is Software Testing Life Cycle. Defect life cycle involves identification, reporting, fixing, retesting, and closing defects. Test scenarios are high-level test cases. Agile is a software development methodology. Maven is a build automation tool. Action class is used for keyboard and mouse interactions in Selenium. Alerts are pop-up windows in web applications.
SDLC involves planning, designing, coding, testing, and deployment stag...read more
Q111. what type of filesystem used in ur project
We use Hadoop Distributed File System (HDFS) for our project.
HDFS is a distributed file system designed to run on commodity hardware.
It provides high-throughput access to application data and is fault-tolerant.
HDFS is used by many big data processing frameworks like Hadoop, Spark, etc.
It stores data in a distributed manner across multiple nodes in a cluster.
HDFS is optimized for large files and sequential reads and writes.
Q112. What is OOPS and explain all with their examples
OOPS stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects, which can contain data and code.
OOPS focuses on creating objects that interact with each other to solve a problem
Key principles of OOPS include encapsulation, inheritance, polymorphism, and abstraction
Encapsulation: bundling data and methods that operate on the data into a single unit
Inheritance: allows a class to inherit properties and behavior from another class
Polymor...read more
Q113. What are the consequences of AI
Consequences of AI include job displacement, privacy concerns, bias in decision-making, and potential misuse.
Job displacement: AI automation may lead to job loss in certain industries.
Privacy concerns: AI systems may collect and analyze personal data without consent.
Bias in decision-making: AI algorithms can perpetuate existing biases in data.
Potential misuse: AI technology can be used for malicious purposes such as deepfake videos or autonomous weapons.
Q114. Program to find if substring is present in a given string without using predefined functions
Iterate through the given string to check if the substring is present.
Iterate through the given string and check if each character matches the first character of the substring.
If a match is found, check the subsequent characters to see if they form the substring.
Return true if the entire substring is found within the given string, otherwise return false.
Q115. String is immutable. Array and arraylist differences
String is immutable, array and arraylist are mutable data structures.
String is immutable, meaning its value cannot be changed once it is created.
Array is a fixed-size data structure that stores elements of the same data type.
ArrayList is a dynamic array that can grow or shrink in size as needed.
Example: String str = "hello"; char[] arr = {'h', 'e', 'l', 'l', 'o'}; ArrayList
list = new ArrayList ();
Q116. Difference between interface and abstract in java
Interface in Java is a blueprint of a class that can have abstract methods and constants. Abstract class is a class that can have abstract methods and concrete methods.
Interface can only have abstract methods and constants, while abstract class can have abstract methods and concrete methods.
A class can implement multiple interfaces but can only extend one abstract class.
Interfaces are used to achieve multiple inheritance in Java.
Abstract classes can have constructors, while i...read more
Q118. What are permission sets, dashborads, types of reports
Permission sets control access to various Salesforce features, dashboards provide visual representations of data, and reports offer insights into data.
Permission sets are used to grant specific permissions and access settings to users without changing their profiles.
Dashboards display key metrics and performance indicators in visual charts and graphs.
Types of reports include tabular, summary, matrix, and joined reports, each offering different ways to analyze data.
Q119. What are decorators in Python What is the use of __name == __main__ Django related questions
Decorators in Python are functions that modify the behavior of other functions or methods. __name__ == __main__ is used to check if a Python script is being run directly or imported as a module.
Decorators are used to add functionality to existing functions without modifying their code.
They are defined using the @decorator syntax before the function definition.
Example: @staticmethod decorator in Python is used to define a method that doesn't access or modify class or instance ...read more
Q120. 5)what are modules and libraries in python
Q121. Like.... How to federate node and how to sync??
Federating nodes involves connecting multiple nodes to form a single network. Syncing ensures data consistency across all nodes.
Federation involves establishing trust between nodes and allowing them to communicate with each other.
Syncing involves ensuring that data is consistent across all nodes in the network.
Examples of federated systems include blockchain networks and distributed databases.
Syncing can be achieved through various methods such as periodic updates or real-tim...read more
Q122. What is polymorphism,buzz words of java
Polymorphism is the ability of an object to take on many forms.
Polymorphism allows objects of different classes to be treated as if they are of the same class.
It is achieved through method overloading and method overriding.
Example: A parent class Animal can have child classes like Dog, Cat, and Bird. Each child class can have its own implementation of the method 'makeSound', but they can all be called using the same method name from the parent class.
Java buzzwords related to ...read more
Q123. code for interchange of strings without strcpy
Use a loop to swap characters of two strings without using strcpy function.
Create two arrays of characters to store the strings
Use a loop to iterate through each character of the strings and swap them
Ensure to handle cases where strings have different lengths
Q124. Preparation of balance sheet and computation of various ratios
Preparation of balance sheet involves listing assets, liabilities, and equity. Ratios are computed using financial data from the balance sheet.
List all assets, liabilities, and equity on the balance sheet
Calculate various financial ratios such as current ratio, debt to equity ratio, and return on equity
Use formulae like Current Ratio = Current Assets / Current Liabilities
Interpret the ratios to analyze the financial health and performance of the company
Q125. 1.what is difference between final and finalise? 2.how do you integrate Jenkins with maven?
Final is a keyword in Java used to declare constants, while finalize is a method in Java used for cleanup operations before an object is garbage collected.
Final is used to declare constants in Java
Finalize is a method in Java used for cleanup operations before garbage collection
Final variables cannot be reassigned, while finalize method is called by the garbage collector
Q126. Differences between current and previous technologies
Current technologies are more advanced, efficient, and user-friendly compared to previous technologies.
Current technologies have faster processing speeds and higher storage capacities.
Previous technologies often required manual input and were less intuitive for users.
Current technologies offer more connectivity options and seamless integration with other devices.
Examples: Smartphones vs. flip phones, cloud computing vs. physical servers
Q127. 3)How to add spaces in html elements?
Q128. 6)what are html elements and html tags
Q129. Write SQL query to join 2 tables (inner join)
SQL query to perform inner join on 2 tables
Use the JOIN keyword to combine rows from two tables based on a related column
Specify the columns to select from each table
Use the ON keyword to specify the join condition
Q130. Write SQL query to get second highest salary
SQL query to retrieve the second highest salary from a table
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to retrieve the second row
Q131. What is the difference between PySpark and Python?
PySpark is a Python API for Apache Spark, while Python is a general-purpose programming language.
PySpark is specifically designed for big data processing using Spark, while Python is a versatile programming language used for various applications.
PySpark allows for distributed computing and parallel processing, while Python is primarily used for sequential programming.
PySpark provides libraries and tools for working with large datasets efficiently, while Python may require add...read more
Q132. How to handle exceptions in connect REST
Exceptions in connect REST can be handled using error handling mechanisms like try-catch blocks and error codes.
Use try-catch blocks to catch exceptions and handle them appropriately
Utilize error codes to identify the type of exception and take necessary actions
Implement error handling logic in the response mapping to handle errors from the REST service
Q133. Tell me about Object class in Java
Object class is the root class for all Java classes, providing common methods and behaviors for all objects.
Object class is at the top of the class hierarchy in Java
All classes in Java are directly or indirectly derived from the Object class
Object class provides methods like equals(), hashCode(), toString() which can be overridden in subclasses
Q134. Which framework used in your last project
We used the Selenium framework in our last project for test automation.
Selenium WebDriver was used for automating web application testing
TestNG was used for test case management and execution
Page Object Model design pattern was implemented for better code maintenance
Q135. What are the core responsibilities of PMO?
Core responsibilities of PMO include project governance, portfolio management, resource management, and process improvement.
Project governance to ensure projects align with organizational goals and standards
Portfolio management to prioritize projects based on strategic objectives
Resource management to allocate resources effectively across projects
Process improvement to enhance project delivery and efficiency
Q136. what do you know about java
Java is a popular programming language known for its platform independence and object-oriented approach.
Java is an object-oriented programming language
It is known for its platform independence, meaning Java programs can run on any device that has a Java Virtual Machine (JVM)
Java is used for developing a wide range of applications, from mobile apps to enterprise systems
Java has a rich set of libraries and frameworks that make development easier and faster
Q137. Difference between for and while loop?
For loop is used when the number of iterations is known, while loop is used when the condition is true.
For loop is used when the number of iterations is known in advance.
While loop is used when the condition is true.
For loop is more suitable for iterating over arrays or collections.
While loop is more flexible as it can handle complex conditions.
Q138. How to reverse a string?
To reverse a string, iterate through the characters of the string and swap the first character with the last, the second character with the second-to-last, and so on.
Iterate through the characters of the string using a loop
Swap the characters at the corresponding positions using a temporary variable
Continue swapping until the middle of the string is reached
Q139. Command to check disk utilisation and health in Hadoop
Use 'hdfs diskbalancer' command to check disk utilisation and health in Hadoop
Run 'hdfs diskbalancer -report' to get a report on disk utilisation
Use 'hdfs diskbalancer -plan <path>' to generate a plan for balancing disk usage
Check the Hadoop logs for any disk health issues
Q140. In how many was we invoke a button in siebel?
A button in Siebel can be invoked in multiple ways.
A button can be invoked by clicking on it in the user interface.
A button can be invoked programmatically using scripting or workflows.
A button can be invoked through keyboard shortcuts.
A button can be invoked by triggering a specific event or condition.
A button can be invoked by integrating with other systems or applications.
Q141. What is tangebile assets and intangibles assets
Q142. What is artificial intelligence. Explain
Artificial intelligence is the simulation of human intelligence processes by machines, especially computer systems.
AI involves machines learning from data, recognizing patterns, and making decisions based on that data.
It includes various technologies like machine learning, natural language processing, and computer vision.
Examples of AI applications include virtual assistants like Siri, self-driving cars, and recommendation systems like Netflix.
AI can be categorized into narro...read more
Q143. Elaborate the Cyber Ark components and its functions
Cyber Ark components include Privileged Account Security, Endpoint Privilege Manager, and Privileged Session Manager.
Privileged Account Security: Manages and secures privileged accounts and credentials.
Endpoint Privilege Manager: Controls and monitors privileged access on endpoints.
Privileged Session Manager: Monitors and records privileged sessions for auditing purposes.
Q144. Difference between traditional function and arrow function
Traditional functions are defined using the function keyword, while arrow functions are defined using a concise syntax with =>.
Traditional functions are hoisted, while arrow functions are not.
Arrow functions do not have their own 'this' keyword, they inherit it from the parent scope.
Arrow functions are more concise and easier to read compared to traditional functions.
Traditional functions are better for methods in objects, while arrow functions are better for callbacks or eve...read more
Q145. What kind of data does a Telco hold?
Telcos hold various types of data including customer information, call records, location data, billing details, network performance data, and more.
Customer information (name, address, contact details)
Call records (incoming, outgoing, duration)
Location data (cell tower information, GPS coordinates)
Billing details (usage, charges, payment history)
Network performance data (speed, connectivity, outages)
Q146. What do you mean flexible?
Flexible means adaptable to change or able to be modified easily.
Being able to adjust to new requirements or situations
Having the ability to change or modify code without breaking it
Being open to feedback and willing to make changes
Allowing for customization or configuration options
Examples: using variables instead of hardcoding values, implementing a plugin system
Q147. How do you treat missing values in data?
Q148. How do you treat outliers in the data?
Q149. What do you know about Google Ads
Q150. What factors to consider for Data Arachitecting
Q151. What are various Data modeling approaches
Q152. Validation technique in MVC?
Validation in MVC ensures data entered by user meets specified criteria before processing.
Validation can be done using data annotations in model classes.
Validation can also be performed using ModelState.IsValid in controller actions.
Client-side validation can be implemented using JavaScript libraries like jQuery Validate.
Q153. Why string is immutable
String is immutable to ensure thread safety and prevent unintended modification.
Immutable strings can be safely shared across multiple threads without the risk of race conditions.
Immutable strings prevent unintended modification, which can cause unexpected behavior in the program.
String interning is possible because of immutability, which allows for efficient memory usage.
Examples of immutable classes in Java include String, Integer, and Boolean.
Q154. How we can achieve load balancing in spring bot
Load balancing in Spring Boot can be achieved using various techniques such as server-side load balancing, client-side load balancing, and using a load balancer.
Server-side load balancing can be achieved by using technologies like Ribbon or Eureka in Spring Cloud.
Client-side load balancing can be implemented by using technologies like Feign or RestTemplate in Spring Cloud.
Using a load balancer like Nginx or Apache in front of Spring Boot application can also help in achieving...read more
Q155. ArrayList and LinkedList Differences?
ArrayList is resizable array implementation, LinkedList is doubly linked list implementation.
ArrayList uses dynamic array to store elements, LinkedList uses doubly linked list
ArrayList is faster for accessing elements by index, LinkedList is faster for adding/removing elements
Example: ArrayList
arrList = new ArrayList<>(); LinkedList linkedList = new LinkedList<>();
Q156. String reverse Program in Java?
A program to reverse a given string in Java.
Create a char array from the input string.
Use two pointers to swap characters from start and end of the array.
Convert the char array back to a string and return.
Q157. 8)we can we change the colour of bullets?
Q158. Explain object oriented programming?
Object-oriented programming is a programming paradigm that organizes code into objects, which are instances of classes.
Encourages modular and reusable code
Focuses on data and behavior encapsulation
Supports inheritance and polymorphism
Promotes code organization and maintainability
Examples: Java, C++, Python
Q159. What is the use of MDC logging
MDC logging is used to enrich log messages with contextual information specific to each thread or user.
MDC stands for Mapped Diagnostic Context
It allows developers to include additional information in log messages without modifying the log message itself
Useful for tracking user sessions, request IDs, or any other contextual information
Commonly used in multi-threaded applications to differentiate log messages from different threads
Q160. Total number of planes in Delhi on a given day
The total number of planes in Delhi on a given day can vary depending on the day of the week, time of day, and airport capacity.
The total number of planes in Delhi on a given day can be obtained by contacting the airport authorities or checking flight schedules online.
Factors such as weather conditions, flight delays, and cancellations can also affect the total number of planes in Delhi on a given day.
On average, Delhi's Indira Gandhi International Airport handles around 1,30...read more
Q161. What factors to consider for Designing Data Model
Q162. Do the coding part of Java 8
Yes, I am proficient in coding in Java 8.
Lambda expressions
Functional interfaces
Streams API
Optional class
Method references
Q163. Differentiate between Sessions and Cookies
Sessions store data on the server side while cookies store data on the client side.
Sessions store data on the server side, while cookies store data on the client side
Sessions are more secure as the data is stored on the server and not visible to the client
Cookies are stored on the client's browser and can be accessed and modified by the client
Sessions are typically used to store sensitive information like user credentials, while cookies are used for tracking user behavior or ...read more
Q164. Difference between linkedlist and arry list
LinkedList is a data structure where elements are stored in nodes with pointers to the next element, while ArrayList is a dynamic array that can resize itself.
LinkedList uses nodes with pointers to the next element, allowing for efficient insertion and deletion operations.
ArrayList is a dynamic array that can resize itself, making it faster for random access but slower for insertion and deletion.
LinkedList is more memory efficient as it only needs to store the value and a poi...read more
Q165. CICS commands and their uses
CICS commands are used to interact with the CICS system in mainframe environments.
Some common CICS commands include START, RETURN, SEND, RECEIVE, and XCTL.
START is used to initiate a new transaction in CICS.
RETURN is used to end a transaction and return control to the calling program.
SEND and RECEIVE are used for communication between programs within CICS.
XCTL is used to transfer control from one program to another in CICS.
Q166. Difference between Balance sheet and trial balance
Balance sheet shows assets, liabilities, and equity at a specific point in time. Trial balance lists all ledger accounts with their balances.
Balance sheet is a snapshot of a company's financial position at a specific point in time.
Trial balance is a list of all ledger accounts with their balances to ensure debits equal credits.
Balance sheet includes assets, liabilities, and equity sections.
Trial balance is used to prepare financial statements like income statement and balance...read more
Q167. difference b/w java and c++
Java is platform-independent, object-oriented, and uses automatic memory management, while C++ is platform-dependent, supports multiple paradigms, and requires manual memory management.
Java is platform-independent, while C++ is platform-dependent.
Java is object-oriented, while C++ supports multiple paradigms.
Java uses automatic memory management (garbage collection), while C++ requires manual memory management.
Java has a simpler syntax compared to C++.
Java has a larger standa...read more
Q168. Diff b/w tjava , tjavaflex, tjavarow?
tJava, tJavaFlex, and tJavaRow are components in Talend for Java programming.
tJava is used for writing custom Java code in Talend jobs.
tJavaFlex is used for writing complex Java code in Talend jobs.
tJavaRow is used for writing Java code to manipulate data in Talend jobs.
All three components require Java programming knowledge.
Examples: tJava can be used to perform calculations, tJavaFlex can be used to create custom functions, and tJavaRow can be used to filter data.
Q169. What is Java OOP's concept
Java OOP's concept is a programming paradigm that uses objects to design applications and programs.
Java OOP's concept is based on four main principles: encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation is the process of hiding the implementation details of an object from the outside world.
Inheritance allows a class to inherit properties and methods from another class.
Polymorphism allows objects to take on multiple forms or behaviors.
Abstraction is the pr...read more
Q170. What is SDLC and Explain it's steps?
SDLC stands for Software Development Life Cycle. It is a process followed by software development teams to design, develop, and test high-quality software.
The steps of SDLC include planning, analysis, design, development, testing, deployment, and maintenance.
During the planning phase, the project scope, requirements, and timelines are defined.
In the analysis phase, the team identifies the user needs and creates a detailed project plan.
The design phase involves creating a blue...read more
Q171. what are oops concept Explain
Object-oriented programming concepts that promote code reusability and modularity.
Encapsulation: bundling of data and methods into a single unit (class)
Inheritance: ability of a class to inherit properties and methods from another class
Polymorphism: ability to use a single interface to represent different types of objects
Abstraction: hiding unnecessary details and exposing only essential features
Example: In a car manufacturing system, Car class can inherit properties and meth...read more
Q172. What is Object and class
An object is an instance of a class, which is a blueprint for creating objects with similar properties and behaviors.
A class is a template or blueprint that defines the properties and behaviors of objects.
An object is an instance of a class and represents a specific entity with its own unique set of properties and behaviors.
Classes can have attributes (variables) and methods (functions) to define the behavior of objects.
Objects can interact with each other by invoking methods...read more
Q173. how to use Reference cursor in procedure
Reference cursor in procedure is used to return result sets from a stored procedure.
Declare a cursor variable in the procedure using TYPE keyword
Open the cursor variable using OPEN keyword
Fetch data from the cursor using FETCH keyword
Close the cursor using CLOSE keyword after fetching all data
Q174. comfortable with night shights
Yes, I am comfortable with night shifts as I have previous experience working during those hours.
Have previous experience working night shifts
Understand the importance of maintaining focus and attention during non-traditional work hours
Able to adjust sleep schedule accordingly to ensure optimal performance during night shifts
Q175. Pivot table creation in SQL from not pivot one
To create a pivot table in SQL from a non-pivot table, you can use the CASE statement with aggregate functions.
Use the CASE statement to categorize data into columns
Apply aggregate functions like SUM, COUNT, AVG, etc. to calculate values for each category
Group the data by the columns you want to pivot on
Q176. Explain encapsulation and abstraction
Encapsulation is the process of hiding implementation details while abstraction is the process of hiding unnecessary details.
Encapsulation is achieved through access modifiers like public, private, and protected.
Abstraction is achieved through abstract classes and interfaces.
Encapsulation protects the data from outside interference while abstraction focuses on the essential features of an object.
Example of encapsulation: A class with private variables and public methods to ac...read more
Q177. Program to find frequency of letters in a string
Program to find frequency of letters in a string
Create an object to store the frequency of each letter
Loop through the string and increment the count of each letter in the object
Convert the object into an array of strings with letter and frequency pairs
Q178. OOPS concept and real time example
OOPS concept is a programming paradigm that uses objects and classes for organizing code. Real-time example: Car
Encapsulation: Car class with private variables like speed, color, and methods like accelerate, brake
Inheritance: Creating a subclass ElectricCar that inherits from Car class
Polymorphism: Overriding the accelerate method in ElectricCar class to increase speed differently
Q179. what type of code you have written?
Q180. Write a program in any language of your convenient
A program to find the factorial of a given number.
Take input from the user for the number whose factorial needs to be found.
Use a loop to multiply the number with all the numbers less than it.
Print the final result as the factorial of the given number.
Q181. what is selenium and components of it
Selenium is a popular open-source automation testing tool used for web applications.
Selenium is used for automating web browsers.
Components of Selenium include Selenium IDE, Selenium WebDriver, and Selenium Grid.
Selenium IDE is a record and playback tool, WebDriver is for writing test scripts in various programming languages, and Grid is for parallel test execution.
Selenium supports multiple programming languages like Java, Python, C#, etc.
Selenium can run on different browse...read more
Q182. what is use of annotations in testng
Annotations in TestNG are used to provide additional information about test methods and classes, such as priority, dependencies, and data providers.
Annotations help in organizing and controlling the flow of test methods
Annotations can be used to set the priority of test methods
Annotations can be used to define dependencies between test methods
Annotations can be used to provide data for parameterized tests
Q183. What are default methods in Java 8
Default methods in Java 8 allow interfaces to have method implementations.
Default methods were introduced in Java 8 to allow interfaces to have method implementations.
They provide a way to add new methods to interfaces without breaking existing implementations.
Default methods are defined using the 'default' keyword in the interface.
They can be overridden in implementing classes if needed.
Example: interface MyInterface { default void myMethod() { System.out.println('Default me...read more
Q184. What is recursive CTE
A recursive CTE (Common Table Expression) is a query that references itself within the query definition.
Allows for hierarchical data querying
Uses a base case and recursive member in the query
Example: querying a table with parent-child relationship using recursive CTE
Q185. What is Virtual dom in react
Virtual DOM is a lightweight copy of the actual DOM in React, used for efficient updates and rendering.
Virtual DOM is a concept in React where a lightweight copy of the actual DOM is created.
It allows React to efficiently update and render components by comparing the virtual DOM with the actual DOM.
When changes are made to the virtual DOM, React calculates the most efficient way to update the actual DOM.
This helps in improving performance and reducing unnecessary re-renders i...read more
Q186. How to call api in react
To call an API in React, you can use the fetch() method or libraries like Axios.
Use the fetch() method to make HTTP requests in React.
Install Axios library using npm and import it in your React component.
Make API calls in React using Axios by sending GET, POST, PUT, or DELETE requests.
Handle API responses using promises or async/await syntax.
Q187. code for reverse the string
Code to reverse a string
Create an empty string to store the reversed string
Loop through the original string from the end to the beginning
Append each character to the empty string
Return the reversed string
Q188. Software Development Lifecycle
Software Development Lifecycle is a process of planning, designing, developing, testing, and deploying software.
SDLC is a framework that helps in the development of high-quality software.
It involves various stages such as planning, designing, coding, testing, and deployment.
Each stage has its own set of activities and deliverables.
The goal of SDLC is to ensure that the software meets the customer's requirements and is delivered on time and within budget.
Examples of SDLC model...read more
Q189. Test Scenarios for Gmail. And explain
Test scenarios for Gmail
Testing login functionality with valid and invalid credentials
Testing composing and sending emails with attachments
Testing email filtering and sorting options
Testing email forwarding and reply functionality
Testing integration with other Google services like Google Drive and Calendar
Q190. deep copy shallow copy differences
Deep copy creates a new copy of an object with its own unique memory space, while shallow copy creates a new object that references the same memory locations as the original object.
Deep copy duplicates all nested objects, while shallow copy only duplicates the references to nested objects.
Deep copy ensures that changes to the copied object do not affect the original object, while shallow copy may lead to unintended side effects.
Examples: deep copy - using JSON.parse(JSON.stri...read more
Q191. Explain what are the challenges in ETL
Challenges in ETL include data quality issues, scalability, performance bottlenecks, and complex transformations.
Data quality issues such as missing or incorrect data can impact the accuracy of the ETL process.
Scalability challenges arise when dealing with large volumes of data, requiring efficient processing and storage solutions.
Performance bottlenecks can occur due to inefficient data extraction, transformation, or loading processes.
Complex transformations, such as joining...read more
Q192. Difference between budgeting and forecasting
Budgeting involves setting financial goals and allocating resources, while forecasting predicts future financial outcomes based on past data and trends.
Budgeting is a plan for how to allocate resources and achieve financial goals
Forecasting predicts future financial outcomes based on past data and trends
Budgeting is typically done on an annual basis, while forecasting can be done on a shorter or longer term basis
Budgeting involves setting specific targets for revenue, expense...read more
Q193. Accounting entry for accumulated depreciation
Accumulated depreciation is a contra asset account that represents the total depreciation expense taken on an asset since it was acquired.
Accumulated depreciation is recorded on the balance sheet as a reduction from the gross amount of fixed assets to arrive at the net book value.
The accounting entry for accumulated depreciation involves debiting the depreciation expense account and crediting the accumulated depreciation account.
For example, if a company records $1,000 in dep...read more
Q194. wirte lwc component using combobox
Create a Lightning Web Component (LWC) using a combobox
Use the lightning-combobox component in your LWC template
Define options for the combobox in your JavaScript file
Handle selection changes using event handlers
Q195. What is Encapsulation?
Encapsulation is the process of hiding internal details of an object and providing access only through defined methods.
Encapsulation is a fundamental principle of object-oriented programming.
It helps in achieving data abstraction and data hiding.
By encapsulating data and methods together, it ensures data integrity and security.
Encapsulation allows for easy modification of internal implementation without affecting the external code that uses the object.
Access to the encapsulat...read more
Q196. Solid principles with real time examples
Solid principles are a set of design principles for writing clean, maintainable code.
Single Responsibility Principle - A class should have only one reason to change. Example: A class that handles user authentication should not also handle database operations.
Open/Closed Principle - Classes should be open for extension but closed for modification. Example: Using interfaces to allow for different implementations without changing existing code.
Liskov Substitution Principle - Obj...read more
Q197. Diff between abstract class and interface
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have constructor, fields, and methods, while interface cannot have any of these.
A class can extend only one abstract class, but can implement multiple interfaces.
Abstract classes are used to define a common behavior among subclasses, while interfaces are used to define a contract for classes to implement.
Example: Abstract class 'Shape' with abstrac...read more
Q198. What is a copy constructor
A copy constructor is a special type of constructor in object-oriented programming that creates a new object as a copy of an existing object.
Copy constructor is used to initialize a new object as a copy of an existing object.
It takes an object of the same class as a parameter.
It is typically used to create deep copies of objects to avoid shallow copy issues.
Q199. Project management capabilities
I have extensive project management experience and have successfully led multiple projects from initiation to closure.
Experience in creating project plans, timelines, and budgets
Ability to identify and mitigate project risks
Strong communication and stakeholder management skills
Experience in leading cross-functional teams
Proficient in project management tools such as Microsoft Project and JIRA
Q200. What is the meaning of main()
main() is the entry point of a C or C++ program where execution begins.
main() is a predefined function in C and C++ programming languages.
It is the starting point of execution for any C or C++ program.
It can have arguments like argc and argv to accept command line arguments.
The return type of main() function is int.
Example: int main() { // code }
More about working at Virtusa Consulting Services
Top HR Questions asked in P. Puneet & Co
Interview Process at P. Puneet & Co
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month