Seneca Global IT Services Admin Executive Interview Questions and Answers

Coding Rount
DSA Round + Puzzle
SQL + Project Discussion
JS

Q1. What are BASE properties
Ans. 
BASE properties describe a model for distributed systems emphasizing availability and partition tolerance over strict consistency.
• B - Basically Available: Systems guarantee availability, meaning they respond to requests even if some nodes are down.

• A - Soft state: The state of the system may change over time, even without new input, due to eventual consistency.

• E - Eventually consistent: The system will become consistent...read more
Answered by AI
Add your answer
Q2. Explain the workflow of a Transaction in DBMS
Ans. 
A transaction in DBMS is a sequence of operations performed as a single logical unit of work, ensuring data integrity.
• 1. Transaction Initiation: A transaction begins with a request to perform a database operation, like inserting a record.

• 2. Execution: The DBMS executes the operations defined in the transaction, such as INSERT, UPDATE, or DELETE.

• 3. Logging: Changes are logged in a transaction log to ensure recovery in c...read more
Answered by AI
Add your answer

2 medium hard level questions. We just have to code and explain it. Platform doesn't have compilers.

Good Knowledge of DSA is required

Q1. Given an array Reverse array
Add your answer
Q2. Giaven a string Reverse string
Add your answer
Q3. Given array find sum of all elements
Add your answer

Q1. What is singleton design pattern
Ans. 
Singleton design pattern restricts the instantiation of a class to a single instance and provides global access to it.
• Used when only one instance of a class is required throughout the application

• Provides a global point of access to the instance

• Implemented using a private constructor, static method, and static variable

• Example: Logger class, Database connection class
Answered by AI
Add your answer
Q2. C# LINQ queries for group and sum data from data table
Ans. 
C# LINQ queries for group and sum data from data table
• Use GroupBy() method to group data based on a specific column

• Use Sum() method to calculate the sum of a column

• Use Select() method to select the required columns
Answered by AI
Add your answer
Q3. Solid design principles
Ans. 
Solid design principles are a set of guidelines for writing maintainable and scalable code.
• Single Responsibility Principle (SRP) - each class should have only one responsibility

• Open/Closed Principle (OCP) - classes should be open for extension but closed for modification

• Liskov Substitution Principle (LSP) - subclasses should be able to replace their parent classes without affecting the program's correctness

• Interface Se...read more
Answered by AI
Add your answer
Q4. OOPS concepts ,like association and all
Add your answer

Basic aptitude test and was unproctored

Q1. It was a online technical round
Add your answer

Q1. Previous experience, resume related questions
Add your answer
Q2. SOLID principles, Design Patterns, OOPS concepts and basic coding questions,
Add your answer