System Analyst Interview Questions

7,597 system analyst interview questions shared by candidates

1) In simple terms, explain what is Blockchain Technology. 2) Is Bitcoin a part of Blockchain or vice versa? 3) What is AI, ML and Deep Learning? 4) What is Big Data Analytics? 5) Explain Exception Handling with an example. 6) What is the use of “finally” block in exception handling? 7) Explain the pillars of object oriented programming namely abstraction, encapsulation, polymorphism and inheritance. 8) Explain Overloading and Overriding. 9) What is Final? 10) Difference between JDK and JRE. 11) What is JVM? 12) Name various data types in Java. 13) Why multiple inheritance is not there in Java? 14) Why pointers are not there in Java? 15) What is Static variable and method in Java? 16) Can you overload the main method? 17) What kind of errors are there in Java? 18) What are the advantages of Java? 19) Name some errors and exceptions? 20) What is the super class of Exception? 21) What is the super class of Throwable? 22) What are ACID properties? 23) What are transactions in databases? 24) What is linked list? 25) Detection and removal of a loop in linked list. 26) Difference between call by value and call by reference. 27) Why do we use R? 28) How can we use R to predict something? 29) What are the advantages of R? 30) What happens after you enter the URL of a website? 31) What is Dynamic programming? 32) Explain the difference between Drop, Truncate and Delete. 33) What is Normalization? 34) Difference between Having and Where Clause. 35) Write a query to get the 3rd largest salary from a table. 36) Write queries to declare the primary key and foreign key for some table. (Syntax) 37) Problems based on the usage of increment and decrement operators. 38) Swap two variables without using the third one. 39) Swap two variables without using the third one and without using the arithematic operators. 40) Describe your projects.
avatar

System Engineer

Interviewed at Tata Consultancy Services

3.5
Oct 19, 2023

1) In simple terms, explain what is Blockchain Technology. 2) Is Bitcoin a part of Blockchain or vice versa? 3) What is AI, ML and Deep Learning? 4) What is Big Data Analytics? 5) Explain Exception Handling with an example. 6) What is the use of “finally” block in exception handling? 7) Explain the pillars of object oriented programming namely abstraction, encapsulation, polymorphism and inheritance. 8) Explain Overloading and Overriding. 9) What is Final? 10) Difference between JDK and JRE. 11) What is JVM? 12) Name various data types in Java. 13) Why multiple inheritance is not there in Java? 14) Why pointers are not there in Java? 15) What is Static variable and method in Java? 16) Can you overload the main method? 17) What kind of errors are there in Java? 18) What are the advantages of Java? 19) Name some errors and exceptions? 20) What is the super class of Exception? 21) What is the super class of Throwable? 22) What are ACID properties? 23) What are transactions in databases? 24) What is linked list? 25) Detection and removal of a loop in linked list. 26) Difference between call by value and call by reference. 27) Why do we use R? 28) How can we use R to predict something? 29) What are the advantages of R? 30) What happens after you enter the URL of a website? 31) What is Dynamic programming? 32) Explain the difference between Drop, Truncate and Delete. 33) What is Normalization? 34) Difference between Having and Where Clause. 35) Write a query to get the 3rd largest salary from a table. 36) Write queries to declare the primary key and foreign key for some table. (Syntax) 37) Problems based on the usage of increment and decrement operators. 38) Swap two variables without using the third one. 39) Swap two variables without using the third one and without using the arithematic operators. 40) Describe your projects.

Technical Round: Review technical concepts related to the job. Practice coding exercises and problem-solving. Be prepared to discuss your previous technical experiences and projects. HR Round: Research the company culture and values. Reflect on your career goals and motivations. Practice answering common HR questions, and consider behavioral interview techniques (using the STAR method).
avatar

System Engineer

Interviewed at Tata Consultancy Services

3.5
Dec 1, 2023

Technical Round: Review technical concepts related to the job. Practice coding exercises and problem-solving. Be prepared to discuss your previous technical experiences and projects. HR Round: Research the company culture and values. Reflect on your career goals and motivations. Practice answering common HR questions, and consider behavioral interview techniques (using the STAR method).

Viewing 6921 - 6930 interview questions

Glassdoor has 7,597 interview questions and reports from System analyst interviews. Prepare for your interview. Get hired. Love your job.