Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by PTC Team. If you also belong to the team, you can get access from here

PTC Verified Tick

Compare button icon Compare button icon Compare
4.2

based on 496 Reviews

Filter interviews by

PTC Oracle Database Administrator Interview Questions and Answers

Updated 19 Mar 2024

PTC Oracle Database Administrator Interview Experiences

1 interview found

Oracle Database Administrator Interview Questions & Answers

user image Anonymous

posted on 19 Mar 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

General dba related questions

Round 2 - Technical 

(4 Questions)

  • Q1. Technical discussion regarding oracle and experience
    • Add your answer
  • Q2. Commands for rman backups and difference between them
  • Ans. 

    RMAN backups can be performed using commands like BACKUP DATABASE, BACKUP ARCHIVELOG, BACKUP CONTROLFILE, etc.

    • BACKUP DATABASE: used to backup the entire database

    • BACKUP ARCHIVELOG: used to backup archived redo logs

    • BACKUP CONTROLFILE: used to backup the control file

    • BACKUP TABLESPACE: used to backup specific tablespaces

    • BACKUP AS COPY: used to create a physical copy of data files during backup

    • Answered by AI
    Add your answer
  • Q3. Dataguard questions
    • Add your answer
  • Q4. How do you create schema, difference between data types
  • Ans. 

    To create a schema, use CREATE SCHEMA statement. Data types include VARCHAR2, NUMBER, DATE, etc.

    • Create a schema using CREATE SCHEMA statement

    • Specify data types for columns when creating tables

    • Common data types include VARCHAR2, NUMBER, DATE, etc.

    • Use appropriate data types based on the type of data being stored

    • Answered by AI
    Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. This was the lead of the team and involved little technical questions and more of understanding work culture
    • Add your answer

Top trending discussions

View All
Interview Tips & Stories
2w
an operations executive
Job Market Seems to Be Opening Up Again!
I've been getting more interview calls recently, and after months of silence., it’s a relief! Things are looking better out there. Keep building your skills and applying, guys. Patience does pay off! For context: I have about 5 years of experience in the IT field, currently working as a security analyst (contract role) for the past 6 months. I've been applying for analyst roles at junior/mid-level positions open to hybrid and remote setups. Certifications I’ve done so far include CEH, CCNA, AWS Practitioner, and Splunk Essentials. What’s been your experience with job hunting lately? Let’s help each other out!
Got a question about PTC?
Ask anonymously on communities.

Interview questions from similar companies

Oracle Database Administrator Interview Questions & Answers

Oracle Cerner user image Raj Kishore Shaw

posted on 22 May 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Basics architecture, rman, datapump, upgrade, asm
    • Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. Block corruption, upgrade, rman datapump, asm, patching
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Basics..... Speaking skills.. Salary discussion
    • Add your answer

Senior Database Administrator Interview Questions & Answers

UKG user image Anonymous

posted on 25 Oct 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via LinkedIn and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. Database architecture
    • Add your answer
  • Q2. High availability for database
  • Ans. 

    High availability for database ensures minimal downtime and continuous access to data.

    • Implementing clustering and replication to distribute workload and provide failover

    • Setting up automated backups and monitoring systems to quickly identify and resolve issues

    • Utilizing load balancers to evenly distribute traffic and prevent overload

    • Implementing disaster recovery plans to quickly recover from unexpected outages

    • Answered by AI
    Add your answer
  • Q3. PostgreSQL streaming replication
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - should have fluently in knowing database architecture and how to set database performance parameters

SQL Database Administrator Interview Questions & Answers

Teradata user image Brijesh Kumar

posted on 29 Jun 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basics topics of aptitude in mcq format

Round 2 - Technical 

(2 Questions)

  • Q1. 2nd round was technical interview
    • Add your answer
  • Q2. All questions are based on projects mentioned in resume.
    • Add your answer
Round 3 - HR 

(1 Question)

  • Q1. 3rd round was just basic conversation about candidate like where he/she is from.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare everything which you mentioned in your resume specially your projects.

Database Developer Interview Questions & Answers

Globant user image Anonymous

posted on 8 Feb 2023

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Q.About SQL Server T-SQL
    • Add your answer
  • Q2. Q.Normal scenario based questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - HR is too busy. HR called to schedule the interview but forgot to schedule interview. After reminding HR, HR scheduled the interview but did not give any feedback after the interview. sending messages and emails, but HR didn't respond.waste of time.

Oracle Database Administrator Interview Questions & Answers

Oracle Cerner user image Raj Kishore Shaw

posted on 22 May 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Basics architecture, rman, datapump, upgrade, asm
    • Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. Block corruption, upgrade, rman datapump, asm, patching
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Basics..... Speaking skills.. Salary discussion
    • Add your answer

