60+ Techved Consulting Interview Questions and Answers

To resolve sb37, increase space by twice and use volume counter to increment extend if needed.

• Increase space by twice at first

• If issue persists, use volume counter to increment extend

• Ensure adequate space is available before running job

Singleton pattern can be broken using reflection, serialization, and cloning.

• Reflection can be used to access the private constructor and create multiple instances.

• Serialization can create multiple instances when the object is deserialized.

• Cloning can create a new instance of the singleton object.

OOPS is Object-Oriented Programming, Networking Basics is the fundamental concepts of computer networking, C and C++ are programming languages, Febinose series program is a mathematical series.

• OOPS is a programming paradigm that uses objects to represent real-world entities. Example: Java, Python, C#

• Networking Basics include concepts like IP addresses, protocols, and network topologies. Example: TCP/IP, LAN, WAN

• C and C++ are programming languages used for system programming a...read more

CPU stands for Central Processing Unit. It is the brain of a computer that performs all the processing tasks.

• CPU is the main component of a computer that executes instructions and performs calculations.

• It is responsible for fetching, decoding, and executing instructions stored in the computer's memory.

• CPU speed is measured in gigahertz (GHz) and determines how fast it can process data.

• Examples of CPUs include Intel Core i7, AMD Ryzen 5, etc.

BDD (Behavior Driven Development) is a testing framework that focuses on the behavior of the system.

• BDD is a collaboration between developers, testers, and business stakeholders

• It uses natural language to describe the behavior of the system in terms of scenarios and examples

• BDD frameworks include tools like Cucumber, SpecFlow, and Behave

• BDD helps ensure that the system meets the requirements and expectations of all stakeholders

Window handling can be done using various methods in programming.

• Use window handles to switch between multiple windows

• Use window functions to maximize, minimize or close a window

• Use window events to trigger actions based on user interaction

• Use window properties to get information about the window

Object Oriented Programming is a programming paradigm that organizes code into objects with properties and behaviors.

• Encourages modular and reusable code

• Focuses on data encapsulation and abstraction

• Supports inheritance and polymorphism

• Examples: Java, C++, Python

BI reports can be registered in ESS job by creating a new job and adding the report as a step.

• Create a new ESS job

• Add the BI report as a step in the job

• Configure the step with appropriate parameters

• Save and activate the job

Hybrid framework is a combination of multiple frameworks to leverage their strengths and overcome their weaknesses.

• Combines the benefits of modular, data-driven, and keyword-driven frameworks

• Allows for flexibility and scalability

• Can be used for both web and mobile applications

• Examples include Appium, Selenium, and TestNG

List is mutable, tuple is immutable in Python.

• List can be modified after creation, tuple cannot.

• List is defined using square brackets [], tuple using parentheses ().

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

Object-oriented programming concepts that focus on classes and objects

• Encapsulation: Bundling data and methods that operate on the data into a single unit (class)

• Inheritance: Allowing a class to inherit properties and behavior from another class

• Polymorphism: Ability for objects of different classes to respond to the same message in different ways

Polymorphism is the ability of a single function or method to operate on different data types. TestNG is a testing framework for Java.

• Polymorphism allows a method to behave differently based on the object it is called on.

• TestNG is a testing framework that simplifies the testing process and allows for easy configuration of test cases.

• TestNG Framework provides annotations like @Test, @BeforeMethod, @AfterMethod for test execution.

Spring and Spring Boot are popular Java frameworks used for building enterprise applications.

• Spring is a comprehensive framework that provides support for various functionalities like dependency injection, aspect-oriented programming, and transaction management.

• Spring Boot is an opinionated framework built on top of Spring, which simplifies the setup and configuration of Spring applications by providing defaults for common configurations.

• Spring Boot includes embedded servers ...read more

Java program to print words by ascending count value

• Create a HashMap to store word frequencies

• Iterate through the array of strings and update the frequencies in the HashMap

• Use a TreeMap to sort the HashMap by values in ascending order

• Print the words in ascending count value order

We are currently using the latest version of the RPA software.

• We always ensure that we are using the latest version to take advantage of the latest features and improvements.

• We also regularly evaluate other RPA software to ensure we are using the best tool for the job.

• For example, we recently evaluated UiPath and found it to be a good fit for a specific project.

Databases are used to store, manage, and retrieve large amounts of structured data efficiently.

• Databases provide a structured way to organize and store data.

• They allow for efficient data retrieval and manipulation.

• Databases ensure data integrity and consistency through data validation and constraints.

• They support concurrent access and provide security mechanisms to protect data.

• Databases enable data analysis and reporting through query capabilities.

• Examples of databases inclu...read more

Normalization is the process of organizing data in a database to eliminate redundancy and improve data integrity.

• Normalization helps in reducing data redundancy by breaking down data into smaller, logical tables.

• It ensures that each piece of data is stored only once, reducing storage space and improving efficiency.

• Normalization also helps in maintaining data integrity by preventing anomalies like update, insert, and delete anomalies.

• There are different levels of normalization...read more

To check if a string is a palindrome or not.

• Reverse the string and compare with the original string.

• Use two pointers, one at the start and one at the end, and compare the characters.

• Ignore spaces and punctuation marks while comparing the characters.

Agile is a methodology that emphasizes flexibility and collaboration. Scrum is a framework within Agile that focuses on iterative development.

• Agile values individuals and interactions over processes and tools

• Scrum involves daily stand-up meetings, sprint planning, and retrospectives

• Scrum roles include Product Owner, Scrum Master, and Development Team

• Scrum artifacts include the Product Backlog, Sprint Backlog, and Increment

• Scrum events include Sprint, Sprint Review, and Sprint...read more

Inheritance is a mechanism in object-oriented programming where a new class is created from an existing class.

• The new class, called the subclass, inherits properties and methods from the existing class, called the superclass.

• The subclass can also add new properties and methods or override existing ones.

• Inheritance promotes code reuse and allows for more efficient and organized programming.

• Example: A class Animal can be a superclass, and classes Dog and Cat can be subclasses t...read more

Applications are user-centric and packages are machine-centric.

• Applications are installed per user and can be targeted to specific user groups.

• Packages are installed per machine and can be targeted to specific device collections.

• Applications can have dependencies and requirements that must be met before installation.

• Packages can have pre and post installation scripts.

• Examples of applications are Microsoft Office, Adobe Creative Suite.

• Examples of packages are Windows updates, ...read more

Bean life cycle refers to the stages a Java bean goes through from creation to destruction.

• Bean is instantiated using a constructor or a factory method

• Bean properties are set using setters or dependency injection

• Bean is initialized using the init method

• Bean can be used for its intended purpose

• Bean is destroyed using the destroy method

IMSDB stands for Information Management System Database. It is a hierarchical database management system used for mainframe applications.

• IMSDB is a hierarchical database management system used on mainframe computers.

• It organizes data in a tree-like structure with parent-child relationships.

• IMSDB is commonly used in large organizations for handling high volumes of data efficiently.

• It is often used in conjunction with COBOL programming language for mainframe applications.

Java program to display unique characters in an array of strings

• Iterate through each string in the array

• Use a HashSet to keep track of unique characters

• For each character in the string, check if it is already in the HashSet and add it if not

Pointer is a variable that stores the memory address of another variable in C programming language.

• Pointers are used to manipulate data structures like arrays, linked lists, and trees.

• They are also used to pass arguments by reference to functions.

• Pointer arithmetic can be performed to access elements of an array.

• Null pointers are used to indicate that the pointer does not point to a valid memory location.

Maven is a build automation tool used primarily for Java projects to manage dependencies, build processes, and project configurations.

• Maven simplifies the build process by managing project dependencies and providing a consistent build system.

• It uses a Project Object Model (POM) file to define project structure, dependencies, and build configurations.

• Maven can automatically download required dependencies from repositories like Maven Central.

• It can generate project documentatio...read more

A Business Analyst (BA) will analyze business processes, identify areas for improvement, and recommend solutions to enhance efficiency and productivity.

• Analyze business processes

• Identify areas for improvement

• Recommend solutions to enhance efficiency and productivity

• Collaborate with stakeholders to gather requirements

• Create and maintain project documentation

• Facilitate communication between technical and non-technical teams

JCL (Job Control Language) is a scripting language used on IBM mainframe operating systems to instruct the system on how to run batch jobs.

• JCL is used to define and control the execution of programs in a batch environment.

• It specifies the input, output, and processing requirements for each job step.

• JCL statements are written in a specific format and are interpreted by the operating system.

