i
Seclore
Filter interviews by
I applied via campus placement at Mumbai University and was interviewed in Jul 2021. There were 3 interview rounds.
Top trending discussions
I applied via Naukri.com and was interviewed in Jan 2023. There were 4 interview rounds.
1st Round was aptitude question and MCQ based on SQL and java
SQL delete syntax and commands.
Use the DELETE statement followed by the table name.
Add a WHERE clause to specify the rows to be deleted.
Use the TRUNCATE statement to delete all rows in a table.
Use the DROP statement to delete an entire table.
Be careful when deleting data as it cannot be recovered.
Examples: DELETE FROM table_name WHERE column_name = value;
TRUNCATE TABLE table_name;
DROP TABLE table_name;
Clustered index determines the physical order of data in a table while non-clustered index creates a separate structure.
Clustered index sorts and stores the data rows in the table based on their key values
Non-clustered index creates a separate structure that contains the key values and a pointer to the data row
A table can have only one clustered index while multiple non-clustered indexes can be created
Clustered index i...
I applied via Naukri.com and was interviewed in Jan 2023. There were 4 interview rounds.
1st Round was aptitude question and MCQ based on SQL and java
SQL delete syntax and commands.
Use the DELETE statement followed by the table name.
Add a WHERE clause to specify the rows to be deleted.
Use the TRUNCATE statement to delete all rows in a table.
Use the DROP statement to delete an entire table.
Be careful when deleting data as it cannot be recovered.
Examples: DELETE FROM table_name WHERE column_name = value;
TRUNCATE TABLE table_name;
DROP TABLE table_name;
Clustered index determines the physical order of data in a table while non-clustered index creates a separate structure.
Clustered index sorts and stores the data rows in the table based on their key values
Non-clustered index creates a separate structure that contains the key values and a pointer to the data row
A table can have only one clustered index while multiple non-clustered indexes can be created
Clustered index i...
based on 2 reviews
Rating in categories
Product Engineer
45
salaries
| ₹6 L/yr - ₹19 L/yr |
Senior Product Engineer
13
salaries
| ₹14.5 L/yr - ₹30 L/yr |
Senior Quality Engineer
12
salaries
| ₹7 L/yr - ₹18 L/yr |
Software Developer
10
salaries
| ₹5 L/yr - ₹11.5 L/yr |
Application Support Engineer
9
salaries
| ₹6 L/yr - ₹14 L/yr |
Druva
Freshworks
Zoho
Tally Solutions