Senior Database Administrator Interview Questions & Answers

Teradata user image Anonymous

posted on 18 Nov 2021

I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. Teradata Architecture
    • Add your answer
  • Q2. Data protection techniques
  • Ans. 

    Data protection techniques are essential for safeguarding sensitive information from unauthorized access or theft.

    • Encryption of data at rest and in transit

    • Access controls and authentication mechanisms

    • Regular backups and disaster recovery plans

    • Data masking and anonymization

    • Monitoring and auditing of database activity

    • Answered by AI
    Add your answer
  • Q3. Difference between Role and Profile
    • Add your answer
  • Q4. What is hop Amp CPU and how it is caused
  • Ans. 

    Hop Amp CPU is a performance issue caused by excessive CPU usage in a database server.

    • Hop Amp CPU occurs when a database server is overloaded with too many queries or transactions.

    • It can also be caused by poorly optimized queries or inefficient database design.

    • Hop Amp CPU can lead to slow response times, system crashes, and other performance issues.

    • To prevent Hop Amp CPU, database administrators should monitor server p...

    • Answered by AI
    Add your answer
  • Q5. Various methods to solve spool space issue
  • Ans. 

    Various methods to solve spool space issue

    • Optimize queries to reduce spool space usage

    • Increase spool space allocation for the user

    • Use temporary tables to reduce spool space usage

    • Use compression techniques to reduce spool space usage

    • Avoid Cartesian joins to reduce spool space usage

    • Answered by AI
    Add your answer
  • Q6. Teradata Utilities: Mainly Multipload and Fastload
    • Add your answer
  • Q7. Grant and Revoke command
    • Add your answer
  • Q8. Data dictionary tables and where the history Data is stored
  • Ans. 

    Data dictionary tables store metadata about database objects. History data is stored in audit tables or separate history tables.

    • Data dictionary tables contain information about database objects such as tables, columns, indexes, and constraints.

    • History data can be stored in audit tables that track changes to data over time.

    • Separate history tables can also be used to store historical data.

    • Examples of data dictionary tabl...

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - I had a good experience with the interview. There are teradata wiki links available to go through topics mentioned.

Skills evaluated in this interview

More about working at PTC

PTC Interview FAQs

How many rounds are there in PTC Oracle Database Administrator interview?
PTC interview process usually has 3 rounds. The most common rounds in the PTC interview process are Technical and Aptitude Test.
How to prepare for PTC Oracle Database Administrator interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at PTC. The most common topics and skills that interviewers at PTC expect are Oracle DBA, Linux, Oracle, Oracle Database and Support.
What are the top questions asked in PTC Oracle Database Administrator interview?

Some of the top questions asked at the PTC Oracle Database Administrator interview -

  1. How do you create schema, difference between data ty...read more
  2. commands for rman backups and difference between t...read more
  3. This was the lead of the team and involved little technical questions and more ...read more

Tell us how to improve this page.

PTC Interviews By Designations

Interview Questions for Popular Designations

PTC Oracle Database Administrator Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Siemens Interview Questions
4.1
 • 426 Interviews
Schneider Electric Interview Questions
4.2
 • 353 Interviews
Bosch Interview Questions
4.2
 • 331 Interviews
Johnson Controls Interview Questions
3.6
 • 254 Interviews
Adobe Interview Questions
4.0
 • 249 Interviews
ABB Interview Questions
4.1
 • 228 Interviews
24/7 Customer Interview Questions
3.5
 • 175 Interviews
Globant Interview Questions
3.8
 • 169 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
VMware Software Interview Questions
4.4
 • 157 Interviews
View all

Fast track your campus placements

GH Raisoni College of Engineering, Nagpur Placement Questions
1 Interview
Pimpri Chinchwad College of Engineering, Pimpri Placement Questions
1 Interview
View all
PTC Oracle Database Administrator Salary
based on 5 salaries
₹9.5 L/yr - ₹11.9 L/yr
31% more than the average Oracle Database Administrator Salary in India
View more details
PTC Salaries in India
Software Specialist
152 salaries
unlock blur

₹7.5 L/yr - ₹18.2 L/yr

Senior Software Specialist
111 salaries
unlock blur

₹9.1 L/yr - ₹24 L/yr

Technical Lead
106 salaries
unlock blur

₹10.9 L/yr - ₹28.5 L/yr

QA Specialist
86 salaries
unlock blur

₹7 L/yr - ₹15 L/yr

Product Specialist
75 salaries
unlock blur

₹7.5 L/yr - ₹13 L/yr

Explore more salaries
Compare PTC with

Autodesk

4.3
Compare

Siemens

4.1
Compare

Bosch

4.2
Compare

ABB

4.1
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview