OpenText Technologies Principal Software Engineer Interview Questions and Answers

Round duration - 60 minutes
Round difficulty - Easy

This was a technical round with questions on DBMS.

Q1. What is data integrity?
Ans. 
Data integrity refers to the accuracy, consistency, and reliability of data throughout its lifecycle.
• Data integrity ensures that data is accurate and consistent in storage and transmission.

• It involves maintaining the quality and reliability of data over time.

• Methods for ensuring data integrity include checksums, encryption, and error detection codes.

• Examples of data integrity violations include data corruption, unautho
Answered by AI
Add your answer
Q2. What is a trigger in the context of a database management system?
Ans. 
A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.
• Triggers are used to enforce business rules, maintain data integrity, and automate repetitive tasks.

• They can be triggered by INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating related tables when a record is modified, or enforcing referential
Answered by AI
Add your answer
Q3. What is the difference between clustered and non-clustered indexes in a database management system?
Ans. 
Clustered indexes physically order the data in the table, while non-clustered indexes do not.
• Clustered indexes determine the physical order of data in the table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are faster for retrieval of data, especially range queries, compared to non-clustered indexes.

• Non-clustered indexes are stored se...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical interview round with questions on DBMS.

Q1. What is the difference between UNION and UNION ALL in SQL?
Ans. 
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
• UNION merges the result sets of two or more SELECT statements and removes duplicates.

• UNION ALL merges the result sets of two or more SELECT statements without removing duplicates.

• UNION is slower than UNION ALL as it involves removing duplicates.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column...read more
Answered by AI
Add your answer
Q2. What are the functions of a cursor in PL/SQL?
Ans. 
A cursor in PL/SQL is used to retrieve and process multiple rows of data one at a time.
• Allows iteration over a result set

• Retrieves data row by row

• Can be used to update or delete rows in a table

• Must be declared, opened, fetched, and closed
Answered by AI
Add your answer
Q3. Write a SQL query to fetch the nth highest salary from a table.
Ans. 
SQL query to fetch the nth highest salary from a table
• Use the ORDER BY clause to sort salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a managerial round with typical behavioral problems.

Round duration - 120 Minutes
Round difficulty - Medium

The test included MCQ questions from SQL, Linux Commands, C/C++ programming, Logical Reasoning, Aptitude questions. The other section was the coding round, where 2 SQL queries and 2 coding questions were there.

Q1. 
Subarray with Equal Occurrences Problem Statement
You are provided with an array/list ARR of length N containing only 0s and 1s. Your goal is to determine the number of non-empty subarrays where the numbe...read more
Ans. 
Count the number of subarrays where the number of 0s is equal to the number of 1s in a given array of 0s and 1s.
• Iterate through the array and keep track of the count of 0s and 1s encountered so far.

• Use a hashmap to store the count of 0s and 1s encountered at each index.

• For each index, check if the count of 0s is equal to the count of 1s encountered so far and update the result accordingly.
Answered by AI
Add your answer
Q2. 
Pythagorean Triplets Detection
Determine if an array contains a Pythagorean triplet by checking whether there are three integers x, y, and z such that x² + y² = z² within the array.
Input:
The first lin...read more
Ans. 
Detect if an array contains a Pythagorean triplet by checking if there are three integers x, y, and z such that x^2 + y^2 = z^2.
• Iterate through all possible triplets of numbers in the array and check if they form a Pythagorean triplet.

• Use a nested loop to generate all possible combinations of three numbers from the array.

• Check if the sum of squares of two numbers is equal to the square of the third number for each trip...read more
Answered by AI
Add your answer

Round duration - 50 Minutes
Round difficulty - Medium

This was a standard DSA round where I was asked to solve 2 questions and also code it in a production ready manner . At the end I was also asked some questions related to Linux and SQL . I was tested on some basic commands of Linux .

Q1. 
Palindromic Substrings Problem Statement
Given a string S, your task is to return all distinct palindromic substrings of the given string in alphabetical order.
Explanation:
A string is considered a pal...read more
Ans. 
Return all distinct palindromic substrings of a given string in alphabetical order.
• Iterate through all possible substrings of the given string.

• Check if each substring is a palindrome.

• Store distinct palindromic substrings in alphabetical order.
Answered by AI
Add your answer
Q2. 
Swap Two Numbers Problem Statement
Given two integers a and b, your task is to swap these numbers and output the swapped values.
Input:
The first line contains a single integer 't', representing the num...read more
Ans. 
Swap two integers 'a' and 'b' and output the swapped values.
• Create a temporary variable to store one of the integers before swapping.

• Swap the values of 'a' and 'b' using the temporary variable.

• Output the swapped values of 'a' and 'b'.
Answered by AI
Add your answer
Q3. What is meant by normalization and denormalization?
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity, while denormalization is the process of intentionally adding redundancy to improve query performance.
• Normalization involves breaking down a table into smaller tables and defining relationships between them to reduce redundancy and dependency.

• Denormalization involves combining tables or adding redundant data to...read more
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

This was a DS/Algo + Core round where I was asked questions related to DBMS , SQL queries and Linux Commands . The first question was of DSA and I was able to code it preety fast . I was also asked to execute some SQL queries on my laptop.
Overall , this round went good according to my opinion.

Q1. 
Anagram Pairs Verification Problem
Your task is to determine if two given strings are anagrams of each other. Two strings are considered anagrams if you can rearrange the letters of one string to form the...read more
Ans. 
Check if two strings are anagrams of each other by comparing their sorted characters.
• Sort the characters of both strings and compare them.

• Use a dictionary to count the frequency of characters in each string and compare the dictionaries.

• Ensure both strings have the same length before proceeding with comparison.

• Handle edge cases like empty strings or strings with different lengths.
Answered by AI
Add your answer
Q2. How would you delete duplicate emails from a database using SQL?
Ans. 
Use SQL query with GROUP BY and HAVING clause to delete duplicate emails from a database.
• Use GROUP BY clause to group emails together

• Use HAVING clause to filter out groups with more than one email

• Use DELETE statement to remove duplicate emails
Answered by AI
Add your answer
Q3. What is the difference between the DELETE and TRUNCATE commands in a DBMS?
Ans. 
DELETE removes specific rows from a table, while TRUNCATE removes all rows and resets auto-increment values.
• DELETE is a DML command, while TRUNCATE is a DDL command.

• DELETE can be rolled back, while TRUNCATE cannot be rolled back.

• DELETE triggers ON DELETE triggers, while TRUNCATE does not trigger any triggers.

• DELETE is slower as it maintains logs, while TRUNCATE is faster as it does not maintain logs.

• Example: DELETE FRO...read more
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

This was a typical HR round with some standard Behavioral questions .

Q1. What is something about you that is not included in your resume?
Add your answer
Q2. Why do you want to work at Amdocs?
Add your answer