Upload Button Icon Add office photos
Engaged Employer

i

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

Lumen Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Lumen Technologies Oracle DBA Lead Interview Questions and Answers

Updated 31 Jul 2024

Lumen Technologies Oracle DBA Lead Interview Experiences

1 interview found

Oracle DBA Lead Interview Questions & Answers

user image smita melinmani

posted on 31 Jul 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. When we create table how many segments are created ?
  • Ans. 

    When a table is created in Oracle, three segments are created: data segment, index segment, and temporary segment.

    • Data segment stores the actual data of the table

    • Index segment stores the indexes created on the table

    • Temporary segment is created for temporary data storage during sorting or joining operations

  • Answered by AI
  • Q2. Oracle architecture

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. React life cycle

I applied via Naukri.com and was interviewed before Dec 2019. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Oracle Apps Technical - PlSQL concepts
  • Q2. Basic questions like logic to find even number, swap number ,etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to see all the Technology related questions in Google before going for interview.

Interview Questionnaire 

1 Question

  • Q1. Data transforms, integration, data pages, RAP, Case management

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and give your answer with confidence

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

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. C++ basic
  • Q2. Hh
  • Q3. Yy

Interview Preparation Tips

Interview preparation tips for other job seekers - Hh

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(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

  • Answered by AI
Round 2 - Face to Face 

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 3 - HR 

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

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

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.

Application resume tips for other job seekers

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.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Amcat and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Refer R S Agarwal book for apptitude

Round 2 - One-on-one 

(1 Question)

  • Q1. Write a c program on fractional numbers
  • Ans. 

    A C program to perform arithmetic operations on fractional numbers.

    • Use float or double data type to store fractional numbers.

    • Use scanf() to take input from the user.

    • Perform arithmetic operations like addition, subtraction, multiplication, and division.

    • Use printf() to display the result.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared refer R S Agarwal book for apptitude test

Skills evaluated in this interview

I applied via Company Website and was interviewed before Sep 2019. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Basic programming questions such as Fibonacci, Armstrong and about recursion
  • Q2. I gave all answers

Interview Preparation Tips

Interview preparation tips for other job seekers - Your communication skill takes priority more than your technical skill.
If you are little bit weak in programming, Don't worry too much, only you have to focus on your communication skill and basic fundamental program and their concepts too.

I applied via Campus Placement and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic coding questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident , easy to crack

Lumen Technologies Interview FAQs

How many rounds are there in Lumen Technologies Oracle DBA Lead interview?
Lumen Technologies interview process usually has 1 rounds. The most common rounds in the Lumen Technologies interview process are Technical.
What are the top questions asked in Lumen Technologies Oracle DBA Lead interview?

Some of the top questions asked at the Lumen Technologies Oracle DBA Lead interview -

  1. When we create table how many segments are create...read more
  2. Oracle architect...read more

Tell us how to improve this page.

Lumen Technologies Oracle DBA Lead Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Bharti Airtel Interview Questions
4.0
 • 845 Interviews
Vodafone Idea Interview Questions
4.1
 • 553 Interviews
Cisco Interview Questions
4.1
 • 371 Interviews
View all
Software Engineer
462 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
293 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Module Lead
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Development Engineer
133 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Engineer
101 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Lumen Technologies with

Tata Communications

4.0
Compare

Bharti Airtel

4.0
Compare

Reliance Communications

4.0
Compare

Vodafone Idea

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview