Affixious Content Manager Interview Questions and Answers

Questions were moderate but we need to manage time to clear this round

Q1. Asked to tell about me
Add your answer
Q2. Questions on OOPS concept
Add your answer
Q3. And basic To moderate SQL questions
Add your answer
Q4. Question on DSA
Add your answer

Q1. Asked me to tell about me
Add your answer
Q2. And asked about my projects
Add your answer
Q3. Asked me to tell what my expectations are from Kanerika
Add your answer

Q1. What is constructor overloading?
Ans. 
Constructor overloading is when a class has multiple constructors with different parameters.
• Allows a class to have multiple constructors with different parameter lists

• Helps in creating objects in different ways based on the parameters passed

• Example: class Car { Car() {...} Car(String model) {...} }
Answered by AI
Add your answer

Q1. What is your current salary, and what are your salary expectations?
Ans. 
I am currently earning $80,000 annually. My salary expectations are in the range of $90,000 to $100,000.
• Current salary is $80,000 annually

• Salary expectations are between $90,000 to $100,000

• Open to negotiation based on benefits and opportunities
Answered by AI
Add your answer

Q1. Java 8 new features
Ans. 
Java 8 introduced several new features including lambda expressions, functional interfaces, streams, and default methods.
• Lambda expressions allow you to pass functionality as an argument to a method.

• Functional interfaces have a single abstract method and can be used with lambda expressions.

• Streams provide a way to work with sequences of elements and perform aggregate operations.

• Default methods allow interfaces to have ...read more
Answered by AI
Add your answer

Q1. Payments domain experience
Ans. 
Experience in working with payments domain in previous roles.
• Worked on payment processing systems

• Familiar with payment gateways and APIs

• Experience in fraud detection and prevention in payments

• Knowledge of regulatory requirements in payments

• Handled reconciliation of payments
Answered by AI
Add your answer

70 questions in 90 minutes with 7 sections

Q1. Introduce yourself
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Second highest salary
Ans. 
To find the second highest salary in a table, you can use a SQL query with the MAX() function and a subquery.
• Use a SQL query to select the MAX() salary from the table.

• Use a subquery to select the MAX() salary that is less than the overall MAX() salary.

• Combine both queries to get the second highest salary.
Answered by AI
Add your answer
Q4. What is indexing
Ans. 
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.
• Indexing involves creating a data structure that maps the values of specific columns in a database table to their physical location on disk.

• It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that match a certain condition.

• Examples o...read more
Answered by AI
Add your answer

Q1. Introduce yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java, Python, and web development technologies

• Strong problem-solving skills

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Difference between truncate and delete
Ans. 
Truncate is a DDL command that removes all records from a table, while delete is a DML command that removes specific records.
• Truncate is faster than delete as it does not log individual row deletions.

• Truncate resets the identity seed of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.
Answered by AI
Add your answer

Q1. Why you join company
Add your answer
Q2. Where you see yourself after 5 years
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on cutting-edge technologies.
• Leading a team of developers on innovative projects

• Continuing to enhance my technical skills and knowledge

• Contributing to the growth and success of the company

• Possibly pursuing further education or certifications in software development
Answered by AI
Add your answer

Aptitude questions were easy and basics

Q1. They asked about projects, SQL basics, oops concepts and about java concepts
Add your answer
Q2. It was an easy and average interview
Add your answer

Q1. About the project that I have worked
Add your answer
Q2. Technical Experience
Add your answer

Q1. Databinding in android
Ans. 
Databinding in Android allows for easier connection between UI components and data sources.
• Databinding eliminates the need for findViewById() calls in your code.

• It allows for easier access to data in your layouts using data binding expressions.

• Databinding can improve code readability and reduce boilerplate code.

• Example:
Answered by AI
Add your answer
Q2. What is the packaging process in android
Ans. 
Packaging process in Android involves compiling the code, resources, and assets into an APK file for distribution.
• Compile the Java code into .class files

• Compile the resources (XML files, images, etc.) into a binary format

• Package all the compiled files into an APK file using the Android Asset Packaging Tool (AAPT)

• Sign the APK file with a private key for security

• Align the APK file for optimization
Answered by AI
Add your answer
Q3. What is an MVVM design pattern
Ans. 
MVVM is a design pattern that separates the user interface from the business logic and data model.
• MVVM stands for Model-View-ViewModel

• Model represents the data and business logic

• View represents the user interface

• ViewModel acts as an intermediary between the Model and View

• MVVM helps in achieving separation of concerns and easier unit testing
Answered by AI
Add your answer

Q1. Most of the question related to architecture and system design
Add your answer

Q1. Face to face interview with director
Add your answer