APPLIED INFORMATICS INC Intern Interview Questions and Answers

Normal level questions, 20 questions were there and they were little lengthy

Q1. What are different types of transactions in SQL
Ans. 
Different types of transactions in SQL include DML, DDL, DCL, and TCL.
• DML (Data Manipulation Language) - Used for manipulating data in a database (e.g. INSERT, UPDATE, DELETE)

• DDL (Data Definition Language) - Used for defining database schema (e.g. CREATE, ALTER, DROP)

• DCL (Data Control Language) - Used for controlling access to data (e.g. GRANT, REVOKE)

• TCL (Transaction Control Language) - Used for managing transactions
Answered by AI
Add your answer
Q2. Difference between truncate and delete
Ans. 
Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows.
• Truncate is faster and uses less system resources compared to delete.

• Truncate resets the identity seed of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.

• Truncate is not logged in the
Answered by AI
Add your answer

1 hour test contains 2 coding questions.

Q1. Delete a node from Singly and doubly linked list
Ans. 
To delete a node from a singly or doubly linked list, update the pointers of the previous and next nodes.
• For a singly linked list, update the next pointer of the previous node to skip the node to be deleted.

• For a doubly linked list, update the next pointer of the previous node and the previous pointer of the next node to skip the node to be deleted.
Answered by AI
Add your answer
Q2. Validate an email using regex pattern
Ans. 
Use regex pattern to validate an email address
• Use regex pattern /^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$/

• Ensure email has valid format with username, @ symbol, domain, and top-level domain

• Test regex pattern against different email addresses for validation
Answered by AI
Add your answer

2 DSA questions were given

Q1. Oops concept Like inheritance
Add your answer
Q2. Question mainly based on my projects
Add your answer

Q1. What is thermal engineering
Add your answer

Q1. Introduce yourself to us
Add your answer

Leetcode question , gfg also

Q1. Tell us about your self
Add your answer
Q2. Explain this project
Ans. 
The project involved developing a mobile application for tracking daily water intake.
• Developed a user-friendly interface for inputting water consumption

• Implemented a feature to set daily water intake goals

• Integrated notifications to remind users to drink water throughout the day
Answered by AI
Add your answer

Q1. Tell me about your self
Add your answer
Q2. Mission vision of the company
Add your answer
Q3. Agrement and relocation
Add your answer

It was easy. It was basic question.

It was a bit diff as everyone was a bit aggressive

Q1. It was long and difficult.
Add your answer
Q2. Tel about all ml algo
Ans. 
Machine learning algorithms are used to analyze data, make predictions, and automate decision-making processes.
• ML algorithms can be categorized into supervised, unsupervised, and reinforcement learning.

• Examples of ML algorithms include linear regression, decision trees, support vector machines, k-means clustering, and neural networks.

• ML algorithms require labeled data for supervised learning and can learn patterns from
Answered by AI
Add your answer