Casepoint Intern Interview Questions and Answers

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