Filter interviews by
DDL commands are used to define and manage the structure of a database.
DDL stands for Data Definition Language.
DDL commands are used to create, modify, and delete database objects such as tables, indexes, and views.
Examples of DDL commands include CREATE, ALTER, and DROP.
DDL commands do not manipulate the data within the database, only the structure.
Truncate is a DDL statement that removes all rows from a table, while delete is a DML statement that removes specific rows.
Truncate is faster than delete as it doesn't generate any rollback information.
Truncate cannot be rolled back, while delete can be.
Truncate resets the identity of the table, delete does not.
Truncate does not fire triggers, delete does.
Truncate is non-logged operation, delete is logged.
Top trending discussions
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
Sql, python, statistical questions
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
Reviewing and cleaning data sets
Creating visualizations and dashboards
Conducting statistical analysis
Communicating insights to non-technical stakeholders
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
Excel is widely used for data manipulation and analysis.
Python and R are popular programming languages for data analysis and machine learning.
Tableau is a powerful data visualization tool.
SQL is essential for querying databases and extracting data.
4 sql tasks on 3 tables. Joins, subqueries
I applied via Instahyre and was interviewed in Aug 2024. There was 1 interview round.
It is difficult to accurately estimate the number of cricket bats sold in a year without specific data.
The number of cricket bats sold in a year can vary based on factors such as seasonality, popularity of cricket, and market trends.
One approach to estimate could be to consider the total population of cricket-playing countries and the average number of bats owned by players.
Another approach could be to look at the sale...
I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.
It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.
I applied via Naukri.com and was interviewed in Jul 2024. There were 4 interview rounds.
Topics were, DSA, SQL, PL/SQL, Data Augmentation
Customer churn classification using a classification ML model
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
Start with the first element and compare it with the next element, swapping if necessary
Repeat this process for each pair of adjacent elements in the array until the entire array is sorted
Continue this process for each element in the array until no more swaps are ne
An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.
APIs define the methods for requesting and receiving data between software applications
APIs can be used to access data from external sources, such as social media platforms or weather services
Examples of APIs include the Twitter API, Google Maps API, and Spotify API
I am a data analyst with a strong background in statistics and data visualization.
Graduated with a degree in Statistics
Proficient in programming languages like Python and R
Experience in analyzing large datasets and creating data visualizations
Strong problem-solving skills and attention to detail
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
based on 2 reviews
Rating in categories
Analyst
34
salaries
| ₹2.4 L/yr - ₹8.4 L/yr |
Software Engineer
22
salaries
| ₹5 L/yr - ₹16 L/yr |
Associate Engineer
20
salaries
| ₹5 L/yr - ₹10 L/yr |
Team Lead
15
salaries
| ₹5 L/yr - ₹19.6 L/yr |
Senior Analyst
14
salaries
| ₹3 L/yr - ₹5.5 L/yr |
Fiserv
FIS
Global Payments
Corpay India