• Example: //JOBNAME JOB (ACCOUNT), 'DESCRIPTION',CLASS=1,MSGCLASS=H

COBOL is a programming language used primarily for business, finance, and administrative systems.

• COBOL stands for Common Business-Oriented Language.

• It is known for its readability and self-documenting nature.

• COBOL is used in industries such as banking, insurance, and government.

• It is designed for processing large volumes of data efficiently.

• COBOL programs are typically structured into divisions, sections, and paragraphs.

Write a query

• Specify the database and table name

• List the columns to be selected

• Add any conditions or filters

• Specify the order of results

Analytics is the process of analyzing data to gain insights and make informed decisions.

• Analytics involves collecting, processing, and interpreting data

• It can be used in various fields such as business, healthcare, and sports

• Examples of analytics tools include Google Analytics, Tableau, and SAS

• Analytics can help identify patterns, trends, and opportunities for improvement

• It can also be used for predictive modeling and forecasting

db2 is a relational database management system developed by IBM.

• Developed by IBM

• Used for managing relational databases

• Supports SQL queries and commands

• Commonly used in mainframe environments

To include the htmlblock in AEM, use the cq:include tag in the component's JSP file.

• Use the cq:include tag in the component's JSP file to include the htmlblock.

• Specify the path to the htmlblock in the cq:include tag.

• Make sure the htmlblock is located in the appropriate location in the AEM repository.

Implement sorting algorithm without using inbuilt function

• Implement bubble sort algorithm

• Compare adjacent elements and swap if necessary

• Repeat until array is sorted

• Example: ['apple', 'banana', 'cherry'] -> ['apple', 'banana', 'cherry']

Time management involves setting priorities, creating a schedule, eliminating distractions, and staying organized.

• Set clear goals and prioritize tasks based on importance and deadlines

• Create a daily or weekly schedule to allocate time for each task

• Eliminate distractions such as social media, emails, or unnecessary meetings

• Use tools like calendars, to-do lists, and time tracking apps to stay organized

• Delegate tasks when possible to free up time for more important responsibilit...read more

Selenium is a popular automation testing tool used for web applications, while Core Java is a programming language commonly used for writing test scripts.

• Selenium is used for automating web browsers and testing web applications.

• Core Java is used for writing test scripts in Selenium due to its object-oriented programming features.

• Selenium WebDriver is a commonly used component for browser automation in Selenium.

• Core Java concepts like classes, objects, inheritance, and polymor...read more

A process is a series of steps or actions taken to achieve a particular goal or outcome.

• Processes can be found in various industries, such as manufacturing, healthcare, and finance.

• They can be documented and standardized to ensure consistency and efficiency.

• Process improvement methodologies, such as Six Sigma and Lean, can be used to optimize processes.

• Examples of processes include product development, patient care, and loan approval.

• Processes can involve multiple stakeholder...read more

Collections in Oracle are data structures that store and manipulate groups of data.

• Collections can be used to store data in arrays, lists, or sets.

• They can be used to pass data between PL/SQL blocks or between PL/SQL and SQL.

• Examples of collections include VARRAYs, nested tables, and associative arrays.

Partitions in Oracle are a way to divide a large table into smaller, more manageable pieces.

• Partitions allow for faster querying and maintenance of large tables

• They can be based on a range of values, a list of values, or a hash function

• Partitioning can be done on tables, indexes, and materialized views

• Examples of partitioning include partitioning by date, region, or customer ID

Deltek Maconomy is a niche technology used for project-based businesses to manage finances and resources.

• Deltek Maconomy is a specialized ERP software designed for project-based businesses.

• It helps in managing finances, resources, projects, and time tracking.

• Deltek Maconomy offers features like budgeting, forecasting, invoicing, and reporting.

• It is commonly used in industries like architecture, engineering, consulting, and advertising.

• The software provides real-time insights ...read more

BI report development involves several steps from data gathering to report deployment.

• Gather requirements from stakeholders

• Identify data sources and extract data

• Transform and clean data

• Design report layout and visualizations

• Develop report using BI tools

• Test and validate report

• Deploy report to production environment

Code to reverse a string in an array

• Iterate through each string in the array

• Use a loop to reverse each string character by character

• Store the reversed string in a new array

Repeatee is not a recognized term in the field of software testing.

