i
Smollan Group
Filter interviews by
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...
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
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.
I applied via Walk-in and was interviewed in Jan 2020. There were 3 interview rounds.
Basic structure of an HTML page includes doctype declaration, html, head, and body tags.
DOCTYPE declaration specifies the HTML version
HTML tag wraps the entire content of the page
Head tag contains meta information, title, and links to external resources
Body tag contains the visible content of the page
Padding is the space inside an element, while margin is the space outside an element.
Padding is used to create space between an element's content and its border.
Margin is used to create space between an element's border and the adjacent elements.
Padding is affected by the background color of the element, while margin is not.
Padding can be set individually for each side of an element (top, right, bottom, left), while ma...
Box Model is a concept in CSS where every element is treated as a box with content, padding, border, and margin.
Box Model consists of content, padding, border, and margin.
Content is the actual content of the box.
Padding is the space between the content and the border.
Border is the line that goes around the padding and content.
Margin is the space outside the border.
Directives in Angular are markers on DOM elements that tell Angular to attach a specified behavior to that element.
There are three types of directives in Angular: Component, Structural, and Attribute.
Component directives are used to create reusable UI components.
Structural directives are used to change the structure of the DOM.
Attribute directives are used to change the appearance or behavior of an element.
Examples of ...
JIT compiles code at runtime while AOT compiles code before runtime.
JIT stands for Just-In-Time compilation and compiles code at runtime.
AOT stands for Ahead-Of-Time compilation and compiles code before runtime.
JIT is used in Java Virtual Machine (JVM) while AOT is used in languages like C and C++.
JIT can result in slower startup time but faster execution while AOT can result in faster startup time but slower execution...
I applied via LinkedIn and was interviewed before Jul 2021. There were 2 interview rounds.
Easy logical questions
basic quant
Easy level coding questions
Counting frequency of alphabets
I applied via Walk-in and was interviewed before Sep 2019. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before May 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Oct 2019. There were 5 interview rounds.
I applied via Naukri.com and was interviewed in Apr 2020. There was 1 interview round.
Synchronous means happening at the same time, while asynchronous means not happening at the same time.
Synchronous operations occur in real-time, while asynchronous operations can be delayed or queued.
Synchronous operations block the program until they are completed, while asynchronous operations allow the program to continue running.
Examples of synchronous operations include function calls and loops, while examples of ...
CTE and temp table usage in SQL
Use CTE for recursive queries and complex subqueries
Use temp tables for large data sets and complex queries
CTE is more efficient for small data sets
Temp tables can be indexed for faster performance
Consider the scope and lifespan of the data when choosing between CTE and temp table
based on 1 interview
Interview experience
based on 5 reviews
Rating in categories
Sales Executive
112
salaries
| ₹0 L/yr - ₹0 L/yr |
Marketing Executive
95
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
80
salaries
| ₹0 L/yr - ₹0 L/yr |
Field Manager
71
salaries
| ₹0 L/yr - ₹0 L/yr |
Rural Sales Promoter
60
salaries
| ₹0 L/yr - ₹0 L/yr |
WPP
Accenture
Deloitte
PwC