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
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Java questions
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.
Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.
(3 Questions)
- Q1. Explain OOPs w.r.t Java
- Ans.
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
OOPs stands for Object-Oriented Programming System
Java is a class-based OOPs language
Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs
Objects have state and behavior
Java supports interfaces, which allow for multiple inheritance
Example: A car can be represented as an object wit...
- Q2. Explain about the projects that you have worked on
- Q3. Explain how Java solves machine dependency of code execution
- Ans.
Java solves machine dependency by using bytecode and virtual machine.
Java code is compiled into bytecode which is platform-independent
The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific
JVM translates bytecode into machine code for the specific platform
This allows Java code to run on any platform with a JVM installed
Example: A Java program compiled on Windows can run on Linux or Mac as
(2 Questions)
- Q1. Why should we hire you?
- Q2. Tell me about yourself.
Interview Preparation Tips
- Java
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Numerical ability and logical reasoning followed by some coding mcqs
(1 Question)
- Q1. Print 1 to 100 without for loop
- Ans.
Printing 1 to 100 without for loop
Use recursion to print numbers from 1 to 99
Print 100 outside the recursion
Use a base case to stop recursion at 100
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Simple aptitude test
(1 Question)
- Q1. General questions as per your cv
Interview Preparation Tips
- Aptitude
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
It was a basic aptitude test.
(1 Question)
- Q1. Interview was fine. Mostly asked about my final year project.
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 59 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 |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Creative IT India Interview Questions
