Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Query to display duplicate records without using group by
Use self-join to compare records
Select records where the values match but the primary key is different
Example: SELECT a.* FROM table a, table b WHERE a.value = b.value AND a.id <> b.id
The 'FOR XML' command is used in SQL Server to generate XML output from a query result.
It allows transforming the result set of a query into XML format.
It can be used to generate XML documents for data exchange or integration purposes.
The 'FOR XML' command supports different modes like RAW, AUTO, EXPLICIT, and PATH.
It can be combined with other SQL Server features like joins, aggregations, and subqueries.
Example: SELEC
stuff() replaces a specified number of characters with another string, while substring() extracts a portion of a string.
stuff() is used to replace a specified number of characters in a string with another string.
substring() is used to extract a portion of a string based on the starting and ending index.
stuff() can be used to mask sensitive data in a string, such as credit card numbers.
substring() can be used to extract...
Transaction property in SSIS ensures all tasks in a package are completed or rolled back as a single unit.
Transaction property is used to ensure data consistency in a package
If a task fails, all previous tasks are rolled back
If all tasks complete successfully, they are committed as a single unit
Transaction property can be set at package or container level
Supported isolation levels are Serializable, Repeatable Read, Rea
The connection string can be passed on runtime using various methods.
One way is to use a configuration file and read the connection string from it.
Another way is to pass the connection string as a parameter to the application.
The connection string can also be stored in a database and retrieved at runtime.
Using environment variables is also a common method to pass connection strings.
Connection strings can be encrypted a...
Static class and static constructor in C#
Static class can only contain static members and cannot be instantiated
Static constructor is called only once when the class is first accessed
Static constructor is used to initialize static members of the class
Example: Math class in C# is a static class
Example: static constructor can be used to initialize a static variable with a value
Performance improvement in Angular app
Use lazy loading to load modules on demand
Optimize change detection strategy
Use trackBy function in ngFor loops
Minimize DOM manipulation
Use AOT compilation
Implement server-side rendering
Use web workers for heavy computations
Use caching for frequently accessed data
Performing web application penetration testing on a website with firewall enabled.
Identify the type of firewall and its configuration
Perform reconnaissance to gather information about the target
Identify vulnerabilities and exploit them
Use tools like Burp Suite, Nmap, and Metasploit
Test for common web application vulnerabilities like SQL injection and cross-site scripting
Document findings and provide recommendations for
I applied via Walk-in and was interviewed before Dec 2021. There were 3 interview rounds.
The planning if the project and how to take over the project
We should maintain the aptitude to with our project and with with
I applied via Naukri.com and was interviewed in Jan 2021. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.
Steps for Azure migration from onprem to cloud and Hyper V migration using VMWARE tool.
Assess on-premises environment
Choose appropriate migration method
Prepare Azure environment
Migrate data and applications
Optimize and secure migrated resources
VMware tool used for migration: VMware vCenter Converter
Hyper-V migration can be done using Azure Site Recovery
I applied via Naukri.com and was interviewed in Mar 2021. There were 4 interview rounds.
Memory management is crucial for efficient application performance.
Memory allocation and deallocation should be done carefully to avoid memory leaks.
Unused memory should be released to prevent memory fragmentation.
Memory profiling tools can help identify memory-related issues.
Caching can improve performance by reducing the need for frequent memory allocation.
Examples: Java's garbage collector, C++'s smart pointers, iOS
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There were 3 interview rounds.
based on 1 review
Rating in categories
Application Development Analyst
39k
salaries
| ₹3 L/yr - ₹12 L/yr |
Application Development - Senior Analyst
27.4k
salaries
| ₹7 L/yr - ₹20.2 L/yr |
Team Lead
24.9k
salaries
| ₹7.2 L/yr - ₹25.7 L/yr |
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹20 L/yr |
Senior Analyst
17.9k
salaries
| ₹5.5 L/yr - ₹21.3 L/yr |
TCS
Cognizant
Capgemini
Infosys