Add office photos
Employer?
Claim Account for FREE

Virtusa Consulting Services

3.8
based on 4.7k Reviews
Filter interviews by

300+ P. Puneet & Co Interview Questions and Answers

Updated 31 Jan 2025
Popular Designations

Q101. SQL error codes and their meanings

Ans.

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

Add your answer

Q102. using if else statements in JCL

Ans.

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)

Add your answer

Q103. Design a delivery strategy to launch a new marketplace for electronics and consumer appliances?

Ans.

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

Add your answer

Q104. How will you improve a model once it is trained

Ans.

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

Add your answer
Discover P. Puneet & Co interview dos and don'ts from real experiences

Q105. How did you applier OOPS concept in ur framework?

Ans.

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

Add your answer

Q106. difference between c and c++

Ans.

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.

Add your answer
Are these interview questions helpful?

Q107. How to find a prime number?

Ans.

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.

Add your answer

Q108. real time examples of object and class

Ans.

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()'.

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q109. What is the architecture of Apache Spark?

Ans.

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

Add your answer

Q110. Difference between Sdlc and Stlc, Defect life cycle, Test scenarios, Agile , Maven, Action class and Alert related questions etc

Ans.

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

Add your answer

Q111. what type of filesystem used in ur project

Ans.

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.

Add your answer

Q112. What is OOPS and explain all with their examples

Ans.

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

Add your answer

Q113. What are the consequences of AI

Ans.

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.

Add your answer

Q114. Program to find if substring is present in a given string without using predefined functions

Ans.

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.

Add your answer

Q115. String is immutable. Array and arraylist differences

Ans.

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();

Add your answer

Q116. Difference between interface and abstract in java

Ans.

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

Add your answer
Q117. In the 100 Prisoners problem, each prisoner is randomly assigned a red or black hat. They can see the hats of all other prisoners but not their own. The challenge is to devise a strategy that allows the maximum...read more
Add your answer

Q118. What are permission sets, dashborads, types of reports

Ans.

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.

Add your answer

Q119. What are decorators in Python What is the use of __name == __main__ Django related questions

Ans.

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

Add your answer

Q120. 5)what are modules and libraries in python

Add your answer

Q121. Like.... How to federate node and how to sync??

Ans.

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

Add your answer

Q122. What is polymorphism,buzz words of java

Ans.

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

Add your answer

Q123. code for interchange of strings without strcpy

Ans.

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

Add your answer

Q124. Preparation of balance sheet and computation of various ratios

Ans.

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

Add your answer

Q125. 1.what is difference between final and finalise? 2.how do you integrate Jenkins with maven?

Ans.

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

Add your answer

Q126. Differences between current and previous technologies

Ans.

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

Add your answer

Q127. 3)How to add spaces in html elements?

Add your answer

Q128. 6)what are html elements and html tags

Add your answer

Q129. Write SQL query to join 2 tables (inner join)

Ans.

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

Add your answer

Q130. Write SQL query to get second highest salary

Ans.

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

Add your answer

Q131. What is the difference between PySpark and Python?

Ans.

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

Add your answer

Q132. How to handle exceptions in connect REST

Ans.

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

Add your answer

Q133. Tell me about Object class in Java

Ans.

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

Add your answer

Q134. Which framework used in your last project

Ans.

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

Add your answer

Q135. What are the core responsibilities of PMO?

Ans.

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

Add your answer

Q136. what do you know about java

Ans.

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

Add your answer

Q137. Difference between for and while loop?

Ans.

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.

Add your answer

Q138. How to reverse a string?

Ans.

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

Add your answer

Q139. Command to check disk utilisation and health in Hadoop

Ans.

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

Add your answer

Q140. In how many was we invoke a button in siebel?

Ans.

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.

Add your answer

Q141. What is tangebile assets and intangibles assets

Add your answer

Q142. What is artificial intelligence. Explain

Ans.

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

Add your answer

Q143. Elaborate the Cyber Ark components and its functions

Ans.

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.

Add your answer

Q144. Difference between traditional function and arrow function

Ans.

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

Add your answer

Q145. What kind of data does a Telco hold?

Ans.

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)

Add your answer

Q146. What do you mean flexible?

Ans.

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

Add your answer

Q147. How do you treat missing values in data?

Add your answer

Q148. How do you treat outliers in the data?

