DTCC Principle Software Engineer Interview Questions and Answers

Q1. SQL windows functions
Add your answer
Q2. .Net framework quetions
Add your answer

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

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

Particular topic on political party

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

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.

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