Telstra Interview Questions, Process, and Tips

It was a combination of coding and aptitude test. The test had four section and each section had it's time limit.

Q1. The interviewer asked me question based on my resume. He also asked me question related to DBMS, OS & DSA.
Add your answer
Q2. Define polymorphism.
Ans. 
Polymorphism is the ability of an object to take on many forms.
• Polymorphism allows objects of different classes to be treated as if they are of the same class.

• It can be achieved through method overloading or method overriding.

• For example, a parent class Animal can have child classes like Dog, Cat, and Bird, each with their own unique implementation of the method 'makeSound'.
Answered by AI
Add your answer
Q3. Difference between SQL & NoSQL.
Ans. 
SQL is a relational database management system, while NoSQL is a non-relational database management system.
• SQL databases use structured query language for defining and manipulating the data.

• NoSQL databases are schema-less and use various data models like key-value, document, columnar, or graph.

• SQL databases are suitable for complex queries and transactions.

• NoSQL databases are horizontally scalable and provide high perf...read more
Answered by AI
View 1 more answer

Q1. It was a managerial round.
Add your answer

Q1. It asked me some situational based questions.
Add your answer

Leetcode easy and medium questions. It was easy to clear

Q1. Dry run bubble and insertion sort
Add your answer
Q2. One SQL query easy level
Add your answer

Q1. Discussion about projects
Add your answer
Q2. Do you have any questions
Add your answer

Python and SQL Questions (Easy to Medium)

Q1. Project Work Discussion
Add your answer
Q2. SQL Coding (Can be with an online compiler)
Add your answer
Q3. Python Coding (Can be with an online compiler)
Add your answer
Q4. PySpark Coding (All the coding answers have to be submitted to the interviewer)
Add your answer
Q5. PySpark Joins, and Databricks, and Vanilla Spark difference
Add your answer

Q1. SQL 2 Questions (Easy to Medium) (Maybe on the compiler)
Add your answer
Q2. Python (Easy) (Maybe on compiler)
Add your answer
Q3. Scenario-based questions on the project
Add your answer

Easy-medium level and it included two coding questions and some technical questions

Q1. How are structures and classes stored?
Ans. 
Structures and classes are stored in memory as a combination of data members and member functions.
• Structures and classes are stored in memory as a combination of data members and member functions.

• Data members of a structure or class are stored in contiguous memory locations.

• Member functions of a class are stored separately in memory and are shared among all instances of the class.

• Pointers to member functions are used t...read more
Answered by AI
Add your answer
Q2. What is final and finalize?
Ans. 
final is a keyword in Java used to restrict inheritance, overriding, and modification. finalize is a method used for cleanup operations before an object is garbage collected.
• final keyword is used to declare constants, prevent inheritance by marking a class as final, and prevent method overriding by marking a method as final

• finalize method is called by the garbage collector before an object is destroyed

• Example: final in...read more
Answered by AI
Add your answer