i
Pristyn Care
Filter interviews by
Clear (1)
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language.
It is used to communicate with databases to retrieve, insert, update, and delete data.
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.
SQL is used in various database management systems like MySQL, PostgreSQL, and Oracle.
Example: SELECT * FROM customers WHERE city = 'New York';
A left join is a type of join in SQL that returns all records from the left table and the matched records from the right table.
Left join is used to retrieve all records from the left table and the matched records from the right table.
If there is no match, NULL values are returned for the columns from the right table.
Types of joins in SQL include inner join, outer join (left, right, full), cross join, and self join.
Top trending discussions
I applied via Referral
I applied via LinkedIn and was interviewed before Nov 2020. There was 1 interview round.
I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.
SQL query optimisation
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Number sires, clock, logic, arithmetic, geometry
Code test basic, ans the basic knowledge, write code
Python is a high-level programming language known for its simplicity and readability.
Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.
It emphasizes code readability and uses indentation to define code blocks.
Python has a large standard library and a vibrant community of developers.
Example: print('Hello, World!')
Example: import pandas as pd
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
Data analysis and visualization
Web development (Django, Flask)
Artificial intelligence and machine learning (TensorFlow, PyTorch)
Automation and scripting
Scientific computing (NumPy, SciPy)
Python is a high-level programming language known for its simplicity and readability.
Python is an interpreted language, meaning it does not need to be compiled before running.
It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.
Python has a large standard library and a thriving community, making it versatile and widely used.
Example: Python is used for web develop...
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
OOP allows for the organization of code into reusable components called classes.
Classes can have attributes (variables) and methods (functions) associated with them.
In Python, everything is an object, and classes can be defined using the 'class' keyword.
Encapsulation, inheritance, and polymorph
An array in Python is a data structure that stores a collection of elements of the same type.
Arrays can store elements such as integers, floats, or strings.
Arrays are indexed starting from 0, with elements accessed using their index.
Example: arr = ['apple', 'banana', 'cherry']
I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.
Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.
Analyze the supply chain and identify bottlenecks
Implement automation tools to streamline processes
Improve communication between departments and with customers
Use data analytics to forecast demand and plan accordingly
Consider outsourcing or partnering with third-party logistics providers
Invest in tec...
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Business Development Manager
677
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
228
salaries
| ₹0 L/yr - ₹0 L/yr |
Category Manager
142
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
126
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Manager
77
salaries
| ₹0 L/yr - ₹0 L/yr |
Portea Medical
PharmEasy
Practo
Tata 1mg