TCS BI Developer Interview Questions and Answers

Q1. Roles and Responsibilities
Add your answer
Q2. Qliksense Migration
Add your answer

Q1. Reason for separation
Add your answer

Q1. Qlik related questions were asked
Add your answer

Q1. Roles And Responsibilities and Power BI Questions
Add your answer

Q1. Generic Salary Discussion
Add your answer

Basic apptitude qwuestions were asked

Q1. Questions on java and cybersecurity what is cybersecurity what is malware and ransomeware
Add your answer
Q2. What is java how is it different from python
Ans. 
Java is a statically typed, object-oriented programming language, while Python is dynamically typed and focuses on simplicity and readability.
• Java is statically typed, meaning variables must be declared with a specific data type, while Python is dynamically typed.

• Java is more verbose and requires more code to accomplish tasks compared to Python.

• Python emphasizes simplicity and readability, making it easier for beginner...read more
Answered by AI
Add your answer

Q1. Introduction why ltimindtree
Ans. 
I chose Mindtree because of its reputation for innovation, collaborative work culture, and opportunities for growth.
• Reputation for innovation: Mindtree is known for its cutting-edge technology solutions and innovative projects.

• Collaborative work culture: Mindtree fosters a team-oriented environment where employees can learn and grow together.

• Opportunities for growth: Mindtree offers various training programs and career...read more
Answered by AI
Add your answer
Q2. Relocation situastion based questions
Add your answer

Q1. Sliding Window find the subarray with sum equal to k
Ans. 
Using sliding window technique to find subarray with sum equal to k.
• Initialize two pointers at the start of the array.

• Move the right pointer to expand the window until the sum is greater than or equal to k.

• Move the left pointer to shrink the window if the sum exceeds k.

• Repeat until the end of the array is reached.

• Example: Input array [1, 4, 20, 3, 10, 5], k=33. Output: [20, 3, 10].
Answered by AI
Add your answer

Q1. Given UI task display like display boxes side by side in desktop screen and one after the other in mobile screen using media queries?
Add your answer
Q2. Explain difference between authorization vs authentication?
Ans. 
Authentication verifies a user's identity, while authorization determines what a user can access.
• Authentication confirms a user's identity through credentials like username and password.

• Authorization controls access to resources based on the authenticated user's permissions.

• Example: Logging into a website (authentication) and then being able to view/edit specific pages based on your role (authorization).
Answered by AI
Add your answer
Q3. How to render list in react? Also explain difference between state vs prop in react?
Ans. 
To render a list in React, use map() function to iterate over an array of data and return a list of components. State is mutable data managed within a component, while props are immutable data passed from parent to child components.
• To render a list in React, use map() function to iterate over an array of data and return a list of components.

• Example: const items = ['item1', 'item2', 'item3']; items.map(item =>

• read more
Answered by AI
Add your answer

Q1. What are the webpage optimization techniques? How to check webpage optimization? In lighthouse optimization reports , how to fix issue related render blocking scripts?
Ans. 
Webpage optimization techniques include minifying CSS and JS files, optimizing images, using asynchronous loading for scripts, and reducing render-blocking scripts.
• Minify CSS and JS files to reduce file sizes and improve loading times.

• Optimize images by compressing them and using the correct file format (e.g. JPEG for photographs, PNG for graphics).

• Use asynchronous loading for scripts to prevent them from blocking the ...read more
Answered by AI
Add your answer
Q2. Write scss code nested li element by applying background color 2 element and also use mixins?
Ans. 
Use SCSS to apply background color to nested li elements and utilize mixins.
• Use nesting to target the li elements within a parent element

• Apply background color to the 2nd li element using the :nth-child() selector

• Define and use mixins to reuse styles across the codebase
Answered by AI
Add your answer
Q3. How to fix cumulative layout shift issues?
Ans. 
To fix cumulative layout shift issues, ensure all images and media have dimensions specified in HTML, use CSS aspect ratio boxes, and prioritize loading critical resources.
• Specify dimensions for all images and media in HTML to prevent layout shifts.

• Use CSS aspect ratio boxes to reserve space for images before they load.

• Prioritize loading critical resources to avoid sudden layout changes.
Answered by AI
Add your answer

Q1. Write MySQL query to find employee with 2nd Highest salary
Ans. 
Use MySQL query with ORDER BY and LIMIT to find employee with 2nd highest salary.
• Use ORDER BY salary DESC to sort salaries in descending order

• Use LIMIT 1,1 to skip the highest salary and get the second highest salary
Answered by AI
Add your answer
Q2. What is branch in git
Ans. 
A branch in git is a separate line of development that allows you to work on features or fixes without affecting the main codebase.
• Branches allow for parallel development

• They can be created, switched between, merged, and deleted

• Common branches include master, develop, feature branches, and release branches
Answered by AI
Add your answer