Gateway Group Intern Interview Questions and Answers for Freshers

Q1. Sql joins and types of joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• F...read more
Answered by AI
Add your answer
Q2. Powerbi and done projects
Add your answer

Digital electronics, circuits , verilog , asic design flow

Q1. Explain the complete asic design flow process
Ans. 
ASIC design flow process involves steps like specification, design, verification, synthesis, and testing.
• Specification: Define requirements and constraints for the ASIC design.

• Design: Create a high-level design based on the specifications.

• Verification: Verify the design using simulations and tests.

• Synthesis: Convert the design into a netlist of gates and connections.

• Testing: Test the fabricated ASIC to ensure functiona...read more
Answered by AI
Add your answer
Q2. Power reduction techniques in CMOS
Ans. 
Power reduction techniques in CMOS involve various methods to minimize power consumption in CMOS circuits.
• Use of power gating to selectively turn off power to unused circuit blocks

• Implementing clock gating to disable clock signals to unused circuitry

• Utilizing voltage scaling to reduce power consumption at lower voltages

• Applying dynamic voltage and frequency scaling to adjust voltage and frequency based on workload

• Using...read more
Answered by AI
Add your answer

It was conducted through hackerrank platform which contains 5 programming questions

There were 3 sections

Q1. How to switch variable
Ans. 
To switch variable values, use a temporary variable to hold one value while swapping the other.
• Create a temporary variable to hold the value of one variable

• Assign the value of the second variable to the first variable

• Assign the value of the temporary variable to the second variable
Answered by AI
View 1 more amswer
Q2. They about your introduction and background
Add your answer

Create a small code

Q1. Self introduction
Add your answer
Q2. Where you want to see your self after five years
Add your answer
Q3. Why you choose this project
Add your answer

Q1. Self introduction
Add your answer
Q2. Basic technical question
Add your answer
Q3. Project related question
Add your answer

Commands of docker, git

Q1. Commands of Git
Add your answer