Recursion is a process in which a function calls itself as a subroutine.

• Recursion involves breaking down a problem into smaller subproblems and solving them recursively.

• It is commonly used in programming to solve problems that can be broken down into smaller, similar problems.

• Examples of recursive algorithms include the Fibonacci sequence and binary search.

• Recursion can be a powerful tool, but it can also lead to performance issues if not used carefully.

An array is a collection of similar data types stored in contiguous memory locations.

• Arrays can be of any data type, including integers, floats, and objects.

• Arrays are accessed using an index, starting from 0.

• Arrays can be multidimensional, such as a 2D array.

• Example: string[] names = {"John", "Jane", "Bob"};

Performed various customizations to improve data analysis and reporting capabilities.

• Created custom dashboards to track key performance indicators

• Developed custom scripts to automate data extraction and processing

• Implemented custom data models to better analyze complex datasets

CAS stands for Columnstore Archive Storage in Azure SQL Database.

• CAS is a storage tier in Azure SQL Database that is optimized for cold data storage.

• It is designed to store large amounts of data that is infrequently accessed.

• CAS uses columnstore indexing to achieve high compression rates and reduce storage costs.

• Data can be moved to CAS using the ALTER TABLE command in SQL Server Management Studio.

• CAS is a cost-effective solution for storing historical data, backups, and arch...read more

Python is a high-level, interpreted programming language. Java is a general-purpose, class-based, object-oriented programming language.

• Python is known for its simplicity, readability, and ease of use.

• Java is known for its platform independence, security, and scalability.

• Python is commonly used for web development, data analysis, and artificial intelligence.

• Java is commonly used for enterprise applications, Android app development, and big data processing.

• Python uses indentati...read more

Inheritance is the process by which genetic information is passed from parent to offspring.

• Inheritance determines traits such as eye color, hair color, and blood type.

• Examples of inheritance include Mendelian inheritance patterns such as dominant and recessive traits.

• Inheritance can also involve genetic disorders passed down through generations.

An accumulator is a register that stores intermediate results of arithmetic and logical operations.

• Accumulators are commonly used in computer processors to perform arithmetic operations.

• They are also used in digital signal processing to store and manipulate signal data.

• Examples of accumulators include the ALU in a CPU and the integrator in a digital filter.

• Accumulators can be used to implement counters, timers, and other types of digital circuits.

Java threads are lightweight processes that enable concurrent execution of code.

• Threads allow multiple tasks to be executed simultaneously within a single program.

• They share the same memory space and can communicate with each other.

• Java provides built-in support for creating and managing threads through the Thread class.

• Threads can be created by extending the Thread class or implementing the Runnable interface.

• Thread synchronization is important to prevent race conditions and...read more

Automation scripts are written using programming languages to automate repetitive tasks in software testing.

• Choose a programming language and testing framework

• Identify the test cases to be automated

• Write code to execute the test cases

• Integrate with continuous integration tools

• Maintain and update the scripts as needed

RDBMS stands for Relational Database Management System, a type of database management system that stores data in a structured format.

• Organizes data into tables with rows and columns

• Uses SQL for querying and managing data

• Supports ACID properties for data consistency

• Examples: MySQL, Oracle Database, SQL Server

extraclientlib is used to include additional client-side libraries in AEM components.

• extraclientlib allows developers to include custom CSS and JavaScript files in AEM components.

• It helps in separating the presentation layer from the logic layer.

• Developers can define dependencies between client-side libraries using extraclientlib.

• It improves performance by loading only necessary resources for specific components.

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

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

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

• Java has built-in support for multithreading while C does not.

• Java has a larger standard library compared to C.

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

• C is faster than Java in terms of execution speed.

• C is commonly used for system...read more

Using cloud offers scalability, cost savings, flexibility, and improved collaboration.

• Scalability: Easily scale resources up or down based on demand.

• Cost savings: Eliminate the need for expensive hardware and maintenance.

• Flexibility: Access data and applications from anywhere with an internet connection.

• Improved collaboration: Teams can work together in real-time on shared documents.

• Disaster recovery: Data is securely stored off-site, reducing the risk of data loss.

• Automatic ...read more

Search in Google

• Open a web browser

• Go to www.google.com

• Type in the search query

• Press enter or click on the search button

• Browse through the search results