CTSI Interview Questions and Answers

Q1. Solid principles,entity framework, db first, model first, object entity,to select row distinct which keyword should be used apart from distinct
Add your answer
Q2. How to handle db management when you want to insert bulk records
Ans. 
Use batch processing and transactions to efficiently insert bulk records into the database.
• Use batch processing to group multiple insert statements into a single transaction for better performance.

• Consider using stored procedures or bulk insert operations provided by the database management system.

• Optimize the database schema and indexing to improve insert performance.

• Monitor and tune the database server settings for h
Answered by AI
Add your answer

It was a technical round

Q1. What is the use of null indicator in cobol db2
Ans. 
Null indicator in COBOL DB2 is used to indicate whether a column value is null or not.
• Null indicator is a two-byte field that is associated with each nullable column in a DB2 table.

• It is used to check if a column value retrieved from the database is null or not.

• A null indicator value of -1 indicates that the column value is null, while a value of 0 or positive indicates the column value is not null.
Answered by AI
Add your answer
Q2. What is SOC7
Ans. 
SOC7 is a mainframe error code indicating a data exception.
• SOC7 is a mainframe error code that occurs when there is a data exception, typically due to invalid numeric data.

• It is commonly caused by trying to perform arithmetic operations on non-numeric data fields.

• Identifying and fixing the root cause of the data exception is crucial to resolving SOC7 errors.
Answered by AI
Add your answer

Q1. Dwh concept Sql
Add your answer
Q2. Etl concepts and data ware house concept basicstesting question
Add your answer
Q3. Project related questions then agile methodology
Add your answer
Q4. Sql related questions
Add your answer

Q1. Service basics for admin and developer
Add your answer