Pratian Technologies Software Engineer Intern Trainee Interview Questions and Answers

Q1. Strecture of sql statement
Ans. 
SQL statements are used to interact with databases by performing operations like querying, updating, and deleting data.
• SQL statements are made up of keywords like SELECT, INSERT, UPDATE, DELETE, etc.

• They are structured in a specific order, with clauses like WHERE, ORDER BY, GROUP BY, etc.

• Tables are referenced using their names, and conditions are specified to filter data.

• Joins can be used to combine data from multiple
Answered by AI
Add your answer

JavaScript, React Js

Q1. How many years of relevant experience
Add your answer
Q2. What is your current CTC
Add your answer
Q3. What is your Expectation
Add your answer

Q1. What is your Strength
Add your answer
Q2. What is weakness
Ans. 
One weakness I have is that I can be overly critical of my own work, which can sometimes lead to self-doubt.
• I tend to overthink things and can be indecisive at times

• I have a tendency to take on too many tasks at once, leading to feeling overwhelmed

• I struggle with public speaking and often get nervous in front of large groups
Answered by AI
Add your answer
Q3. What is your Goal
Add your answer

ASP NET MVC Interview Questions and Answers
Explain the MVC application life cycle.
What do you understand by filters in MVC.
What is the function of beforeRender() in the controller.
What do you know about beforeFilter() and afterFilter() functions in controllers.
What is attribute-based routing in MVC.
What is the difference between ‘ViewResult’ and ‘ActionResult’.
Define MVC’s partial view.
What is MVC Scaffolding.
Define ORM and give its use.
Define POST and GET action types.
In the ASP.NET Core project, which basic folders use the MVC template without Areas.
What do you understand by WebAPI.
What do you understand by ViewState in MVC.
Classes and Objects.
Interfaces and Inheritance.
What is the difference between static, public, and void.
What is an object.
Define Constructors.
What is the difference between out and ref parameters.
Name all the C# access modifiers.
What are reference types and value types.
What are sealed classes in C#.
What is method overloading.
What is the difference between Arraylist and Array .
What’s the difference between an abstract and interface class.
What is SQL.
What is the difference between SQL and MySQL.
What are Constraints in SQL.
What is a Primary Key.
What is a UNIQUE constraint.
What is a Foreign Key
What is a Join? List its different types.
What is an Index? Explain its different types.
What is the difference between Clustered and Non-clustered index.
What is a View.
What are the TRUNCATE, DELETE and DROP statements.
What are Aggregate and Scalar functions.
What is a Stored Procedure.

Asp .net MVC CRUD Operation
Web API

Q1. HR Overview discussion.....,
Add your answer

Develop a UI screen with 10 fields on it.

Q1. Mongoose Framework, SQL - Store Procedures, Triggers, Views, Crystal Reports,
Add your answer

Q1. Offer letter discussion. Joining date discussion.
Add your answer

6 DSA Questions which was of level easy to medium and can solve in any of the language.

Q1. Write a function to convert a roman numeral to integer.
Ans. 
Function to convert Roman numeral to integer
• Create a dictionary mapping Roman numerals to their integer values

• Iterate through the input Roman numeral string from right to left

• If current numeral value is less than the next numeral value, subtract it from the total

• Otherwise, add it to the total

• Return the total integer value
Answered by AI
Add your answer
Q2. Valid Parenthesis function program DSA
Ans. 
A function to check if a string of parentheses is valid
• Use a stack data structure to keep track of opening parentheses

• Iterate through the string and push opening parentheses onto the stack

• When encountering a closing parenthesis, pop from the stack and check if it matches the corresponding opening parenthesis

• If stack is empty at the end and all parentheses have been matched, the string is valid
Answered by AI
Add your answer

Q1. Can you tell me little about yourself.
Add your answer
Q2. What motivates you to perform well?
Add your answer

Q1. Angular life cycle hooks?
Add your answer
Q2. What is Angular pipe?
Ans. 
Angular pipe is a feature in Angular that allows you to transform data in templates.
• Angular pipes are used to format data before displaying it in the view.

• They can be used to filter, sort, or transform data in various ways.

• Examples of Angular pipes include DatePipe, UpperCasePipe, and CurrencyPipe.
Answered by AI
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Are you ready to work in shifts?
Add your answer

Q1. Personal information!
Add your answer

Q1. General software testing questions where asked
Add your answer