AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Creative IT India
Compare
Filter interviews by
Creative IT India Interview Questions and Answers
Creative IT India Interview Experiences
5 interviews found
(2 Questions)
- Q1. What is right Join and left join
- Ans.
Right join and left join are types of joins used in SQL to combine rows from two or more tables based on a related column between them.
Left join returns all rows from the left table and the matched rows from the right table, with null values where there is no match.
Right join returns all rows from the right table and the matched rows from the left table, with null values where there is no match.
Example: SELECT * FROM t...
- Q2. What is index and its type
- Ans.
An index is a data structure that improves the speed of data retrieval operations in a database.
Types of indexes include clustered, non-clustered, unique, and composite indexes.
Indexes can be created on one or multiple columns in a table.
Examples of indexes are primary keys, foreign keys, and indexes created for frequently searched columns.
Interview Preparation Tips
Skills evaluated in this interview
Support Engineer Interview Questions asked at other Companies
I applied via Job Portal and was interviewed before Jun 2023. There was 1 interview round.
They had asked me about joins sp and algorithms, on power bi side there were many case scenario
Interview Preparation Tips
Team Lead Interview Questions asked at other Companies
Senior Software Developer and Team Lead Interview Questions & Answers
Anonymous
posted on 20 Mar 2023
Selected
I applied via Recruitment Consulltant and was interviewed before Mar 2022. There were 3 interview rounds.
(1 Question)
- Q1. Oops concept basic SQL server question.
(1 Question)
- Q1. Salary break up company rules and regulation
Interview Preparation Tips
They are not checking the talent of the employee while layoffs.
I appeared for an interview before Feb 2021.
(1 Question)
- Q1. Fairly average questions from sql
Interview Preparation Tips
Senior Software Engineer Interview Questions asked at other Companies
Creative IT India interview questions for popular designations
I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.
(1 Question)
- Q1. Tell me about yourself
Interview Preparation Tips
Executive Accountant Interview Questions asked at other Companies
Interview questions from similar companies
I appeared for an interview before Jan 2021.
Interview Questionnaire
2 Questions
- Q1. Basic analysis questions
- Q2. Excel Based analysis as it was a entry-level position
Interview Preparation Tips
Read about the interviewer
I applied via Naukri.com and was interviewed in Jun 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. About projects
Interview Preparation Tips
Fingent has got a good number of people in the interview panel(my personal experience)
Even if you do not know the answer, the panel will explain it to you.
I applied via Company Website and was interviewed before May 2018. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Questions about Oops, data structures based on the projects I had done, and my resume
- Q2. Questions about classes and abstraction
Interview Preparation Tips
Interview Preparation Tips
Experience: PAPER DURATION: 3 hours
NO. OF QUESTIONS: 2 (20 marks each)
MAXIMUM MARKS: 20*2 = 40 marksQUESTION 1:
JSON Prettier:-Write a program which takes JSON as input and gives prettified JSONYou need to read JSON from STDIN. Input gives one line of uglified JSON.Output should be formatted JSON. Check the standard output link.Use 2 white spaces (not‘\t’) for one indentation.SAMPLE INPUT:{“group” : {list : [1,2,3]}, “list” : [“a”,”b”,”c”]}SAMPLE OUTPUT:{“group” : {List : [1,2,3]},“list” : [“a”,”b”,”c”]}EXPLANATION: Input will be uglifiedjson in one line and output will be prettified format of that. QUESTION 2:XML parse plus series computationEvaluate an expression given in XML format. Keys will be Expr- contains the entire expression. Elem – contains the digit, sum, Prod- contains two or more keys whose evaluation needs to be summed or multiplied respectively. Sub will contain 2 keys or more, where the second key onwards will have to be subtracted from the first one. Div- will contain 2 keys in which first key will need to be divided by second. SAMPLE INPUT:
20EXPLANATION:Input will be xml file through standard input. End of xml file marked by .
Duration: 180 minutes
Total Questions: 2
College Name: NA
I applied via Naukri.com and was interviewed before Jul 2019. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Questions about the projects you worked with. About how specific coding challenges were solved. How it could have been done other ways. etc.
- Q2. About Python versions and differences. Impact on frameworks.
- Q3. About module design, apis.
Interview Preparation Tips
Creative IT India Interview FAQs
Tell us how to improve this page.
Creative IT India Interviews By Designations
- Creative IT India Support Engineer Interview Questions
- Creative IT India Senior Software Engineer Interview Questions
- Creative IT India Executive Accountant Interview Questions
- Creative IT India Team Lead Interview Questions
- Creative IT India Senior Software Developer and Team Lead Interview Questions
Interview Questions for Popular Designations
Creative IT India Interview Process
based on 5 interviews
Interview experience
Interview Questions from Similar Companies
Creative IT India Reviews and Ratings
based on 60 reviews
Rating in categories
Navi Mumbai
5-10 Yrs
Not Disclosed
Navi Mumbai
2-7 Yrs
Not Disclosed
|
Software Engineer
43
salaries
|  ₹3.8 L/yr - ₹11.2 L/yr |
|
Senior Software Engineer
38
salaries
| ₹6.7 L/yr - ₹17.5 L/yr |
|
Softwaretest Engineer
32
salaries
| ₹3 L/yr - ₹9 L/yr |
|
Software Developer
14
salaries
| ₹12.4 L/yr - ₹19.2 L/yr |
|
Team Lead
12
salaries
| ₹10.8 L/yr - ₹20.1 L/yr |
Aurigo
Prime Focus Technologies
Peel-works
Yodlee
- Home >
- Interviews >
- Creative IT India Interview Questions
