AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Amdocs
Compare
Filter interviews by
Clear (1)
Amdocs Oracle Database Administrator Interview Questions, Process, and Tips
Top Amdocs Oracle Database Administrator Interview Questions and Answers
- Q1. How to configure RAC in detail? Shell scripting SQL scripting
- Q2. What are different types of objects in database
- Q3. What is view synonym mview Explain datapump Oracle goldengate in detail
Amdocs Oracle Database Administrator Interview Experiences
3 interviews found
Anonymous
(5 Questions)
- Q1. Question about dba
- 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...
- 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
- 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.
- 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.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Mar 2023. There were 2 interview rounds.
(1 Question)
- Q1. What is view synonym mview Explain datapump Oracle goldengate in detail
- Ans.
A materialized view (mview) is a database object that contains the results of a query. Datapump is a tool for moving data between Oracle databases. Oracle GoldenGate is a real-time data integration and replication tool.
Materialized views (mviews) store the results of a query for faster access.
Datapump is a tool used for exporting and importing data between Oracle databases.
Oracle GoldenGate is a real-time data integrat...
(1 Question)
- Q1. What is your goal
I applied via Naukri.com and was interviewed in Jun 2022. There was 1 interview round.
(1 Question)
- Q1. How to configure RAC in detail? Shell scripting SQL scripting
- Ans.
Configuring RAC involves setting up shared storage, network, and database components on multiple nodes.
Configure shared storage using ASM or NFS
Configure network components such as VIP, SCAN, and listener
Install Oracle Grid Infrastructure and Oracle Database software on all nodes
Create a RAC database using DBCA or manually
Configure load balancing and failover using services
Use shell scripting and SQL scripting to autom...
Interview Preparation Tips
If you are giving interview as 3+ years, they will expect that you should posses the expertise 5+ years of experience.
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I was interviewed before Sep 2020.
(1 Question)
Round duration - 140 minutes
Round difficulty - Medium
Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.
- Q1.
Sum of Two Numbers Represented as Arrays
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...
- Ans.
Given two numbers represented as arrays, calculate their sum and return the result as an array.
Iterate through the arrays from right to left, adding digits and carrying over if necessary
Handle cases where one array is longer than the other by considering the remaining digits
Ensure the final sum array does not have any leading zeros
Round duration - 20 minutes
Round difficulty - Easy
The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.
Round duration - 8 minutes
Round difficulty - Easy
This round was conducted right after finishing and clearing the technical round at the same place and on the same day.
Interview Preparation Tips
Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.
Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Hr
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...
Interview Preparation Tips
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...
Interview Preparation Tips
I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Oops Concepts,JAVA 8
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
Easy DSA questions and some questions on resume
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How do you get the second to last element from a SQL table?
- Ans.
To get the second to last element from a SQL table, use the OFFSET-FETCH clause.
Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;
Interview Preparation Tips
Skills evaluated in this interview
Amdocs Interview FAQs
Recently Viewed
REVIEWS
Financial Software & Systems
No Reviews
INTERVIEWS
NoBrokerHOOD
No Interviews
INTERVIEWS
Swiggy
No Interviews
COMPANY BENEFITS
Financial Software & Systems
No Benefits
INTERVIEWS
Software Technology Parks of India
No Interviews
SALARIES
State Bank of India
LIST OF COMPANIES
Discover companies
Find best workplace
INTERVIEWS
Swiggy
No Interviews
SALARIES
State Bank of India
SALARIES
State Bank of India
Tell us how to improve this page.
Amdocs Interviews By Designations
- Amdocs Software Developer Interview Questions
- Amdocs Associate Software Engineer Interview Questions
- Amdocs Software Engineer Interview Questions
- Amdocs Functional Test Engineer Interview Questions
- Amdocs RF Engineer Interview Questions
- Amdocs Softwaretest Engineer Interview Questions
- Amdocs Senior Software Engineer Interview Questions
- Amdocs Devops Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Database Architect Interview Questions
- Mysql Database Administrator Interview Questions
- Oracle Application Database Administrator Interview Questions
- SQL Server Database Administrator Interview Questions
- Show more
Amdocs Oracle Database Administrator Interview Process
based on 2 interviews
1 Interview rounds
- Technical Round
Oracle Database Administrator Interview Questions from Similar Companies
Fast track your campus placements
Amdocs Oracle Database Administrator Reviews and Ratings
based on 9 reviews
Rating in categories
|
Software Developer
8.2k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
1.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Softwaretest Engineer
1.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Functional Test Engineer
1.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Software Engineer
1k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
IBM
Infosys
Wipro
- Home >
- Interviews >
- Amdocs Interview Questions >
- Amdocs Oracle Database Administrator Interview Questions
