Sequretek It Solutions Linux Administrator L2 Interview Questions and Answers

Q1. Last company job description
Add your answer

Q1. They will only check your attitude.
Add your answer
Q2. Simple question like tell me about yourself, experiences education etc
Add your answer

Q1. They will tell you the JD and ask you similar questions.
Add your answer

Q1. They will simply ask about yourself and nothing
Add your answer

Q1. It was a basic introduction with HR
Add your answer

Q1. 2nd round was with Operation Head basically he wanted to know that are you comfortable with shifts and long office hours without and expectations.
Add your answer

Q1. Direction will ask you some basic questions and congrats you are good to go
Add your answer

Q1. Basic javascript and angular
Add your answer

Q1. Js and angular questions
Add your answer

Q1. Coding questions on Data Structures
Add your answer
Q2. SQL query to find salary department wise
Ans. 
Use SQL query to find salary department wise
• Use GROUP BY clause to group salaries by department

• Use SUM() function to calculate total salary for each department

• Join with department table if necessary to get department names
Answered by AI
Add your answer

Medium DSA question on dynamic programming

Q1. Describe the Project Architecture End-to-End
Ans. 
The project architecture end-to-end includes the overall design and structure of the project from start to finish.
• The architecture should include the hardware and software components, as well as the communication protocols and data flow.

• It should also consider the scalability, security, and performance of the system.

• Examples of project architecture include client-server, microservices, and event-driven architectures.

• Th...read more
Answered by AI
Add your answer
Q2. Explain how will you implement SCD Type 2.
Ans. 
SCD Type 2 is implemented by creating a new record for each change and maintaining a history of changes.
• Identify the business key and version number for the dimension table.

• Create a new record with a new version number for each change to the dimension data.

• End-date the previous record and start-date the new record to maintain a history of changes.

• Use effective dates to determine which record is active at any given poin...read more
Answered by AI
Add your answer

Q1. Display only those elements which do not occur more than once.
Ans. 
Display non-repeated elements
• Iterate through the elements and count their occurrences

• Display only those elements with occurrence count of 1

• Use a hash table or dictionary to store the counts

• Time complexity: O(n)
Answered by AI
View 1 more answer
Q2. Difference between a list and a tuple. Explain a use case where you will use a tuple.
Ans. 
List vs Tuple and use case for Tuple
• List is mutable while Tuple is immutable

• List uses square brackets while Tuple uses parentheses

• Tuple is used when data needs to be protected from modification

• Tuple is also used for returning multiple values from a function
Answered by AI
Add your answer