## Technical Ques: 13.

OSI Model - Open Systems Interconnection Model - 7

1. Loops are used to execute a block of code repeatedly as long as > Physical Layer - connections
certain condition is met. > Data Link Layer - data transfer
> python - (for loop, while loop) > Network Layer - routing
> java - (for loop, while, do-while) > Transport Layer - communication
> Session Layer - sessions
2. SQL - Manage User Permissions > Presentation Layer - encryption, formatting
grant - used to give specific privileges to users > Application Layer - services
revoke - used to remove previously granted privileges from users
14. SDLC (Software Development Life Cycle) - 6
3. Arrays in > a process used to design, develop, test and deploy software
> Python - list data type is used applications
> Java - need to specify the type of elements the array will hold > Requirement Gathering, System Design, Implementation, Testing,
Deployment, Maintenance
4. MERN Stack > Methodologies: agile, scrum, waterfall
MongoDB - Database
Express.js - Web App Framework 15.
React - Frontend Library > IPv4 - internet protocol version 4 - 32-bit address (192.168.1.1) - 4
Node.js - Runtime Environment > IPv6 - internet protocol version 6 - 128-bit address (2001:0db8:...) - 8

5. API 16. CRUD operations in Database: fundamental operations for

Application Programming Interface is a set of rules and protocols that interacting to databases
allows di erent software applications to communicate with each > create - insert into tablename (col1,col2..) values (v1,v2..)
other. > read - select * from tablename;
> update - update
6. Pillars of OOPs > delete - delete
> Abstraction - hiding unnecessary data
> Encapsulation - binding objects 17. Keys in SQL - 6 : used to establish relationships between tables
> Inheritance - properties inherited from parent class to child class > super key - single key or group of keys for identifying a row in a table
> Polymorphism - many forms, same class but di erent parameters > candidate key - minimal super key
> primary key - uniquely identifies each record in a table
7. Github/Git > foreign key - creating a link between two tables
> Git - version control system used to track changes in source code > unique key - used to avoid duplicates
during software development > composite key - multiple columns used together for identifying the
> Github - web based hosting service for git repositories records.

some git commands: 18.

> git clone <repo_url> Table - collection of data organized into rows and columns.
> git status : displays info about which files are ready to be committed Schema - collection of database objects including tables, indexes,
> git commit - m "message" constraints
> git add <file_name> or . : staging the file changes for commit
## Resume-based Ques:
8. 1. AWS: worked on cloud services like
DDL - Data Definition Language : create, alter, drop, truncate, rename > EC2 - elastic compute cloud - for creating instances (virtual
DML - Data Manipulation Language : select, insert, update, delete machines)
> S3 - simple storage service - for storing & retrieving data from
9. anywhere on the web
Delete - remove rows from a table
> delete from students where sid=101; 2. Linux commands:
> ls - lists directory contens
Truncate - remove all rows from a table > cd - changes the current directory
> truncate table students; > pwd - display the current working directory
> mkdir - create a new folder
Drop - remove database objects (tables, constraints) entirely from > rm - remove files
database > cp - copy files
> drop table students; > mv - move files
> sudo su - switching to root user account for admin privileges
10. Read/Write operations in java
> Console Input/Output: 3. Web scraping:
Scanner class (input) > extracting data from websites using python library "beautifulsoup"
System.out.println() (output) > pandas for handling and storing data in a CSV format
> requests for fetching web pages
11. Multiple Inheritance in java: NO
> Java does not support multiple inheritance of classes. 4. SEO : search engine optimization
> due to ambiguity in the inheritance hierarchy > improving website's visibility
> interfaces are used to avoid this diamond problem > ranking in search engine result pages

12. some methods-

Method Overloading - in java allows a class to have more than one > identifying relevant keywords
method with same name but di erent parameters > optimizing content
Method Overriding - in java allows a subclass to provide specific > improving site loading time
implementation of a method that is already provided by its superclass > compressing image
5. Machine Learning: branch of AI and CS for building computer 14. ACID properties:
systems that can learn from data.
ACID properties ensure transactions in databases are Atomic,
> Supervised learning - algorithm learns form labelled data to predict Consistent, Isolated, and Durable.
outcomes. A means transaction should successfully complete
Eg. Logistic Regression, Decision Tree, Random Forest C means remains in consistent state
I means each transaction should be isolated from other util completed
> Unsupervised learning - algorithm learns from unlabelled data for D means changes made by transaction are permanently stored in
identifying patterns. system even if a system failure occurs
Eg. K-Means Clustering
## Intro
## HR+MR Good Morning Sir/Mam,
1. Strength/Weakness
> i am quick learner and collaborative. As for weakness, Thank you for giving me this opportunity.

2. Why do you want to join TCS ? Myself Abhishek Krishna, and I am from Gaya, Bihar.
> because it is considered as a well-known and respectful brand in our
society. I had recently completed my BTech degree in CSE branch with
> and also because of numerous projects tcs have which is an adv for Specialization in Data Science from VIT Vellore with an aggregate of
me to learn di erent technologies. 7.66 cgpa.

3. About TCS My technical skills include Java, HTML/CSS, MySQL, MS-O ice,
> TCS is an Indian MNC IT service and consulting company. Tableau, Python.
> subsidiary of Tata Group
> CEO - K. Krithivasan (June 2023) I have done projects in Machine Learning, Web Scraping and also
> Founder - J.R.D Tata && Faquir Chand Kohli worked with Data Visualization tools like Tableau for dashboard
> Headquarter - Mumbai analysis.
> No. of emp - 6 lakhs (March 2024)
I am also familiar with Linux, Search Engine Optimization (SEO)
4. Any ques Methodology, AWS Services such as EC2 (Elastic Compute Cloud) & S3
> yes, what will be the time period of training and if i am selected, what (Simple Storage Service).
technologies should i equipped before joining TCS for training.
My hobbies are playing Badminton & Online Video Games
5. Role in your project
> My final academic project was "fake news detection using ML and So, that's all about me.
NLP techniques"
> my roles were to create a frontend webpage and data preprocessing ## My Project:
Flipkart Web Scraping:
6. challenges faced in project I used a beautifulsoup python package for extracting data from website
> we wanted to create a novelty by implementing an extension for and stored in csv file
automating the process in our project.
Data Science Jobs-Salaries Dashboard:
7. Why should we hire you ? I created a dashboard using Tableau to visualize data science jobs-
> As a fresher, i have no experience but have the ability to learn new salaries based on location, experience & job role
things quickly.
> If you provide this opportunity to me.i will be working with full Fake News Detection:
e iciency and getting work done withing the given period of time. In my final year, i have done this project. Its a web application for
> I have the potential to deliver good results detecting fake news from real ones using NLP and ML. We used TF-IDF,
Topic Modeling & Word Embedding for NLP and Passive Aggressive
8. shift work Classifier for ML. My roles on this project are preprocessing the data
> i am flexible and i dont have a complaint with shift work or working at using NLP techniques, and also creating a frontend page.
night.

9. hard work - work more time to get a good result, it gives experience
> smart work - work less time, it comes from experience

10. GDP of india ranking 2024 - 136th

11. How do you see yourself in next 5 years

> In the next five years, I see myself taking on increasing
responsibilities within the company and contributing to its growth

12. Hobbies
> my hobbies are playing online video games and badminton

13. Gap Year: 2017-2018 [ 1 Year : Su ured Jaundice]

> I was su ering from Jaundice during the session 2017-2018 and
couldn't take admission for Intermediate 11th. So, I opted for the same
in 2018.
> 01/04/2017 - 31/03/2018