TELUS Digital Senior Application Developer Interview Questions and Answers

Q1. What is Oracle apps
Ans. 
Oracle Applications are a suite of business applications software that help organizations manage their business processes.
• Oracle Applications include modules for customer relationship management (CRM), enterprise resource planning (ERP), supply chain management (SCM), and more.

• They are designed to automate and streamline business processes, improve efficiency, and provide real-time insights.

• Examples of Oracle Applicati...read more
Answered by AI
Add your answer
Q2. Explain value sets
Ans. 
Value sets are a collection of related values that can be used to define a set of acceptable values for a field or parameter.
• Value sets help ensure data consistency and accuracy by restricting the possible values that can be entered.

• They can be used in database fields, dropdown lists, or parameters in programming languages.

• For example, a value set for a 'gender' field may include values like 'Male', 'Female', and 'Othe
Answered by AI
Add your answer
Q3. Explain index in plsql
Ans. 
An index in PL/SQL is a database object that improves performance by allowing faster retrieval of data from tables.
• Indexes are created on columns in a table to speed up the retrieval of rows based on the values in those columns.

• They work similar to an index in a book, allowing the database to quickly locate the rows that match a certain criteria.

• Indexes can significantly reduce the time it takes to retrieve data, espec...read more
Answered by AI
Add your answer
Q4. Explain joins in plsql
Ans. 
Different types of joins in PL/SQL include inner join, outer join (left, right, full), cross join, and self join.
• Inner join: Returns rows when there is at least one match in both tables.

• Outer join: Returns all rows from one table and only matching rows from the other table (left, right, full).

• Cross join: Returns the Cartesian product of the two tables.

• Self join: Joins a table to itself.
Answered by AI
Add your answer
Q5. Explain functions in plsql
Ans. 
Functions in PL/SQL are named blocks of code that can accept parameters, perform a task, and return a value.
• Functions are created using the CREATE FUNCTION statement.

• Functions can accept input parameters and return a single value.

• Functions can be called from SQL statements or other PL/SQL blocks.

• Functions can be used to encapsulate reusable logic and improve code readability.

• Example: CREATE FUNCTION calculate_area(leng...read more
Answered by AI
Add your answer

WAP to count each word in a sentence and dispaly the output.
Questions on marker inetrface and functional interface.
sprinboot annotation questions

Respective technology based- java

Q1. All java based technical questions.
Add your answer
Q2. Java questions .......
Add your answer

Q1. Managerial round + technical + hr
Add your answer
Q2. Mix questions ........
Add your answer

Q1. What are the types of exceptions ?
Ans. 
There are two types of exceptions: checked and unchecked.
• Checked exceptions are checked at compile-time and must be handled by the programmer.

• Unchecked exceptions are not checked at compile-time and can be handled by the JVM.

• Examples of checked exceptions include IOException and SQLException.

• Examples of unchecked exceptions include NullPointerException and ArrayIndexOutOfBoundsException.
Answered by AI
Add your answer
Q2. How will you handle exceptions of a procedure getting called in another procedure.
Ans. 
I will use try-catch blocks to handle exceptions and log the error message for debugging purposes.
• Enclose the procedure call in a try block.

• Catch the exception in the catch block.

• Log the error message for debugging purposes.

• Handle the exception appropriately based on the specific scenario.
Answered by AI
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Why are you looking for a change?
Add your answer

Q1. Write test suite for a login form
Ans. 
Test suite for a login form
• Test for valid username and password

• Test for invalid username and password

• Test for empty username or password field

• Test for special characters in username or password

• Test for maximum character limit in username and password fields
Answered by AI
Add your answer