Filter interviews by
Clear (1)
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 Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.
I applied via Company Website
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 Job Portal and was interviewed in Aug 2024. There were 2 interview rounds.
Sql and aptitude questions
I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
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 LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
1. FROM: Specifies the tables involved in the query.
2. WHERE: Filters the rows based on specified conditions.
3. GROUP BY: Groups the rows that have the same values into summary rows.
4. HAVING: Filters groups based on specified conditions.
5. SELECT: Selects the columns to be included in the result set.
6. ORDER BY: Sorts the result set base
Conditional formatting in Excel allows users to format cells based on specified conditions.
Select the range of cells you want to apply conditional formatting to
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose the desired formatting option, such as color scales, data bars, or icon sets
Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...
I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.
Easy questions based on Logical Reasoning, Mathematics, English
Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.
based on 2 reviews
Rating in categories
Analyst
34
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
22
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Engineer
20
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
15
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
14
salaries
| ₹0 L/yr - ₹0 L/yr |
Fiserv
FIS
Global Payments
WEX Inc