Filter interviews by
Clear (1)
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Sales data from a leading manufacturer
I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.
Query to retrieve all customer names starting with A.
Use the SELECT statement to retrieve customer names.
Use the LIKE operator with the pattern 'A%' to match names starting with A.
Specify the table and column name where the customer names are stored.
Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';
Data is a collection of facts, figures, or statistics that can be analyzed to gain insights and make informed decisions.
Data can be structured or unstructured
Data can be qualitative or quantitative
Examples of data include customer demographics, sales figures, and website traffic
Data can be analyzed using various tools and techniques to extract meaningful insights
I applied via Company Website and was interviewed in Dec 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.
Data management involves organizing, storing, protecting, and maintaining data to ensure its accuracy and accessibility.
Identify the type of data and its source
Establish a data governance framework
Implement data security measures
Use data management tools and software
Regularly backup and archive data
Ensure compliance with data regulations
Monitor data quality and integrity
Provide access to authorized users only
Data analytics is the process of examining data sets to draw conclusions about the information they contain.
It involves collecting, cleaning, and transforming data
Applying statistical and mathematical models to analyze the data
Visualizing and presenting the results in a meaningful way
Examples include predicting customer behavior, identifying trends, and optimizing business processes
Analytics helps us make data-driven decisions and improve business outcomes.
Analytics provides insights into customer behavior and preferences.
It helps identify trends and patterns in data that can be used to optimize business processes.
Analytics can also be used to measure the effectiveness of marketing campaigns and other initiatives.
It enables businesses to make data-driven decisions that lead to improved outcomes a...
I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
I applied via Referral and was interviewed in Aug 2021. There were 3 interview rounds.
SQL has four types of joins: Inner Join, Left Join, Right Join, and Full Outer Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables, with NULL values in the columns where there...
Index in SQL is a database object that improves the speed of data retrieval operations.
Index is created on one or more columns of a table.
It stores a copy of the data in the indexed columns in a separate structure.
This allows for faster search and retrieval of data.
Examples of index types include clustered, non-clustered, and unique indexes.
Char is fixed length while varchar is variable length.
Char takes up the same amount of space for each value, while varchar only takes up as much space as needed.
Char is faster for fixed length data, while varchar is more flexible for variable length data.
Example: char(10) will always take up 10 characters, while varchar(10) will only take up as much space as needed for the value.
Example: char is commonly used for stori...
Substring is a part of a string that is smaller in length and extracted from the original string.
Substring is a sequence of characters within a string.
It can be extracted using string slicing or substring functions.
For example, 'hello world'[0:5] will return 'hello'.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables
Each table should have a primary key that uniquely identifies each record
Data is then organized into related tables to minimize redundancy
Normalization helps to prevent data inconsistencies and anomalies
There are different level...
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Consultant
7.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
6.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
4.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
3.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
2.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
PwC
Capgemini