Add your answer

Q149. What do you know about Google Ads

Add your answer

Q150. What factors to consider for Data Arachitecting

Add your answer

Q151. What are various Data modeling approaches

Add your answer

Q152. Validation technique in MVC?

Ans.

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.

Add your answer

Q153. Why string is immutable

Ans.

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.

View 1 answer

Q154. How we can achieve load balancing in spring bot

Ans.

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

Add your answer

Q155. ArrayList and LinkedList Differences?

Ans.

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<>();

Add your answer

Q156. String reverse Program in Java?

Ans.

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.

Add your answer

Q157. 8)we can we change the colour of bullets?

Add your answer

Q158. Explain object oriented programming?

Ans.

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

Add your answer

Q159. What is the use of MDC logging

Ans.

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

Add your answer

Q160. Total number of planes in Delhi on a given day

Ans.

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

Add your answer

Q161. What factors to consider for Designing Data Model

Add your answer

Q162. Do the coding part of Java 8

Ans.

Yes, I am proficient in coding in Java 8.

  • Lambda expressions

  • Functional interfaces

  • Streams API

  • Optional class

  • Method references

Add your answer

Q163. Differentiate between Sessions and Cookies

Ans.

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

Add your answer

Q164. Difference between linkedlist and arry list

Ans.

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

Add your answer

Q165. CICS commands and their uses

Ans.

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.

Add your answer

Q166. Difference between Balance sheet and trial balance

Ans.

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

Add your answer

Q167. difference b/w java and c++

Ans.

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

Add your answer

Q168. Diff b/w tjava , tjavaflex, tjavarow?

Ans.

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.

Add your answer

Q169. What is Java OOP's concept

Ans.

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

Add your answer

Q170. What is SDLC and Explain it's steps?

Ans.

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

Add your answer

Q171. what are oops concept Explain

Ans.

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

Add your answer

Q172. What is Object and class

Ans.

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

Add your answer

Q173. how to use Reference cursor in procedure

Ans.

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

Add your answer

Q174. comfortable with night shights

Ans.

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

Add your answer

Q175. Pivot table creation in SQL from not pivot one

Ans.

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

Add your answer

Q176. Explain encapsulation and abstraction

Ans.

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

View 1 answer

Q177. Program to find frequency of letters in a string

Ans.

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

Add your answer

Q178. OOPS concept and real time example

Ans.

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

Add your answer

Q179. what type of code you have written?

Add your answer

Q180. Write a program in any language of your convenient

Ans.

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.

Add your answer

Q181. what is selenium and components of it

Ans.

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

Add your answer

Q182. what is use of annotations in testng

Ans.

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

Add your answer

Q183. What are default methods in Java 8

Ans.

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

Add your answer

Q184. What is recursive CTE

Ans.

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

Add your answer

Q185. What is Virtual dom in react

Ans.

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

Add your answer

Q186. How to call api in react

Ans.

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.

Add your answer

Q187. code for reverse the string

Ans.

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

Add your answer

Q188. Software Development Lifecycle

Ans.

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

Add your answer

Q189. Test Scenarios for Gmail. And explain

Ans.

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

Add your answer

Q190. deep copy shallow copy differences

Ans.

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

Add your answer

Q191. Explain what are the challenges in ETL

Ans.

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

Add your answer

Q192. Difference between budgeting and forecasting

Ans.

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

Add your answer

Q193. Accounting entry for accumulated depreciation

Ans.

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

Add your answer

Q194. wirte lwc component using combobox

Ans.

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

Add your answer

Q195. What is Encapsulation?

Ans.

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

Add your answer

Q196. Solid principles with real time examples

Ans.

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

Add your answer

Q197. Diff between abstract class and interface

Ans.

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

Add your answer

Q198. What is a copy constructor

Ans.

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.

Add your answer

Q199. Project management capabilities

Ans.

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

Add your answer

Q200. What is the meaning of main()

Ans.

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 }

Add your answer
1
2
3
4
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at P. Puneet & Co

based on 453 interviews
Interview experience
4.0
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

4.1
 • 548 Interview Questions
4.1
 • 269 Interview Questions
3.6
 • 192 Interview Questions
4.1
 • 161 Interview Questions
3.8
 • 135 Interview Questions
4.3
 • 134 Interview Questions
View all
Top Virtusa Consulting Services Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter