@ perplexity Categorized and Sorted TCS Interview Questions (Ninja, Digital, Prime) Below is a categorized and sorted structure of interview questions from the provided PDF, C, Java, DBMS, and organized by Profile (Ninja, Digital, Prime) and further divided into subjects: Behavioural, Ninja * Right the reverse string in C, Java, Python write in all 3 languages, * Fibonacci number in C and line by line discussion regarding syntax * Structure pointer concept in CL. * Pattern diamond inverted triangle. * Star triangle pattern codelll. «Print ASCII value of your namel * Explain and implement Binary search (Diagram), * Can we implement Binary search if there are two same elements! * How Binary search can be implemented in DBMS! * Write a code to check primelll * Write code for diamond pattern. Java * How Java does multiple inheritance, * Differences between abstract class and interface! * What is runtime polymorphism and compile time polymorphism, * Operator precedence (calculative question) * Code of string printing and reverse * Java and C difference! «Java types of inheritance diagram explain. * Print your name in Javall. © What is recursion. + What is method overloading! * What is polymorphism? Give real life example of polymorphism”* Constructor overloading 1. * Questions from Java based inheritance + Limitations of Javalll + Java code snippet with pre and post increment * Java code snippet on type casting. * Abstract and interface differencell, Dems * DBMS vs RDBMS. * Foreign key vs composite key, * Foreign key can be null or not“. * SQL query: two tables, student and dept. Find the student name and dept name where students address is Sodepur and dept not ECE. * SQL query to print names ending with ‘it’ in an employee table! = What is offset in SQL. * Alltypes of joins! * Order of execution in select statement/, * Why self join used, give with example. + Normalization and its types! * Unique and Unique att * Indexing, Joining in SQL. * Join, intersection“, * Left and right outer join!, * Two query using where clause and update and find. * 2nd minimum marks (SQL query). * Vin diagram of left outer join“. * Can we use aggregate function in subquery. + vemsil * Types of DBMS. * Name two relational and not relational DBMS“. * Primary key and relation with indexing DBMS“. * Give a parent db with dependent child db, write a query to delete an entry from all of them simultaneously“.Behavioural * Introduce yourself + Tell me something that is not in your resumeL, * Why Tos. * Are you comfortable for any shift. * Hobby discussion. * Tellme about Tes. + Snames of Tata group, * Long-term goat * Did you give Cognizant exam on campus! * If you got another offer off campus with higher package then what will you do! + How do you handle pressure! ‘© Hardship faced in life! * Relocation/night shift. * Where do you live, * Who do you have in your family * What does your mother do for a living. * Which type of books do you read/l * Any Bengali writer? Name them, + Any modem day writer? Whol * What's your favourite social media“t. * Why don't you have social media. * Have you given any interview before * Are you ready for relocationtl. * Are you comfortable with 2 yrs bond, * Why from Maths Hons to MCALL. * Why IT field when from ECE background! * Family background. * Flexible to night shift“. * Where do you stay! * Why that place is famous forlll ‘* Nightshift problem“. + How did you manage your team! * What is your role.* How do you handle work life with your family 1 * Scenario-based questions! * Team management! Digital + Merge sort algorithm description along with implementation Lt * Star triangle pattern, * Structure pointer concept in cl. « Pattern diamond inverted trianglelil * Array, array list difference! * ArrayList syntax, add to ArrayList, * Fibonacci number in C and line by line discussion regarding syntax Java * Inheritance * Exception handling. * Pseudo code from implicit explicit type casting 1, * One recursive function for magic numberlil * Java code snippet with pre and post increment“, * Java code snippet on type casting * Hash map conceptil + Types of inheritance, diagram explainit © What is view, trigger“, * Thread, multithreading. * Abstraction, example! + Try-catch-finally syntax, * Throw, why used {1 * What is the use of static 1 + Is it necessary to use static keyword in public static void main(String args{]) 4DBMS + ppms!l ‘* Two query using where clause and update and find“. * Joining concepts, SQL all join codes! + Normalization all forms, only theory! + Primary key, foreign key. * Difference between delete and truncate“ * SQL update query, * 9th max salary in a table (with both limit and subquery) * Types of DpMsi. * Name two relational and not relational DBMS“. * Order of execution in select statement! = What is compiler? What is the use of compiler in Java? What are compile time errors“. * Improvements in Oracle 21¢ compared to previous versions“, * If you are the SYSDBA of a database and you have to create a username, password, provide permissions to four of your friends, how will you do it in LINUX, * How will you login as the SYSDBA1. * What type of language is Cl) + What is the difference between compiler and JDK“, + What is encryption! * Which pillar of OOP is used for encryption * What is microservices? (Explanation with drawing). * Which technique do you use to manage traffic in a server? (Explanation with drawing), Behavioural * Introduction 4. « Hobby related questionsl + Family membersttl © Why Tosi. * Why select you among all of us! * How do you get good marks in 10th and 12thill * Questions from hobby (e.g., chess), * Relocation, night shift, © Why not placed till owl + Hardship faced in lifelll,* How do you handle pressure! * How do you handle work life with your family { * Why you don't get job anywherelll, + What was the problem with your last interview! * Are you willing to relocate, * Willing to work night shift, * Are you comfortable for night shift {1 * Are you available for relocation! * Any questions for melt * What will you do with your first salary“. * Team management, scenario-based questions! * Approach to lead a team, * SDLC model, Waterfall model * Network topology and types! + Document verification Lt * HR questions! Prime * Reverse string without any inbuilt method {1 « Can you write other methods to reverse string * Make a search binary treelll * Reverse a string * Pattern printinglll, * Code to find if a number is power of 2 or not tl * Quick sort explanation with algorithm 4. * Math question y=mx+clll, Java * You said you know Java, say what is class and object + What is instance variable. + What if | don't want every instance to have a copy of the variable. How can I achieve it * Can we have private constructors! ‘= What is the use of private constructorsi+ What if | don't want to initialise any instance variable in constructors and do something elselil + What is the constructor with no parameters called, * What is the default constructor, * What is dynamic method dispatch in Java ll * Questions from run time and compile time polymorphism {1 + What is cross joint, * Do you know try resources + How do you trace where an error is coming from a project with lots of packages and lots of classes in each package, * Static keywords! + Explain public, protected. * Do you know any technology like cloud, Al ML, Blockchainl, * Difference between Java and C++ = What is JDK. DBMS * SQL query: retrieve Manager ID with Employee ID * SQL query with joins“. * SQL query to count all employees! * SQL query to update Gmail from @gmail to @yahoo * SQL query to name ending with “it”, * PL/SQL trigger question, * Difference between foreign key and composite key! + pamsil, * DBMS vs RDBMS. * Foreign key vs composite key. * Foreign key can be null or not“. * Candidate Key, * Write a SQL Query to get the 2nd highest score, * What's the reason you used DISTINCT. + What we have to use with group by.Behavioural * Tellme about yourself + Introduction + About your project and your role * Rate yourself to your project * My education gap! * Preferred programming language and rate yourself, = Whi in tes, h role you want * If there is no role left which you want, then what do you do! * What do you know about Tosi. * Why join Tes, + Why should we hire youll * Are you okay with night shifts and Saturday Sunday shifts". * Are you aware TCS holds a background check“, * Are you okay with relocation, * Are you aware that there is a one year service agreement of 150004. * What will you do if we hire you for Ninja“. * What would you do if you are not selected here“. * If you got rejected again what would you doll * Asked the name of the CEO of Tcsil * Asked about project, * Asked to create a table using HTML. * Are you available for relocation * Who are there in your family * Are you comfortable for night shift. * Any gap or backlog * Are you willing to reallocate! + What will you buy with your first salary if you're selected and why, Note: If you require the output as a downloadable PDF, please specify, and | will provide the categorized content in a format ready for PDF export, * 1. [Link]