Titan Company Interview Questions, Process, and Tips for Experienced

Q1. Kaun sa movment repair kar sakte ho
Add your answer
Q2. Movment me kaun se Parts replace hua hai
Add your answer
Q3. Kaun se tools yuj an thuroo
Add your answer
Q4. Wizard 2000 me kitne funtion
Add your answer
Q5. Movment number & spare name
Add your answer
Q6. Customer ko kaise aten karna hai
Add your answer
Q7. Customer watch check and clean to open
Add your answer

Q1. Difference between decode and case?
Ans. 
Decode is a function in Oracle that is used to provide if-then-else type of logic, while Case is used for conditional logic with multiple conditions.
• Decode is used for simple if-then-else logic, while Case is used for more complex conditional logic.

• Decode can only handle equality conditions, while Case can handle a variety of conditions.

• Case allows for multiple conditions and multiple results, while Decode only allows ...read more
Answered by AI
Add your answer
Q2. How will we handle exceptions in Bulk Collect?
Ans. 
Exceptions in Bulk Collect can be handled using SAVE EXCEPTIONS clause and FORALL statement.
• Use SAVE EXCEPTIONS clause to handle exceptions in Bulk Collect.

• Use FORALL statement to process the data and handle exceptions efficiently.

• Exceptions can be logged, ignored, or handled based on the business requirements.
Answered by AI
Add your answer
Q3. What are Cursor attributes?
Ans. 
Cursor attributes are properties that provide information about the status of a cursor in PL/SQL.
• Cursor attributes include %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN.

• They are used to check the status of a cursor after a DML operation.

• For example, %FOUND returns TRUE if a fetch operation successfully retrieves a row.
Answered by AI
Add your answer
Q4. What is pragma autonomous transaction?
Ans. 
Pragma autonomous transaction is used to create a new transaction within the current transaction.
• Pragma autonomous transaction allows a subprogram to start a new transaction that is independent of the calling transaction.

• This is useful when you need to commit or rollback changes made by the subprogram without affecting the main transaction.

• It is commonly used in triggers, where you want to perform some actions independ...read more
Answered by AI
Add your answer
Q5. Concat function
Add your answer

About the project: Department.

Q1. They inquired for detailed information about the project department basic
Add your answer

Q1. Type of starters
Add your answer
Q2. Plc related questions
Add your answer