PlayShifu UI UX Designer and Graphic Designer Interview Questions and Answers

Sql question joins and , retention, streaks , window function

Required to write codes in python

Required to write codes in python

Q1. Time to tackle difficulties
Add your answer
Q2. Time to learn things outside school
Add your answer

Aptitude questions were pretty easy like on speed etc

Coding questions were also easy like patterns code, reverse string just basics

SQL Coding Test - asked 5 queries related to joins, ranks, group by

Asked guesstimates, technical CV Question, case

Asked guesstimate, market entry question, case

Q1. What is bug in any application?
Ans. 
A bug in an application is an error, flaw, failure, or fault in the software code that causes it to produce incorrect or unexpected results.
• Bugs can range from simple syntax errors to complex logic issues.

• Common types of bugs include logic errors, syntax errors, and runtime errors.

• Examples of bugs include a calculator app displaying incorrect results, a website crashing when a specific button is clicked, or a game free
Answered by AI
Add your answer

Q1. What is the life cycle of bug?
Ans. 
Bug life cycle includes identification, reporting, fixing, retesting, and closing.
• Identification: Bug is identified by testers during testing.

• Reporting: Testers report the bug to developers.

• Fixing: Developers fix the bug in the code.

• Retesting: Testers retest the fixed bug to ensure it is resolved.

• Closing: Once bug is confirmed fixed, it is closed.
Answered by AI
Add your answer

Q1. Why team bonding is needed for healthy work culture?
Add your answer

3 online dsa questions easy to medium

Q1. Write a sql query
Ans. 
SQL query to retrieve employee names and their salaries from a table
• Use SELECT statement to retrieve data

• Specify the columns you want to retrieve (employee names and salaries)

• Specify the table name where the data is stored
Answered by AI
Add your answer
Q2. Formula of vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
• VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

• The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...read more
Answered by AI
Add your answer

Round duration - 90 Minutes
Round difficulty - Medium

The first round was scheduled in the evening time.
First of all interviewer introduced himself and after my introduction 
He directly shoot first DSA question. The question was easy but conceptual. I have solved some question with same concept and he ask me to share the screen and code in online compiler. Finally I was able to get correct output with all the use cases and I was like "Half work done!"
Then he asked me very core concepts of JavaScript along with that Some Output based questions.
Then finally he asked me theory questions on React along with my experience in React. 
The interviewer was very helpful as well as polite. I don't think if he will not help me during interview I could crack the interview

Q1. 
Is the Sentence a Pangram?
Ninja is relocating to a place called NinjaGram, and for school admission, he is required to identify if a given sentence is a pangram. Your task is to assist Ninja in determini...read more
Ans. 
Yes, the sentence is a pangram if it includes every letter of the English alphabet at least once.
• Check if the sentence contains all 26 letters of the English alphabet.

• Convert the sentence to lowercase to simplify the checking process.

• Use a set to keep track of the letters present in the sentence.

• Iterate through the sentence and add each unique letter to the set.

• After iterating, check if the set contains all 26 letters.
Answered by AI
Add your answer