TCS
60+ A3 Global Marketing & Education Interview Questions and Answers
Q1. Pair Sum Problem Statement
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Note:
Each pa...read more
Q2. Minimum Number of Platforms Needed Problem Statement
You are given the arrival and departure times of N trains at a railway station for a particular day. Your task is to determine the minimum number of platform...read more
Q3. Prime Time Again Problem Statement
You are given two integers DAY_HOURS and PARTS. Consider a day with DAY_HOURS hours, which can be divided into PARTS equal parts. Your task is to determine the total instances...read more
Q4. Constellation Identification Problem
Given a matrix named UNIVERSE with 3 rows and 'N' columns, filled with characters {#, *, .}, where:
- '*' represents stars.
- '.' represents empty space.
- '#' represents a separ...read more
Q5. Search an Element in a Sorted Array
Given a sorted array 'A' of 'N' integers, determine whether a number 'X' exists within this array for a series of queries. For each query, print 1 if 'X' exists in the array,...read more
Q6. Chocolate Distribution Problem
You are given an array/list CHOCOLATES of size 'N', where each element represents the number of chocolates in a packet. Your task is to distribute these chocolates among 'M' stude...read more
Q7. Linked List Value Search Problem Statement
Given a Singly Linked List of integers accessible via a head pointer, where each node contains a specific integer value. You are required to determine if a node with a...read more
Q8. Difference between DELETE, DROP and TRUNCATE command in DBMS. What is RDBMS? [Read about it from any trusted website such as GeeksForGeeks].
Explanation of DELETE, DROP and TRUNCATE commands in DBMS and definition of RDBMS.
DELETE command removes specific rows from a table.
DROP command removes an entire table from the database.
TRUNCATE command removes all rows from a table.
RDBMS stands for Relational Database Management System.
It is a type of DBMS that stores data in the form of tables with relationships between them.
Q9. Minimise Sum Problem Statement
You are given a matrix of 'N' rows and 'M' columns and a non-negative integer 'K'. Determine the minimum possible sum of all elements in each submatrix after performing at most 'K...read more
Q10. What is oops concept in java
Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.
OOP is based on the concept of classes and objects.
It focuses on encapsulation, inheritance, and polymorphism.
Encapsulation hides the internal details of an object and provides a public interface.
Inheritance allows classes to inherit properties and behaviors from other classes.
Polymorphism allows objects of different classes to be treated as objects of a common super...read more
Q11. What is html java script
HTML is a markup language used for creating web pages, while JavaScript is a programming language used for adding interactivity to web pages.
HTML is used for structuring content on web pages
JavaScript is used for adding interactivity and dynamic behavior to web pages
HTML is not a programming language, but JavaScript is
Example: <html><head><title>Example</title></head><body><script>document.getElementById('demo').innerHTML = 'Hello World!';</script><p id='demo'></p></body></ht...read more
Q12. What fullstack developer
A fullstack developer is a software engineer who is proficient in both frontend and backend development.
A fullstack developer has knowledge and skills in both frontend technologies (HTML, CSS, JavaScript) and backend technologies (server-side languages, databases).
They are capable of working on all aspects of a software project, from designing and implementing user interfaces to developing server-side logic and managing databases.
Fullstack developers are versatile and can han...read more
Q13. How to show ip address in html
Use JavaScript to display the user's IP address on an HTML page.
Use JavaScript to fetch the user's IP address
Create a HTML element to display the IP address
Insert the fetched IP address into the HTML element
Q14. What is python in data science
Python is a popular programming language used in data science for its simplicity and extensive libraries.
Python is widely used in data science due to its easy syntax and readability.
It has a rich ecosystem of libraries like NumPy, Pandas, and Matplotlib for data manipulation, analysis, and visualization.
Python's machine learning libraries like scikit-learn and TensorFlow make it a powerful tool for building predictive models.
It supports integration with other languages like R...read more
Q15. What is c code in java
C code in Java refers to the use of the Java Native Interface (JNI) to incorporate C code into Java programs.
C code in Java is typically used when performance optimization or low-level system access is required.
JNI allows Java programs to call C functions and use C libraries.
C code can be written separately and compiled into a shared library, which is then loaded and used by Java code.
JNI provides a way to pass data between Java and C, handle exceptions, and manage memory.
Exa...read more
Q16. What is a jpeg in html
JPEG is a file format commonly used for images on the web.
JPEG stands for Joint Photographic Experts Group.
It is a lossy compression format, meaning some image quality is sacrificed to reduce file size.
JPEG files typically have a .jpg or .jpeg file extension.
They are widely supported by web browsers and image editing software.
Q17. What does Ds mean in sql
DS stands for Data Source in SQL.
DS is used to refer to the location or provider of data in SQL.
It can be a database, a file, or any other source of data.
DS is often used in connection strings to specify the data source.
For example, in JDBC, the DS can be specified as 'jdbc:mysql://localhost:3306/mydatabase'.
Q18. What is the language R for
R is a programming language and software environment for statistical computing and graphics.
R is used for statistical analysis, data visualization, and machine learning.
It provides a wide range of statistical and graphical techniques.
R has a large number of packages and libraries available for various data analysis tasks.
It is widely used in academia, research, and industries for data analysis and research purposes.
Q19. What is php and its work
PHP is a server-side scripting language used for web development.
PHP stands for Hypertext Preprocessor.
It is widely used for creating dynamic web pages and web applications.
PHP code is embedded within HTML code and executed on the server.
It can interact with databases, handle form data, and perform various server-side tasks.
PHP is open-source and has a large community of developers.
Example:
Q20. What type of language is php
PHP is a server-side scripting language primarily used for web development.
PHP stands for Hypertext Preprocessor.
It is an open-source language.
PHP is embedded within HTML code.
It is used to create dynamic web pages and interact with databases.
Popular frameworks built with PHP include Laravel, Symfony, and CodeIgniter.
Q21. What is dbms used for
DBMS is used to manage and organize large amounts of data efficiently.
DBMS stands for Database Management System.
It provides a structured way to store, retrieve, and manipulate data.
DBMS ensures data integrity, security, and concurrency control.
It allows multiple users to access and modify the data simultaneously.
Examples of DBMS include MySQL, Oracle, SQL Server, and PostgreSQL.
Q22. How to create basic html
Basic HTML can be created using simple tags and attributes.
Start with the <html> tag to define the document
Use <head> for meta information and <title> for the title of the page
Body content goes inside the <body> tag
Use tags like <h1> for headings, <p> for paragraphs, <a> for links, etc.
Attributes like src, href, alt can be used to specify sources and alternative text
Q23. What is the difference between drop and delete in SQL?
Drop removes a table from the database while delete removes specific rows from a table.
DROP is a DDL (Data Definition Language) command used to remove a table and its data from the database.
DELETE is a DML (Data Manipulation Language) command used to remove specific rows from a table based on a condition.
DROP command is irreversible and all the data in the table is lost, while DELETE can be rolled back if used within a transaction.
Example: DROP TABLE TableName; DELETE FROM Ta...read more
Q24. 1. String program (abc@123) convert to abc, @, 123 2. Core Java - collection, string, OOP 3. API testing basic
Questions on string manipulation, core Java concepts, and API testing basics for Associate Software Engineer role.
For the first question, split the string using the '@' symbol as the delimiter.
Core Java concepts include collections, strings, and OOP principles.
API testing basics involve understanding HTTP methods, status codes, and request/response formats.
Q25. What is oops in Linux
OOPS in Linux refers to Object-Oriented Programming System, which is a programming paradigm that uses objects to represent data and methods.
OOPS in Linux is based on the principles of encapsulation, inheritance, and polymorphism.
It allows for modular and reusable code by organizing data and functions into objects.
OOPS in Linux is implemented through various programming languages like C++, Java, and Python.
It helps in improving code readability, maintainability, and scalabilit...read more
Q26. Why do we use database
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
Q27. What is basic web development
Basic web development involves creating and maintaining websites using HTML, CSS, and JavaScript.
Basic web development includes creating web pages using HTML, CSS, and JavaScript.
It involves structuring the content of a website using HTML.
CSS is used to style and format the web pages.
JavaScript is used to add interactivity and dynamic features to the website.
Web development also includes knowledge of web servers, databases, and frameworks.
Examples of basic web development tas...read more
Q28. What is inheritence in jav
Inheritance in Java allows a class to inherit properties and methods from another class.
Inheritance is a fundamental concept in object-oriented programming.
It promotes code reusability and allows for the creation of hierarchical relationships between classes.
The class that is being inherited from is called the superclass or parent class, while the class inheriting is called the subclass or child class.
The subclass can access the public and protected members of the superclass....read more
Q29. What is python fullstack
Python fullstack refers to using Python for both frontend and backend development in a web application.
Python fullstack involves using Python frameworks like Django or Flask for backend development.
It also involves using Python libraries like Flask or Django templates for frontend development.
Python fullstack developers have expertise in both frontend and backend technologies.
Examples of Python fullstack frameworks include Django, Flask, and Pyramid.
Q30. Front end or backend, which one is better?
Both front end and backend are important in software development, each serving different purposes.
Front end is responsible for the user interface and user experience, while backend handles the server-side logic and database operations.
Front end technologies include HTML, CSS, and JavaScript, while backend technologies include languages like Java, Python, and databases like MySQL.
The choice between front end and backend depends on individual preferences, skills, and career goa...read more
Q31. Types of DBMS Languages
DBMS languages include data definition, manipulation, and control languages.
Data Definition Language (DDL) - used to define the database schema and structure
Data Manipulation Language (DML) - used to manipulate data within the database
Data Control Language (DCL) - used to control access to the database
Examples include SQL, Oracle PL/SQL, and Microsoft T-SQL
Q32. What are the different commands in SQL?
SQL commands are used to interact with databases and perform various operations like querying, updating, and deleting data.
SELECT - retrieves data from a database
INSERT - adds new data to a database
UPDATE - modifies existing data in a database
DELETE - removes data from a database
CREATE - creates a new database or table
ALTER - modifies the structure of a database object
DROP - deletes a database object
JOIN - combines rows from two or more tables based on a related column
WHERE -...read more
Q33. How to run a maven or gradle project?
To run a Maven or Gradle project, use the respective build tools commands in the project directory.
For Maven project, use 'mvn clean install' to build and install the project.
For Gradle project, use 'gradle build' to build the project.
Make sure you have the necessary dependencies and plugins configured in the project's pom.xml (for Maven) or build.gradle (for Gradle) files.
You can also run specific goals or tasks using Maven or Gradle commands based on the project requirement...read more
Q34. why tcs and what is its unique features?
TCS is a global IT services company known for its innovative solutions and commitment to excellence.
TCS is one of the largest IT services companies in the world, with a strong global presence.
TCS is known for its focus on innovation and research, constantly developing new technologies and solutions.
TCS has a strong commitment to excellence and customer satisfaction, ensuring high-quality services.
TCS has a diverse range of services, including consulting, digital solutions, an...read more
Q35. what are the types of sql languages
Types of SQL languages include DDL, DML, DCL, and TCL.
Data Definition Language (DDL) - used to define and modify the structure of database objects (CREATE, ALTER, DROP)
Data Manipulation Language (DML) - used to manipulate data within database objects (SELECT, INSERT, UPDATE, DELETE)
Data Control Language (DCL) - used to control access to data within the database (GRANT, REVOKE)
Transaction Control Language (TCL) - used to manage transactions within the database (COMMIT, ROLLBAC...read more
Q36. Way to declare a variables in javascript?
Variables in JavaScript can be declared using var, let, or const keywords.
Use 'var' keyword for declaring variables with function scope.
Use 'let' keyword for declaring variables with block scope.
Use 'const' keyword for declaring constants with block scope.
Variables in JavaScript are dynamically typed, meaning they can hold any type of value.
Q37. How many rounds in tcs?
There are typically multiple rounds in the TCS interview process.
The number of rounds in TCS interviews can vary depending on the position and level of the role.
Common rounds include technical interviews, HR interviews, and sometimes coding tests or group discussions.
TCS may also conduct multiple rounds of interviews to assess different skills and competencies.
The exact number of rounds can be determined by the TCS recruitment team during the hiring process.
Q38. Will you be able to locate to base location
Yes, I am willing to relocate to the base location for the Associate Software Engineer position.
I am open to relocating for the right opportunity
I understand the importance of being flexible in the tech industry
I have relocated for previous job opportunities and have had positive experiences
Q39. Features of oops and method overloading
OOPs features include encapsulation, inheritance, polymorphism, and abstraction. Method overloading allows multiple methods with the same name but different parameters.
OOPs features: encapsulation, inheritance, polymorphism, abstraction
Method overloading: multiple methods with same name but different parameters
Example: void print(int a), void print(int a, int b)
Q40. Introduction Company policies Location preferences
The interviewer is asking about the candidate's introduction, company policies, and location preferences.
Introduce yourself briefly, highlighting your relevant experience and skills.
Discuss any previous experience with company policies and how you have adhered to them.
Share your preferences for work location, considering factors like commute, cost of living, and work-life balance.
Q41. what is fullform of ansi
American National Standards Institute
ANSI stands for American National Standards Institute
It is a private non-profit organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States
ANSI works to ensure that standards are developed in an open and transparent manner, with input from all stakeholders
Standards developed by ANSI cover a wide range of industries, including technology, healthca...read more
Q42. Write code for pattern?
Code for pattern
Determine the pattern to be created
Use loops and conditional statements to generate the pattern
Test the code with different inputs to ensure correctness
Q43. Wt is Java,Oops concepts, collections
Java is a popular programming language known for its object-oriented programming features. OOPs concepts include inheritance, polymorphism, encapsulation, and abstraction. Collections are data structures used to store and manipulate groups of objects.
Java is a high-level, class-based, object-oriented programming language.
OOPs concepts in Java include inheritance, polymorphism, encapsulation, and abstraction.
Collections in Java are data structures like ArrayList, LinkedList, H...read more
Q44. Whay do you mean by acid property
ACID properties are a set of properties that guarantee that database transactions are processed reliably.
ACID stands for Atomicity, Consistency, Isolation, Durability
Atomicity ensures that all operations in a transaction are completed successfully or none at all
Consistency ensures that the database remains in a consistent state before and after the transaction
Isolation ensures that multiple transactions can be executed concurrently without affecting each other
Durability ensur...read more
Q45. Bubble and merge sort algorithm
Bubble sort repeatedly swaps adjacent elements if they are in wrong order. Merge sort divides the array into two halves and sorts them recursively.
Bubble sort has a time complexity of O(n^2) and is not efficient for large datasets.
Merge sort has a time complexity of O(n log n) and is efficient for large datasets.
Bubble sort is easy to implement and requires less memory than merge sort.
Merge sort is a stable sorting algorithm, meaning it maintains the relative order of equal e...read more
Q46. Explain any of the algorithm with code
Explanation of the Bubble Sort algorithm with code
Bubble Sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
Example code in Python: def bubble_sort(arr): n = len(arr) for i in range(n): for j in range(0, n-i-1): if arr[j] > arr[j+1]: arr[j], arr[j+1] = arr[j+1], arr[j]
The algorithm has a time complexity of O(n^2) in the worst case scenario.
Bubble Sort is not efficient for large d...read more
Q47. what is dbms linux commands dsa
DBMS stands for Database Management System. It is a software that manages databases, allowing users to store, retrieve, and manipulate data.
DBMS is used to create, manage, and manipulate databases.
It provides an interface for users to interact with the database.
DBMS ensures data integrity, security, and efficient data retrieval.
Examples of popular DBMS include MySQL, Oracle, and SQL Server.
Q48. What is web development
Web development is the process of creating websites and web applications using programming languages, frameworks, and tools.
Involves writing code in languages like HTML, CSS, and JavaScript
Utilizes frameworks like React, Angular, or Vue.js for front-end development
Backend development involves using languages like Node.js, Python, or PHP
Database management with tools like MySQL, MongoDB, or PostgreSQL
Testing and debugging to ensure functionality and performance
Deployment and m...read more
Q49. What are arrays in python
Arrays in Python are ordered collections of elements of the same data type, accessed by index.
Arrays in Python are created using square brackets []
Elements in an array can be accessed using their index, starting from 0
Example: names = ['Alice', 'Bob', 'Charlie']
Q50. Any backlogs
No backlogs
I have completed all my courses and projects on time
I have no pending assignments or exams
I have a good academic record with no failed subjects
Q51. What is database
A database is a collection of data that is organized and stored for easy access and retrieval.
A database is used to store and manage data.
It can be used to store various types of data such as text, images, videos, etc.
Data can be easily retrieved and manipulated using queries.
Examples of databases include MySQL, Oracle, MongoDB, etc.
Q52. Joins in DBMS
Joins are used to combine data from two or more tables based on a related column.
Joins are used in relational databases to retrieve data from multiple tables.
There are different types of joins such as inner join, left join, right join, and full outer join.
The join condition is specified using the ON keyword and the related columns.
Joins can be used to combine data from tables with a one-to-one, one-to-many, or many-to-many relationship.
Joins can be expensive in terms of perfo...read more
Q53. What is closure?
Closure is a function that has access to its own scope, as well as the scope in which it was defined.
Closure allows a function to access variables from an outer function even after the outer function has finished executing.
It helps in maintaining state in asynchronous operations.
Example: function outerFunction() { let outerVar = 'I am outer'; return function innerFunction() { console.log(outerVar); }; }
Q54. explain DDL, DML, DQL
DDL is used to define the structure of database objects, DML is used to manipulate data, and DQL is used to retrieve data.
DDL (Data Definition Language) is used to define the structure of database objects like tables, indexes, etc.
DML (Data Manipulation Language) is used to manipulate data in the database like inserting, updating, deleting records.
DQL (Data Query Language) is used to retrieve data from the database using queries like SELECT.
Q55. Explain Project briefly
Developed a web-based project management tool for tracking tasks and deadlines
Used HTML, CSS, and JavaScript for front-end development
Implemented backend functionality using Node.js and MongoDB
Incorporated user authentication and authorization features
Utilized Agile methodology for project management
Q56. Data types in C++
Data types in C++ include int, float, double, char, bool, and more.
int - used for integers
float - used for floating point numbers
double - used for double precision floating point numbers
char - used for characters
bool - used for boolean values
Examples: int age = 25; float price = 3.99; char letter = 'a';
Q57. Inheritance in c++
Inheritance is a mechanism in C++ where a class can inherit properties of another class.
Inheritance allows for code reuse and promotes modularity.
The derived class inherits all the members (except constructors and destructors) of the base class.
There are three types of inheritance: public, private, and protected.
Example: class Car is derived from class Vehicle.
Example: class SportsCar is derived from class Car.
Q58. Explain OOPS concept
OOPS (Object-Oriented Programming) 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 problems
Key principles include encapsulation, inheritance, polymorphism, and abstraction
Encapsulation involves bundling data and methods that operate on the data into a single unit
Inheritance allows new classes to be created based on existing classes
Polymorphism enables objects to ...read more
Q59. Pointer in java
Pointer in Java is a variable that stores the memory address of another variable.
Pointers are used to access and manipulate memory locations directly.
They are not used in Java directly, but references serve a similar purpose.
Example: int x = 10; int *ptr = &x; // ptr now stores the memory address of x
Q60. Write a code in Java
Code in Java to reverse a string
Use StringBuilder to reverse the string efficiently
Convert the string to StringBuilder, call reverse() method, then convert back to string
More about working at TCS
Top HR Questions asked in A3 Global Marketing & Education
Interview Process at A3 Global Marketing & Education
Top Associate Software Engineer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
