PTC Interview Questions and Answers

General dba related 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

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

It was oncampus opportunity where in 1st round I was OA where aptitude and technical questions was asked all MCQ on the mttle platform

Q1. Oops concepts was asked and told t9 implement as well
Add your answer
Q2. One DSA question easy - medium level
Add your answer
Q3. Login page was given and was asked for the possible test cases coming in my mind as it was a QA role
Add your answer
Q4. One sql question medium level
Add your answer

Q1. It was manegarial round where some technical as well as behaviourial questions was asked
Add your answer
Q2. Google home page was given and was asked for the test cases
Add your answer
Q3. 2 DSA questions was asked easy - medium level
Add your answer
Q4. Some behaviourial questions like where do you want to see yourself in next 5 years
Add your answer

Q1. Expalination of my project
Add your answer
Q2. My family background
Add your answer

Q1. Program for HashMap
Ans. 
A program for HashMap implementation in Java
• HashMap is a data structure that stores key-value pairs

• Use put() method to add key-value pairs to HashMap

• Use get() method to retrieve values based on keys

• HashMap allows null keys and values

• Example: HashMap<String, Integer> map = new HashMap<>()
Answered by AI
Add your answer
Q2. Test cases for any materialistic things in interview cabin
Add your answer

Q1. Why you want to join
Ans. 
I am impressed by the company's commitment to quality and innovation.
• I admire the company's reputation for excellence in product quality.

• I am excited about the opportunity to contribute to a team that values continuous improvement.

• I believe in the company's mission and values, and I see potential for growth and development within the organization.
Answered by AI
Add your answer
Q2. Why you left previous organisation
Ans. 
Seeking new challenges and growth opportunities
• Desire for career advancement

• Looking for a more challenging role

• Seeking new learning opportunities

• Relocation to a different city

• Company downsizing or restructuring
Answered by AI
Add your answer

Q1. Basic Solid mechanics.
Add your answer
Q2. Production technology
Add your answer
Q3. CAD functionality
Add your answer

Generic, engineering graphics included.