SMC Corporation Interview Questions and Answers

Q1. Last company products discussion or some technical discussion
Add your answer

Q1. General information about how to work in last company
Add your answer

Q1. Sales interview questions with GM
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why you want to change
Add your answer

Q1. BTech biotechnology 3th year
Add your answer

Q1. BTech biotechnology 3th year student
Add your answer

Q1. What is cursor and types
Ans. 
A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statement.
• A cursor is used to retrieve data row by row from a result set.

• There are two types of cursors: Implicit and Explicit.

• Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.

• Cursor variables can be used to pass cursors as parameters to procedures and functi
Answered by AI
Add your answer
Q2. Truncate & delete difference
Ans. 
Truncate removes all data from a table while delete removes specific rows.
• Truncate is faster than delete as it doesn't log individual row deletions

• Truncate cannot be rolled back while delete can be

• Truncate resets the identity of the table while delete doesn't

• Truncate doesn't fire triggers while delete does
Answered by AI
Add your answer
Q3. Explain about trigger
Ans. 
A trigger is a special type of stored procedure that automatically executes in response to certain events.
• Triggers are used to enforce business rules or to perform complex calculations.

• They can be defined to execute before or after a data modification operation.

• Triggers can be used to audit changes to data or to replicate data changes to other tables.

• Examples of events that can trigger a trigger include INSERT, UPDATE,...read more
Answered by AI
Add your answer

Q1. About your self
Add your answer
Q2. About work experience
Add your answer
Q3. About salary expectation
Add your answer

Written test process is there

Q1. About company products
Add your answer
Q2. Related to company products
Add your answer

Q1. Final discussion on salary and joining
Add your answer

Q1. What is basic pneumatic component.
Ans. 
A basic pneumatic component is a device that uses compressed air to perform a mechanical task.
• Examples include cylinders, valves, and air motors.

• Cylinders convert the energy from compressed air into linear motion.

• Valves control the flow of compressed air to different parts of a system.

• Air motors use compressed air to generate rotational motion.

• Pneumatic components are commonly used in manufacturing and automation appli
Answered by AI
Add your answer

Q1. Draw a basic pneumatic circuit
Ans. 
A pneumatic circuit is a closed system that uses compressed air to power mechanical devices.
• Start with a compressor to generate compressed air

• Use a filter to remove any impurities from the air

• Connect the air to a directional control valve to control the flow of air

• Connect the valve to an actuator, such as a cylinder or motor, to convert the air pressure into mechanical motion

• Use a pressure regulator to control the amou...read more
Answered by AI
Add your answer