AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Column Software Solutions Interview Questions and Answers
Column Software Solutions Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Job Portal and was interviewed in Sep 2023. There were 3 interview rounds.
(6 Questions)
- Q1. What is sql operations
- Ans.
SQL operations are actions performed on a database using SQL commands to retrieve, update, insert, or delete data.
SQL operations include SELECT (retrieve data), INSERT (add new data), UPDATE (modify existing data), DELETE (remove data)
SQL operations can also include creating and modifying database tables, indexes, and views
Examples: SELECT * FROM table_name, INSERT INTO table_name (column1, column2) VALUES (value1, val...
- Q2. What is ranking in sql
- Ans.
Ranking in SQL is a way to assign a rank to each row in a result set based on a specified criteria.
Ranking functions include RANK(), DENSE_RANK(), and ROW_NUMBER().
RANK() assigns a unique rank to each distinct row, with gaps in the ranking if there are ties.
DENSE_RANK() assigns a unique rank to each distinct row, with no gaps in the ranking if there are ties.
ROW_NUMBER() assigns a unique sequential integer to each row
- Q3. What is normalisation
- Ans.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization is used to eliminate data redundancy by breaking up tables into smaller, related tables.
It helps in reducing data anomalies such as insertion, update, and deletion anomalies.
Normalization is achieved through a series of normal forms (1NF, 2NF, 3NF, BCNF, etc.).
Example: A database table that stores...
- Q4. Process to reduce redundancy
- Ans.
To reduce redundancy, implement data normalization, use modular design, automate repetitive tasks, and utilize version control systems.
Implement data normalization to eliminate duplicate data entries.
Use modular design to create reusable components and avoid repeating code.
Automate repetitive tasks using scripts or tools to save time and reduce errors.
Utilize version control systems like Git to track changes and avoid ...
- Q5. How to do Caching
- Ans.
Caching is the process of storing data in a temporary location to reduce load times and improve performance.
Use caching libraries like Redis or Memcached
Identify which data needs to be cached based on frequency of use
Set expiration times for cached data to ensure freshness
Implement caching strategies like lazy loading or write-through
Monitor cache performance and adjust as needed
- Q6. Data saves in memory
- Ans.
Data is temporarily stored in memory during program execution.
Data is stored in memory to be accessed quickly by the CPU.
Memory is volatile, meaning data is lost when the power is turned off.
Examples include variables, arrays, and objects stored in RAM.
(3 Questions)
- Q1. Sql optimisation
- Q2. How to delete activity
- Ans.
To delete an activity, you can typically use a delete button or option within the application.
Locate the activity you want to delete within the application.
Look for a delete button or option next to the activity.
Confirm the deletion when prompted.
The activity should now be removed from the application.
- Q3. On right click we get option
Skills evaluated in this interview
Top Column Software Solutions Software Developer Interview Questions and Answers
Software Developer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed before Jun 2021. There were 4 interview rounds.
(1 Question)
- Q1. Brief explanation about what you know about BMC automation technology and your projects on same.
(1 Question)
- Q1. Question about BMC Automation Tools
(1 Question)
- Q1. Basic Background details and Expectation from us about salary and all.
Interview Preparation Tips
- BMC Automation Tools
Junior Consultant Interview Questions asked at other Companies
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Sep 2020. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Database related questions
- Q2. Api
- Q3. Two basic coding questions
- Q4. Some apti based questions
Interview Preparation Tips
(1 Question)
- Q1. Tell me about your daily routine
- Ans.
My daily routine involves coding, debugging, attending meetings, and collaborating with team members.
Start the day by checking emails and prioritizing tasks
Code and debug new features or fix existing issues
Attend meetings to discuss project progress and updates
Collaborate with team members on code reviews and problem-solving
Take breaks to recharge and stay productive
Selected
I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.
There were 3 rounds for data science consultant position at Equifax. 1st round consists of Python and SQL questions and also in this round they have tested analytical thinking as well.
In 2nd round they have asked me questions from my resume and asked me to explain the projects which I have worked on in previous company. In this round they have asked me pandas related questions and asked me write code.
(1 Question)
- Q1. In Managerial round again here I have been asked questions related my projects. and no coding round in this stage.
Interview Preparation Tips
Share the link for codesignal
(2 Questions)
- Q1. Java related questions
- Q2. Based on the resume
(1 Question)
- Q1. Current time and their angles
- Ans.
The question is asking for the current time and the angles formed by the hour and minute hands on a clock.
The angle between the hour and minute hands of a clock can be calculated using the formula: angle = |(30*hour - (11/2)*minutes)|
At 3:00, the angle between the hour and minute hands is 90 degrees.
At 6:00, the angle between the hour and minute hands is 180 degrees.
At 9:00, the angle between the hour and minute hands
(1 Question)
- Q1. Didnt qual here btw
(1 Question)
- Q1. Didnt qual either btw
Selected
I applied via Referral and was interviewed before Nov 2023. There were 3 interview rounds.
(1 Question)
- Q1. Angular and JavaScript.
(2 Questions)
- Q1. Behavioral Questions
- Q2. CI-CD, Jenkins, AWS
(1 Question)
- Q1. Client Interview - Security related.
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
There was a coding round and out of 75 students 28 got selected for next round
(2 Questions)
- Q1. Total on resume and basic coding questions like write code for different sorting algorithms.
- Q2. Explain your project in detail and asking cross questions regarding project.
(1 Question)
- Q1. I was rejected in round 2.
Interview Preparation Tips
Verbal, audio and video answers has to be given for many questions
(3 Questions)
- Q1. Regional head and my reporting manager did that interview
- Q2. Self Introduction, career objective, long term plan
- Q3. Tell me about yourself
Interview Preparation Tips
Column Software Solutions Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Column Software Solutions Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Column Software Solutions Reviews and Ratings
based on 11 reviews
Rating in categories
|
Consultant
10
salaries
|  ₹4.5 L/yr - ₹14.5 L/yr |
|
Junior Consultant
5
salaries
| ₹3.5 L/yr - ₹5.5 L/yr |
|
Project Manager
4
salaries
| ₹14 L/yr - ₹20 L/yr |
|
Servicenow Developer
4
salaries
| ₹5.5 L/yr - ₹7.5 L/yr |
|
Technical Consultant
3
salaries
| ₹5.2 L/yr - ₹17.1 L/yr |
Medcode
Maxgen Technologies
Cyfuture
Value Point Systems
- Home >
- Interviews >
- Column Software Solutions Interview Questions
