Tata AIG SMT Interview Questions and Answers

Q1. Oops concept and c# basic questions for freshers and sql basics
Add your answer
Q2. What is .net framework
Ans. 
.NET Framework is a software framework developed by Microsoft that provides a runtime environment for building and running applications.
• .NET Framework is a platform for developing and running applications on Windows.

• It includes a large library of pre-built code and a runtime environment for executing applications.

• It supports multiple programming languages such as C#, VB.NET, and F#.

• It provides features like memory mana...read more
Answered by AI
Add your answer
Q3. Stored procesure insert update syntax
Add your answer
Q4. Oops questions inheritance constructors
Add your answer
Q5. Joins in sql and types
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• There are different types of joins in SQL: inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all the rows from the left table and the matching rows from the right table.

• Right join returns all the rows from the right table and the matching ...read more
Answered by AI
Add your answer

Q1. What lib list ?
Ans. 
A list of libraries used in software development.
• Common libraries like React, Angular, jQuery

• Backend libraries like Express, Django, Spring

• Database libraries like Sequelize, SQLAlchemy, Hibernate
Answered by AI
Add your answer
Q2. What is Physical file
Ans. 
A physical file is a file stored on a physical storage device, such as a hard drive or solid-state drive.
• Physical files are stored on physical storage devices like hard drives or SSDs.

• They can be accessed and manipulated by software applications.

• Examples include text documents, images, videos, and executable programs.
Answered by AI
Add your answer

Q1. What is batch job
Ans. 
A batch job is a program that processes a large amount of data in a single run without user interaction.
• Batch jobs are typically scheduled to run at specific times, often during off-peak hours.

• They are commonly used for tasks such as data processing, report generation, and system maintenance.

• Examples of batch job tools include cron in Unix/Linux systems and Task Scheduler in Windows.
Answered by AI
Add your answer
Q2. What is interctive job
Ans. 
An interactive job is a task or project that requires active participation and engagement from the user.
• Interactive jobs involve real-time feedback and communication between the user and the system.

• Examples include video games, online surveys, and interactive websites.

• Users have control over the outcome of the task based on their input and decisions.
Answered by AI
Add your answer

Q1. What do you know about insurance
Ans. 
Insurance is a financial product that provides protection against specific risks in exchange for payment of a premium.
• Insurance is a contract between an individual or entity and an insurance company.

• The individual or entity pays a premium to the insurance company in exchange for coverage against specific risks.

• Types of insurance include health insurance, life insurance, auto insurance, and property insurance.

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

Q1. What do you like about HDFCergo
Add your answer

Q1. Tele me something about yourself
Add your answer
Q2. What is insurance
Ans. 
Insurance is a financial protection against potential losses or risks.
• Insurance is a contract between an individual or entity and an insurance company.

• The individual or entity pays a premium in exchange for coverage against specific risks.

• In case of a covered loss, the insurance company compensates the policyholder.

• Types of insurance include health, life, auto, home, and business insurance.

• Insurance helps individuals a...read more
Answered by AI
Add your answer

Q1. Self intro, Excel based questions etc
Add your answer

All aptitude type questions as well as core computer science subject questions comes

Profit loss , number system, code decode

Q1. What is DDL, DML, DQL
Ans. 
DDL stands for Data Definition Language, DML stands for Data Manipulation Language, and DQL stands for Data Query Language.
• DDL is used to define the structure of database objects such as tables, indexes, and views.

• DML is used to manipulate data in the database, such as inserting, updating, and deleting records.

• DQL is used to retrieve data from the database using queries.

• Examples: CREATE TABLE is a DDL statement, INSERT...read more
Answered by AI
Add your answer