CitiusTech Software Developer Interview Questions and Answers

Q1. Explain dependency injection, indexes in sql, SOLID principles.
Ans. 
Dependency injection is a design pattern where dependencies are injected into a class rather than created within the class itself.
• Dependency injection helps in achieving loose coupling between classes.

• It allows for easier testing and maintenance of code.

• Example: Constructor injection, setter injection, and interface injection are common types of dependency injection.

• Indexes in SQL are used to improve the performance of...read more
Answered by AI
Add your answer

Q1. Basic .net,oops,cloud experience any
Add your answer

Q1. Advanced level plus coding
Add your answer

Q1. Basic hr Question,salary expectation
Add your answer

Q1. Difference between Procedure, Packages and functions.
Ans. 
Procedures, Packages and Functions are all subprograms in PL/SQL with different characteristics.
• Procedures are subprograms that perform a specific task and may or may not return a value.

• Functions are subprograms that always return a value and can be used in SQL statements.

• Packages are a collection of related procedures, functions, variables, and other program constructs that can be used as a single unit.

• Packages provid...read more
Answered by AI
Add your answer
Q2. If table or view does not exist what does it mean
Ans. 
It means that the table or view does not exist in the database.
• The query will fail and return an error message.

• The application may crash or behave unexpectedly.

• The table or view may have been deleted or renamed.

• Check the spelling and syntax of the query.

• Make sure the database connection is established and valid.
Answered by AI
Add your answer
Q3. Difference Between Views and Materialized Views
Ans. 
Views are virtual tables while Materialized Views are physical tables.
• Views are created using SELECT statement while Materialized Views are created using CREATE MATERIALIZED VIEW statement.

• Views do not store data while Materialized Views store data.

• Views are updated dynamically while Materialized Views are updated manually or automatically based on refresh settings.

• Materialized Views are faster for read-heavy workloads...read more
Answered by AI
Add your answer

Q1. Details explanation about the projects and the concepts what we used.
Add your answer

Q1. Basic oops concept
Ans. 
Object-Oriented Programming (OOP) is a paradigm based on objects that encapsulate data and behavior.
• Encapsulation: Bundling data and methods that operate on the data within one unit (e.g., a class).

• Inheritance: Mechanism to create a new class using properties and methods of an existing class (e.g., a 'Dog' class inheriting from an 'Animal' class).

• Polymorphism: Ability to present the same interface for different underly...read more
Answered by AI
Add your answer
Q2. SQL related questions
Add your answer
Q3. Difference between stored procedure and function
Ans. 
Stored procedures are precompiled SQL queries stored in the database, while functions are reusable blocks of code that return a value.
• Stored procedures are stored in the database and can perform multiple operations, while functions are standalone blocks of code.

• Functions return a value, while stored procedures do not necessarily have to return a value.

• Stored procedures can be called explicitly, while functions can be u...read more
Answered by AI
Add your answer

Q1. Performance related questions
Add your answer

Around 75 mcq questions with snippets of code

Q1. Interview conducted by technical lead. Around 10-15 questions asked. Questions related to your skills only.
Add your answer
Q2. Basics of core java
Add your answer
Q3. SQL queries, scenario based questions
Add your answer

Q1. Daily routine. Casual question/non technical questions. Tricky question. Puzzles. Sone technical questions.
Add your answer

Q1. Simple technical interview
Add your answer
Q2. Difference between html and html5, flexbox,
Ans. 
HTML is the standard markup language for creating web pages, while HTML5 is the latest version with new features. Flexbox is a layout model for designing responsive websites.
• HTML is the standard markup language used to create web pages.

• HTML5 is the latest version of HTML with new features like <video>, <audio>, and <canvas> elements.

• Flexbox is a layout model in CSS that allows for easier alignment and...read more
Answered by AI
View 1 more answer
Q3. What is dependency injection
Ans. 
Dependency injection is a design pattern that allows objects to receive dependencies rather than creating them internally.
• Dependency injection helps to decouple components and make them more modular and testable.

• It allows for easier maintenance and scalability of code.

• There are three types of dependency injection: constructor injection, setter injection, and interface injection.

• Example: Instead of creating a database c...read more
Answered by AI
Add your answer

Q1. What is bootstrap,
Ans. 
Bootstrap is a popular front-end framework for building responsive websites and web applications.
• Bootstrap provides pre-designed HTML, CSS, and JavaScript components that can be easily customized and integrated into a project.

• It includes a responsive grid system for creating layouts that adapt to different screen sizes.

• Bootstrap also offers built-in support for popular web development tools like Sass and jQuery.

• Example...read more
Answered by AI
Add your answer
Q2. Service,dependency injection, flexbod, box model,component
Add your answer