Filter interviews by
SQL query for XYZ scenario
Use SELECT statement to retrieve data from the table
Use WHERE clause to filter data based on the XYZ scenario
Consider using JOIN if data from multiple tables is needed
A temporary table is a table that is created and exists only for the duration of a database session.
Temporary tables are typically used to store intermediate results during a complex query or to isolate data for a specific task.
They are automatically dropped when the session ends or when the table is explicitly dropped.
Temporary tables are often prefixed with a '#' or '##' to differentiate them from permanent tabl...
A trigger function in SQL is a stored procedure that is automatically executed in response to certain events on a particular table.
Triggers can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
They are useful for enforcing business rules, auditing changes, and maintaining data integrity.
Example: CREATE TRIGGER audit_trigger AFTER INSERT ON employees FOR EACH ROW EXECUTE PROCEDURE a...
A primary key is a unique identifier for each record in a database table.
A primary key must contain unique values for each record in the table.
It cannot contain null values.
It can consist of one or multiple columns.
Example: In a table of students, the student ID can be a primary key.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.
Hive uses a SQL-like language called HiveQL to query and manage large datasets stored in Hadoop.
It allows users to write complex queries without needing to know Java or MapReduce.
Hive organizes data into tables, partitions, and buckets for efficient querying and analysis.
It supports custom MapReduce...
A Database Management System (DBMS) is a software that allows users to create, retrieve, update, and manage data in a database.
DBMS helps in organizing and structuring data efficiently
It provides tools for data manipulation, querying, and security
Examples include MySQL, Oracle, SQL Server
I applied via Referral and was interviewed before Jan 2023. There were 4 interview rounds.
I am drawn to this organization for its commitment to innovation, data-driven decision-making, and opportunities for professional growth.
The organization's focus on leveraging data analytics to drive strategic decisions aligns with my passion for data-driven insights.
I admire the company's commitment to continuous improvement and innovation, as seen in its recent projects like [specific project].
The collaborative cultu...
Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.
Hive uses a SQL-like language called HiveQL to query and manage large datasets stored in Hadoop.
It allows users to write complex queries without needing to know Java or MapReduce.
Hive organizes data into tables, partitions, and buckets for efficient querying and analysis.
It supports custom MapReduce scri...
A trigger function in SQL is a stored procedure that is automatically executed in response to certain events on a particular table.
Triggers can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
They are useful for enforcing business rules, auditing changes, and maintaining data integrity.
Example: CREATE TRIGGER audit_trigger AFTER INSERT ON employees FOR EACH ROW EXECUTE PROCEDURE audit_...
SQL query for XYZ scenario
Use SELECT statement to retrieve data from the table
Use WHERE clause to filter data based on the XYZ scenario
Consider using JOIN if data from multiple tables is needed
Top trending discussions
I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.
I appeared for an interview before Dec 2020.
Round duration - 120 Minutes
Round difficulty - Medium
Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...
The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.
Read the number of test cases 'T'
For each test case, encode the 'SECRET_INFORMATION' and then decode it
Compare the decoded string with the original 'SECRET_INFORMATION'
Print 'Transmission successful' if they match, else print 'Transmission failed'
Round duration - 60 Minutes
Round difficulty - Medium
Given an array Arr
consisting of N integers, your task is to find the equilibrium index of the array.
An index is considered as an equilibrium index if the sum of elem...
Round duration - 50 Minutes
Round difficulty - Easy
Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company
Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.
I applied via Walk-in and was interviewed before Apr 2021. There were 4 interview rounds.
There were atleast 200 Aaplicants in which there separation of groups into 30 applicants and names were called out and have to say more that 4 to 5 lines on any topic u want to talk about as extempore.
There were quest as pharmacology, pharmaceutics, reasoning knowledge, mathematics, English section.
I applied via Job Portal and was interviewed before Sep 2020. There were 3 interview rounds.
I applied via Walk-in and was interviewed in Sep 2020. There was 1 interview round.
I applied via Campus Placement and was interviewed in Oct 2020. There was 1 interview round.
I appeared for an interview before Nov 2016.
I appeared for an interview in Aug 2017.
I appeared for an interview in Sep 2016.
based on 1 interview experience
Difficulty level
Duration
based on 3 reviews
Rating in categories
Data Analyst
11
salaries
| ₹3.5 L/yr - ₹7 L/yr |
Market Research Manager
4
salaries
| ₹15 L/yr - ₹32.5 L/yr |
Senior Data Analyst
3
salaries
| ₹5 L/yr - ₹9 L/yr |
Senior Quality Analyst
3
salaries
| ₹6 L/yr - ₹16 L/yr |
TCS
Accenture
Wipro
Cognizant