Protean eGov Technologies 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
Add your answer
Q2. Difference between truncate and delete
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

Normal deign questions

Q1. DBMS VS FS describe
Ans. 
DBMS is a software system that manages databases, while FS is a system that manages files and directories.
• DBMS stores data in structured format with relationships between entities

• FS stores data in files and directories without relationships

• DBMS provides ACID properties for transactions

• FS does not provide ACID properties

• Examples: MySQL, Oracle for DBMS; NTFS, ext4 for FS
Answered by AI
Add your answer
Q2. Basic java Q & A
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

MCQs and one question

One medium problem about custom comparators

Q1. House robber problem leetcode
Add your answer
Q2. Next Greater element problem leetcode
Add your answer

Was moderate in term of difficulty

Took a long time to finish

Q1. Introduce yourself
Ans. 
I am a recent graduate with a degree in Computer Science and a passion for software development.
• Recent graduate with a degree in Computer Science

• Passionate about software development

• Experience with programming languages such as Java, Python, and JavaScript
Answered by AI
Add your answer
Q2. Explain your project on resumw
Ans. 
Developed a mobile app for tracking daily water intake and setting hydration goals.
• Designed user-friendly interface for inputting water consumption

• Implemented reminder notifications to encourage regular hydration

• Incorporated gamification elements to motivate users to reach their hydration goals
Answered by AI
Add your answer

120 min,Maths, Reasoning,Verbal Ability Basic Questions

Q1. How will you save your database from getting manipulated.
Ans. 
Implementing proper security measures like encryption, access control, and regular backups can help prevent database manipulation.
• Use encryption to protect sensitive data from unauthorized access.

• Implement access control to restrict who can make changes to the database.

• Regularly backup the database to ensure data can be restored in case of manipulation.

• Use parameterized queries to prevent SQL injection attacks.

• Monitor
Answered by AI
Add your answer
Q2. I didn't answer
Add your answer