i
TCS
Filter interviews by
A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database management system.
Triggers can be used to enforce business rules, maintain referential integrity, or audit changes to data.
Examples of triggers include automatically updating a timestamp when a record is modified, preventing deletion of a record based on certain conditions, or sending an email notification w
DBMS stands for Database Management System. Normalization in Oracle is the process of organizing data in a database efficiently.
DBMS is a software that manages databases, allowing users to store, retrieve, and manipulate data.
Normalization in Oracle involves organizing data into tables and columns to reduce redundancy and improve data integrity.
There are different levels of normalization, such as First Normal Form (1NF...
I applied via LinkedIn and was interviewed in Dec 2021. There were 5 interview rounds.
Performance improvement can be managed through setting clear goals, providing feedback, and offering training and development opportunities.
Set specific and measurable goals for employees to work towards
Provide regular feedback and coaching to help employees improve
Offer training and development opportunities to enhance skills and knowledge
Recognize and reward employees for their achievements
Create a culture of continu...
Steps to follow for MSTR to Power BI migration
Assess the current MSTR environment and identify the reports and dashboards to be migrated
Map the data sources and connections used in MSTR to Power BI equivalents
Recreate the reports and dashboards in Power BI using the mapped data sources
Test the migrated reports and dashboards to ensure accuracy and functionality
Train users on the new Power BI environment and retire the
I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 5 interview rounds.
Designing test data content for different flavors of DB
Identify the data types and structures for each DB flavor
Create test data that covers all possible scenarios and edge cases
Ensure data consistency and accuracy across all DB flavors
Consider performance and scalability factors for distributed DBs
Include mainframe-specific data such as EBCDIC encoding and packed decimal formats
New technologies of DBMS are constantly emerging to improve data management and analysis.
New SQL databases like CockroachDB and TiDB are gaining popularity for their scalability and distributed architecture.
NoSQL databases like MongoDB and Cassandra are widely used for their flexibility and ability to handle unstructured data.
Graph databases like Neo4j and OrientDB are becoming popular for their ability to handle compl...
I applied via Naukri.com and was interviewed in Apr 2021. There was 1 interview round.
Gang of Four design patterns are a set of 23 software design patterns that were introduced in the book 'Design Patterns: Elements of Reusable Object-Oriented Software'.
Gang of Four design patterns were identified by Erich Gamma, Richard Helm, Ralph Johnson, and John Vlissides.
These patterns are categorized into three groups: creational, structural, and behavioral.
Examples of Gang of Four design patterns include Singlet
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.
I applied via Approached by Company and was interviewed in Sep 2023. There were 4 interview rounds.
I applied via Recruitment Consulltant and was interviewed in May 2024. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 23 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹0 L/yr - ₹0 L/yr |
IT Analyst
66.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
AST Consultant
51.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
29.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Amazon
Wipro
Infosys
Accenture