Cheil India Creative Art Supervisor Interview Questions and Answers

Q1. Prepare SQL and Pyspark well
Add your answer
Q2. Prepare well on SQL Joins
Add your answer

Q1. Read about Programmatic advertising
Add your answer

It was a virtual coding round with coding questions on Java fundamentals, Array, LinkedList

Questions on java fundamentals, some code snippets, Array

Q1. Behavioral round with discussion on previous experience and values
Add your answer

Questions on SQL excel and BI tools

Technical skills deep understanding

Q1. Execution of SQL
Ans. 
Execution of SQL involves writing and running queries to retrieve, manipulate, and manage data in a database.
• Write SQL queries to retrieve specific data from database tables

• Use SQL functions and operators to manipulate data

• Execute SQL statements to update or delete records in database

• Manage database schema by creating, altering, or dropping tables

• Optimize SQL queries for better performance
Answered by AI
Add your answer

Q1. Fitment round and cultural
Add your answer

Two Medium DSA questions, then questions about react and springboot

Q1. One map related question regarding sorting string according to number of occurance of characters in it.
Add your answer
Q2. Right view of tree (recursive and using level order)
Ans. 
Printing the right view of a tree using recursion and level order traversal.
• Recursively traverse the right subtree first and then the left subtree.

• For level order traversal, use a queue to store nodes at each level.

• Print the rightmost node at each level.

• Example: For tree 1-2-3-4-5, the right view is 1-2-4-5.
Answered by AI
Add your answer
Q3. Some dbms, os, system design related terminologies like (foreign key, primary key, difference between them, scaling and types of it, few question on os)
Add your answer

Q1. Basic oops concepts. with examples
Add your answer
Q2. Java specific question and to write abstract class, interface and state difference between them.
Add your answer
Q3. Solid design pattern question to implement it with given example.
Add your answer
Q4. Sql query, os related question (deadlocks, and it s resolution)
Add your answer

Q1. It was managerial round based solely on resume. asked about my internship work, how I perform in team, work which I have done in previous organisation.
Add your answer
Q2. Few fun topics and discussions
Add your answer

Calender, time, relationship

Q1. Interduction itself
Add your answer
Q2. Technical questions
Add your answer
Q3. Data structure and algorithms
Add your answer

Q1. Have you tell something about yourself
Add your answer
Q2. Have you know about this company
Add your answer
Q3. Have you comfortable for doing this job
Add your answer
Q4. Hr will contact you shortly
Add your answer

Q1. What is Indexing in Mysql
Ans. 
Indexing in MySQL is a technique to improve the performance of database queries by creating a data structure that allows for faster data retrieval.
• Indexes are created on one or more columns of a table.

• They help in speeding up the search, sorting, and joining of data.

• Indexes can be created using different algorithms like B-tree, hash, or bitmap.

• Using indexes appropriately can significantly enhance query performance.

• Exam...read more
Answered by AI
Add your answer
Q2. Opps concepts in php
Ans. 
Object-oriented programming concepts in PHP
• Encapsulation: bundling data and methods together in a class

• Inheritance: creating new classes based on existing ones

• Polymorphism: using a single interface to represent different types

• Abstraction: hiding unnecessary details and exposing only essential features

• Class: blueprint for creating objects

• Object: instance of a class

• Method: function defined inside a class

• Property: variabl
Answered by AI
Add your answer