Wipro Senior Linux System Administrator Interview Questions and Answers

There are two main sections: foundation and advanced. The foundation section consists of three subsections: quantitative, reasoning, and verbal. If you pass the foundation section but do not clear the advanced section, you will be considered for either the ninja role or the digital role during the interview process. The advanced section includes advanced aptitude questions and two coding questions.

Q1. Can you provide an introduction about yourself?
Add your answer
Q2. 3 to 4 questions based on database
Add your answer
Q3. 2 easy coding questions
Add your answer
Q4. Questions based on technology that I knew
Add your answer
Q5. Situation based questions
Add your answer

There were a total of seven sections: verbal ability, logical reasoning, arithmetic problems, verbal reasoning, puzzles, pseudocodes, and essay writing, with each section having its own cutoff scores.

Q1. What is the SQL query to retrieve the person with the highest salary?
Add your answer
Q2. Can you describe the projects you have worked on?
Add your answer
Q3. Write a query to merge 2 tables?
Add your answer
Q4. Tell me about the internship that you have done?
Add your answer
Q5. Behavioural questions
Add your answer

Q1. Design patterns
Add your answer
Q2. Sql interview questions
Add your answer

Q1. Case study about the given requirement
Add your answer
Q2. Springboot basic questions
Add your answer

Q1. Explain about patch management in Linux
Add your answer
Q2. After patching what are the issues you faced. How did you troubleshoot those issues.
Add your answer

Q1. Explain lambda expression
Ans. 
Lambda expression is a concise way to represent an anonymous function in programming languages.
• Lambda expressions are used to create functions without a name.

• They are often used in functional programming languages like Python and Java.

• Lambda expressions can take parameters and return a value.

• Example: (x, y) -> x + y is a lambda expression that takes two parameters and returns their sum.
Answered by AI
Add your answer
Q2. Why hibernate is better then jdbc
Ans. 
Hibernate is better than JDBC due to its object-relational mapping capabilities, automatic table creation, and improved performance.
• Hibernate provides object-relational mapping (ORM) which simplifies database interactions by mapping Java objects to database tables, eliminating the need for manual SQL queries.

• Hibernate can automatically generate SQL queries based on the Java objects, reducing the amount of code that nee...read more
Answered by AI
Add your answer

Q1. Filter names from a list that starts with A
Ans. 
Filter names starting with A from a list of strings
• Iterate through the list of strings

• Check if each string starts with 'A'

• Add the string to a new list if it starts with 'A'
Answered by AI
Add your answer
Q2. White query parameter and path variable
Add your answer

Q1. What is hash technology?
Ans. 
Hash technology is a method used to convert data into a fixed-size string of characters, typically used for data security and integrity.
• Hash technology uses algorithms to generate a unique fixed-size string of characters from input data.

• It is commonly used for data security, password storage, digital signatures, and data integrity verification.

• Examples of hash algorithms include MD5, SHA-1, and SHA-256.
Answered by AI
Add your answer
Q2. What is block chain?
Ans. 
Blockchain is a decentralized, distributed ledger technology used to securely record transactions across multiple computers.
• Decentralized database

• Consensus mechanism

• Immutable record of transactions

• Cryptographic security

• Smart contracts

• Examples: Bitcoin, Ethereum
Answered by AI
Add your answer
Q3. What is DML?
Ans. 
DML stands for Data Manipulation Language, used to manage data in a database.
• DML is a subset of SQL (Structured Query Language) used to insert, update, delete, and retrieve data in a database.

• Examples of DML commands include INSERT, UPDATE, DELETE, and SELECT.

• DML is essential for managing and manipulating data within a database system.
Answered by AI
Add your answer
Q4. Convert binay to decimal and viceversa.
Ans. 
Binary to decimal conversion involves multiplying each digit by 2 raised to the power of its position.
• To convert binary to decimal, start from the rightmost digit and multiply each digit by 2 raised to the power of its position.

• Add all the results together to get the decimal equivalent.

• For example, to convert binary 1011 to decimal: 1*2^3 + 0*2^2 + 1*2^1 + 1*2^0 = 11.
Answered by AI
Add your answer
Q5. Find max number in array?
Ans. 
Iterate through array and compare each element to find the maximum number.
• Iterate through the array using a loop.

• Compare each element to a variable storing the current maximum number.

• Update the variable if a larger number is found.

• Return the maximum number at the end.
Answered by AI
Add your answer
Q6. Write basic html , for inserting image and create table.
Ans. 
Basic HTML code for inserting image and creating a table
• Use <img> tag to insert an image with src attribute

• Use <table>, <tr>, <td> tags to create a table structure

• Specify image source and table content within respective tags
Answered by AI
Add your answer

Its very easy
Basic maths questions learned up to 10
Basic Apptitude questions

Q1. Tell me about your self Hi My name is Vikram Adithya I am an hard working and passionate engineering student currently perceiveing in gokaraju rangaraju institute of engineering and technology .I stay with...read more
Add your answer
Q2. Intervier asked about what kind of problems did you solved in leetcode? I said palindrome factorial matrix multiplication etc . Intervier said every one can solve this
Add your answer
Q3. He asked me about my project role i said I have done documentation in my project he said every one can do that
Add your answer
Q4. He asked me to write project code
Add your answer
Q5. He asked me any questions
Add your answer

Q1. How can I grant SFTP access exclusively to the user David?
Ans. 
Grant SFTP access exclusively to user David
• Create a new group specifically for David, e.g. 'davidgroup'

• Set the ChrootDirectory in the SSH configuration file to restrict David's access to a specific directory

• Add David to the 'davidgroup' and configure the necessary permissions for SFTP access
Answered by AI
Add your answer
Q2. How can a user be locked out after 6 unsuccessful password attempts for a duration of 30 minutes?
Ans. 
To lock a user out after 6 unsuccessful password attempts for 30 minutes, modify the PAM configuration file.
• Edit the PAM configuration file (/etc/pam.d/common-auth) to include the 'pam_tally2' module.

• Set the 'deny' option in the 'pam_tally2' module to lock the user out after 6 failed attempts.

• Specify the 'unlock_time' option in the 'pam_tally2' module to set the duration of the lockout period to 30 minutes.

• Example: aut
Answered by AI
Add your answer