DTCC Lead Software Engineer Interview Questions and Answers

Pattern prg on stair case of building

Q1. Hasmap, sql , core java , multithreading , exception handling
Add your answer

Cs fundamentals were asked which were easy

Q1. Pagination in SQL
Ans. 
Pagination in SQL allows for displaying a subset of query results at a time.
• Use LIMIT and OFFSET clauses in SQL queries to implement pagination.

• LIMIT specifies the maximum number of rows to return.

• OFFSET specifies the number of rows to skip before starting to return rows.
Answered by AI
Add your answer
Q2. OOPS concepts.. SOILD design principles
Add your answer
Q3. Thread vs task in multiprocessing.. explain with examples
Ans. 
Threads and tasks are both used in multiprocessing, but have different characteristics and use cases.
• Threads are lightweight processes within a single process, sharing memory space. They are managed by the operating system.

• Tasks are units of work that can be executed asynchronously. They are typically managed by a task scheduler.

• Threads are suitable for parallel processing and improving performance, while tasks are use...read more
Answered by AI
Add your answer
Q4. ViewBag vs Tempdata in MVC
Ans. 
ViewBag is used to pass data from controller to view, while TempData is used to pass data between controller actions.
• ViewBag is a dynamic property that allows you to pass data from controller to view

• TempData is a dictionary object that allows you to pass data between controller actions

• ViewBag is not type-safe and requires typecasting, while TempData is type-safe

• ViewBag data is lost if redirection occurs, while TempData
Answered by AI
Add your answer
Q5. Abstract vs Interface
Ans. 
Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.
• Abstract classes can have constructors, fields, and non-abstract methods.

• Interfaces can only have abstract methods and constants.

• A class can implement multiple interfaces but can only inherit from one abstract class.
Answered by AI
Add your answer

It was basic aptitude test on rs aggrawal

Q1. Try catch exception handling
Add your answer

Q1. Where do you live
Add your answer

Q1. What are joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is OOP features
Ans. 
OOP features are key concepts in Object-Oriented Programming that include encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (object)

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

• Polymorphism: Ability for objects to be treated as instances of their parent class or their own class

• Abstractio...read more
Answered by AI
Add your answer
Q3. Primary key , foreign key
Add your answer
Q4. Exception in java
Ans. 
An exception in Java is a runtime error that disrupts the normal flow of a program.
• Exceptions are objects that are thrown when an error occurs during the execution of a program.

• They can be caught and handled using try-catch blocks.

• Common types of exceptions in Java include NullPointerException, ArrayIndexOutOfBoundsException, and IOException.
Answered by AI
Add your answer

Q1. What is the difference between a static function and a static variable?
Ans. 
Static function is a function that can only be accessed within the same file, while a static variable is a variable that retains its value between function calls.
• Static function is declared using the 'static' keyword before the return type, limiting its scope to the file it is defined in.

• Static variable is declared using the 'static' keyword before the variable type, retaining its value between function calls.

• Example o...read more
Answered by AI
Add your answer
Q2. What is the synchronization technique?
Ans. 
Synchronization technique is a method used to control access to shared resources in a multi-threaded environment.
• Synchronization techniques prevent race conditions and ensure data consistency

• Common synchronization techniques include locks, semaphores, and monitors

• Examples include using synchronized keyword in Java or mutex in C++
Answered by AI
Add your answer

Add an element to a linked list.

1 hour 10 mins, MERN Stack, Face to Face. Mongodb, medium DSA Question, callback, eventloop, NodeJS asynchronous working

Maths,verbal reasoning.
Like percentage,wages, proportional problems

Particular topic on political party