Add office photos
i
Wipro
Compare
Filter interviews by
Wipro SQL and MSBI Developer Interview Questions and Answers
Wipro SQL and MSBI Developer Interview Experiences
1 interview found
Anonymous
I applied via Newspaper Ad and was interviewed in Nov 2021. There were 2 interview rounds.
(2 Questions)
- Q1. What is your biggest achievement so for?
- Q2. Why do u want to work for our company
Interview Preparation Tips
Interview questions from similar companies
Selected
I applied via Referral and was interviewed in Sep 2023. There were 3 interview rounds.
(3 Questions)
- Q1. How can you segregate data from one file to many file based on data value of a particular column.
- Ans.
Use SQL queries to filter data based on a particular column value and export to separate files.
Use SELECT statement with WHERE clause to filter data based on the particular column value
Use INSERT INTO statement to insert the filtered data into separate tables or files
Consider using a loop or cursor to iterate through the data and export to multiple files
- Q2. How to access multiple data file place in same directory.
- Ans.
To access multiple data files in the same directory, use a wildcard character (*) in the file path.
Use a wildcard character (*) in the file path to access all files in the directory.
For example, to access all CSV files in a directory, use 'SELECT * FROM folder_path/*.csv'.
Make sure the SQL query or MSBI package is configured to handle multiple files.
- Q3. How to delete data if there is no primary key while there are repeated data sets
- Ans.
You can delete data without a primary key by using a combination of columns to identify and remove duplicate records.
Identify unique combination of columns to differentiate between duplicate records
Use the identified columns in a DELETE statement to remove duplicate records
Consider using temporary tables or CTEs to handle the deletion process efficiently
Scenario based questions
(2 Questions)
- Q1. Why you want to join Capgemini?
- Q2. What makes you confident that Capgemini will offer you?
Interview Preparation Tips
(2 Questions)
- Q1. Explain sql commands
- Q2. Explain normalization in sql
Selected
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
Sql
ddl
dml
tcl
dql
joins
view
date commit
Date commit
joins
view
sum
max
avg
count
min
(1 Question)
- Q1. What is sql , index , stored proc , triggers
(2 Questions)
- Q1. Difference bw table and matrix
- Ans.
A table is a two-dimensional representation of data, while a matrix is a multi-dimensional representation of data.
Tables have rows and columns, while matrices can have multiple dimensions.
Tables are typically used for simple data structures, while matrices are used for more complex data analysis.
In Power BI, tables are used for displaying data in a tabular format, while matrices are used for creating pivot tables and c
- Q2. Syntax for Calculate function
- Ans.
Calculate function in DAX is used to evaluate an expression for a specific filter context.
Syntax: CALCULATE(
, , , ...) Can be used to apply filters to an expression
Can override existing filters in the current context
Example: CALCULATE(SUM(Sales[Amount]), Sales[Region] = 'North')
(2 Questions)
- Q1. Tell about your self
- Q2. Interested Technology
(2 Questions)
- Q1. What is SQL where it use
- Ans.
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables
Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE
- Q2. What is Join and Procedure
- Ans.
Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Procedure is a set of SQL statements stored in the database and executed when called
Procedures can accept input parameters
Skills evaluated in this interview
(2 Questions)
- Q1. Architecture of sql
- Ans.
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
- Q2. Recovery models
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. How to insert multiple values in one go
- Ans.
Use the INSERT INTO statement with multiple value sets separated by commas
Use the INSERT INTO statement followed by the table name
List the column names in parentheses after the table name
Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
- Q2. Update query using joins
- Ans.
Update query using joins in SQL
Use UPDATE statement with JOIN clause to update data in multiple tables
Specify the tables to be updated and joined using ON clause
Set the columns to be updated in SET clause
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
Test your algorithmic thinking and problem solving skills
(1 Question)
- Q1. Communications,clearity of answers
(1 Question)
- Q1. Discussion about packages,joining date
Interview Preparation Tips
Wipro Interview FAQs
Tell us how to improve this page.
Wipro Interviews By Designations
- Wipro Project Engineer Interview Questions
- Wipro Software Engineer Interview Questions
- Wipro Software Developer Interview Questions
- Wipro Associate Interview Questions
- Wipro Senior Software Engineer Interview Questions
- Wipro Technical Lead Interview Questions
- Wipro Senior Associate Interview Questions
- Wipro Process Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- MS SQL DBA Interview Questions
- Msbi Developer Interview Questions
- SQL Developer Interview Questions
- MSBI and Power BI Developer Interview Questions
- SQL Database Administrator Interview Questions
- SQL and PL SQL Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- SQL Server Developer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Wipro SQL and MSBI Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Project Engineer
32.6k
salaries
|  ₹1.8 L/yr - ₹8.3 L/yr |
|
Senior Software Engineer
22.9k
salaries
| ₹5.8 L/yr - ₹22.4 L/yr |
|
Senior Associate
21.1k
salaries
| ₹0.8 L/yr - ₹5.5 L/yr |
|
Senior Project Engineer
20.6k
salaries
| ₹5 L/yr - ₹19.1 L/yr |
|
Technical Lead
18.6k
salaries
| ₹8.2 L/yr - ₹36 L/yr |
TCS
Infosys
Tesla
Amazon
Calculate your in-hand salary
- Home >
- Interviews >
- Wipro Interview Questions >
- Wipro SQL and MSBI Developer Interview Questions
