Amdocs Interview Questions, Process, and Tips

Questions on quants, reasoning, unix, and some sql questions

Two codes find prime number, and fibbonacci and two basic sql questions

Q1. About final year project
Add your answer
Q2. Java fundamental questions on oops
Add your answer
Q3. Whatever skills you have mentioned in your resume
Add your answer
Q4. One coding question in java
Add your answer
Q5. One sql question
Add your answer
Q6. Will you able to work in shift
Ans. 
Yes, I am willing to work in shifts as required for the ETL testing role.
• I am flexible and adaptable to different work schedules.

• I understand the importance of meeting project deadlines and am willing to work extra hours if needed.

• I have previous experience working in shifts in a similar role.

• I am committed to ensuring the quality of the ETL processes regardless of the shift timing.
Answered by AI
Add your answer

Q1. Tell me about company
Ans. 
Company is a leading software development firm specializing in ETL testing services.
• Company has been in business for over 10 years

• They have a team of experienced ETL testers

• Company has worked with clients in various industries such as finance, healthcare, and retail
Answered by AI
Add your answer
Q2. Willing to work in shift
Add your answer
Q3. Will you relocate
Ans. 
Yes, I am open to relocating for the right opportunity.
• I am willing to relocate for the right job opportunity

• I am open to exploring new locations and experiences

• I understand the importance of being flexible in today's job market
Answered by AI
Add your answer

Arrays Lists Queues Maps

Q1. Your personal details
Add your answer
Q2. Educational Details
Add your answer

Asked 3 Java coding questions.
1. Reverse a linked list
2. Palindrome
3. Anagram Strings

Q1. Project related questions like Architecture
Add your answer
Q2. Java OOPs, spring boot, spring security
Add your answer

Q1. Question about dba
Add your answer
Q2. Difference Between SQL And nosql
Ans. 
SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.
• SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.

• SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.

• SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...read more
Answered by AI
Add your answer
Q3. How to restore the database using rman
Ans. 
Restoring a database using RMAN involves connecting to the target database, restoring the control file, and recovering the database.
• Connect to the target database using RMAN

• Restore the control file from a backup

• Restore the datafiles and tablespaces

• Recover the database to bring it to a consistent state

• Perform necessary checks and validations after restoration
Answered by AI
Add your answer
Q4. How to change column in table
Ans. 
You can change a column in a table using the ALTER TABLE statement in SQL.
• Use the ALTER TABLE statement followed by the MODIFY keyword to change the data type or size of a column.

• Use the ALTER TABLE statement followed by the ADD or DROP keyword to add or remove a column.

• Make sure to specify the table name, column name, and the new data type or size when making changes.
Answered by AI
Add your answer
Q5. What are different types of objects in database
Ans. 
Different types of objects in a database include tables, views, indexes, sequences, and stored procedures.
• Tables: Used to store data in rows and columns.

• Views: Virtual tables created by a query.

• Indexes: Improve the performance of queries by allowing quick access to specific rows.

• Sequences: Generate unique numbers.

• Stored Procedures: Precompiled SQL code that can be executed with parameters.
Answered by AI
Add your answer