Upload Button Icon Add office photos

Lionbridge Technologies

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Lionbridge Technologies Senior Database Developer Interview Questions, Process, and Tips

Updated 20 Mar 2024

Lionbridge Technologies Senior Database Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
No response

I appeared for an interview in Feb 2024.

Round 1 - Technical 

(4 Questions)

  • Q1. Can we update view in SQl
  • Ans. 

    Yes, views can be updated in SQL.

    • Views can be updated in SQL by using the CREATE OR REPLACE VIEW statement.

    • The data in the underlying tables will be affected when the view is updated.

    • Views can be updated to include new columns or filter criteria.

    • Example: CREATE OR REPLACE VIEW my_view AS SELECT * FROM my_table WHERE column = 'value';

  • Answered by AI
  • Q2. What are different types of Trigger
  • Ans. 

    Types of triggers include DML triggers, DDL triggers, and logon triggers.

    • DML triggers are fired in response to data manipulation language (DML) events like INSERT, UPDATE, DELETE.

    • DDL triggers are fired in response to data definition language (DDL) events like CREATE, ALTER, DROP.

    • Logon triggers are fired in response to a LOGON event.

    • INSTEAD OF triggers are used to perform an action instead of the triggering action.

  • Answered by AI
  • Q3. Does view improve query performance
  • Ans. 

    Views can improve query performance by simplifying complex queries and reducing the need for redundant code.

    • Views can store complex queries and calculations, allowing for easier access and reuse of data.

    • Views can help optimize performance by pre-aggregating data or joining tables in advance.

    • Views can reduce the need for writing repetitive code by encapsulating common logic.

    • However, views can also introduce overhead if ...

  • Answered by AI
  • Q4. Why it is not recommended to give store procedure name with sp_ prefix
  • Ans. 

    Using sp_ prefix for stored procedures can cause performance issues and conflicts with system procedures.

    • sp_ prefix is reserved for system stored procedures in SQL Server, so using it for user-defined procedures can lead to conflicts.

    • Using sp_ prefix can cause unnecessary overhead as SQL Server first searches in the master database for system procedures before looking in the user database.

    • Avoiding sp_ prefix can improv...

  • Answered by AI
Round 2 - Behavioral 

(1 Question)

  • Q1. Daily task , How you manage sprint task and user issues ,
  • Ans. 

    I manage daily tasks by prioritizing sprint tasks and addressing user issues promptly.

    • Prioritize sprint tasks based on deadlines and importance

    • Communicate with team members to ensure tasks are on track

    • Address user issues promptly to maintain system functionality

    • Use project management tools like Jira to track progress

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

I appeared for an interview before Jun 2016.

Interview Questionnaire 

4 Questions

  • Q1. Tell me something about yourself
  • Ans. 

    I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.

    • 5 years of experience in web development

    • Strong background in computer science

    • Passionate about software development

  • Answered by AI
  • Q2. Questions related to project I have worked on during college days
  • Q3. Core Java concepts
  • Q4. Why do you use two mobile numbers
  • Ans. 

    To separate personal and professional calls, and to ensure availability and accessibility.

    • Separate personal and professional calls

    • Ensure availability and accessibility

    • Maintain work-life balance

    • Avoid mixing personal and work-related contacts

  • Answered by AI

Interview Preparation Tips

Round: Test
Total Questions: 60

College Name: Watumull Institute Of Electronics Engineering And Computer Technology ( WIEECT )

I appeared for an interview in Sep 2016.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a passionate software developer with experience in Java, Python, and web development.

    • Experienced in Java, Python, and web development technologies

    • Strong problem-solving skills and ability to work in a team

    • Completed multiple projects including a web-based inventory management system

  • Answered by AI
  • Q2. Simple coding questions..Basically pattern.
  • Q3. And also they will ask about your projects.

Interview Preparation Tips

Round: Test
Experience: 60 multiple choice questions so have to manage time carefully.
Tips: Have to give equal importance to all the sections..So try to do well in all section.
Duration: 1 hour 30 minutes
Total Questions: 60

Round: Technical + HR Interview
Experience: Don't panic...Only write those things that you know in your resume.

Skills: Smart Coding
College Name: Jaypee Institute Of Information Technology, Noida

I appeared for an interview in May 2017.

Interview Preparation Tips

Round: Test
Total Questions: 20

Round: Group Discussion
Duration: 1 hour

Skills: Coding Skills And Knowledge On Data Structures

I appeared for an interview in Jun 2017.

Interview Preparation Tips

Round: Test
Duration: 1 hour 30 minutes

Skills: Engineering Basics

I appeared for an interview in May 2017.

Interview Preparation Tips

Round: Group Discussion
Duration: 7 hours

College Name: Andhra university

I appeared for an interview in Aug 2017.

Interview Preparation Tips

Round: Test
Tips: Practice e litmus questions and also give mock tests on placement season
Duration: 2 hours

Round: Technical + HR Interview
Experience: The interviewer asked me questions from the subjects I mentioned in my CV and also asked so many situational questions like what will you do in this situation etc.

Skills: Presence Of Mind, Technical Skill

Interview Preparation Tips

Round: Test
Experience: to.me totally there were three sections.verbal,apti and reasoning.each section carries 15,15 and 10 questions respectively.to me verabal and apti was little bit easy and it consumes more time to solve the apti questions.so i have been solved 8 apti questions and at last 1minute i.just qlicked the answers for remaining questions randomly becasue we didnt have negative mark and finally reasobing was much easier and solved every answers.
Tips: to get selected in the first round you should practice more online tests.then you can easily manage your time.and be cool. so dont worry every thing will become easier and do well.
all the best!!!

Round: HR Interview
Experience: when i faced my HR he asked me to tell three things about me, i.have told generosity,confidence and friendship.and he asked me to elobrate it and i have done well and he goes with the projects that i have done .afterwards he asked about my stream and why it.and i have answered that iam from electrical and electronics background but now a days IT has been entered into every sector and without IT there would be nothing in this world.thats why i choose IT.and asked about my extra curricular activities and iam a sports person too and finally few questions from C and C++.
Tips: Be confident in your speech and try to answer even if not knows the answer well,because they will see how we are trying to answer so dont hesitate to answer.and keep your mind free and every thing will be alright.be cool and all the best

General Tips: start to prpare atleast before one week from the interview.and be cool at any situations and to get speak english fluently practice with your friends and try to converse every thing in english even with customer care, it will be funny to and thats make you to survive your interviews easily...
Skills:
College Name: sri krishna college of engineering and technology
Motivation: in this company there will be friendly environment and there will be less working pressure and have some cultural clubs to have fun with it
Funny Moments: before one week to our placements our friends get started to chat in english and every where we conversed in english it was funny and later we realised how it helped us. so dont bother about others and what they think. just go on with your friends confidently in english...

I appeared for an interview before Aug 2016.

Interview Questionnaire 

1 Question

  • Q1. Only introduction and project questions

Interview Preparation Tips

Round: aptitude
Experience: around 70 questions with sectional cutoff.
Tips: average questions keep watch on timer

Round: HR Interview
Experience: he was so friendly and it went on cool.
Tips: easy round.

Skills: Personality
College Name: Mnm Jain Engineering College
Contribute & help others!
anonymous
You can choose to be anonymous

Lionbridge Technologies Interview FAQs

How many rounds are there in Lionbridge Technologies Senior Database Developer interview?
Lionbridge Technologies interview process usually has 2 rounds. The most common rounds in the Lionbridge Technologies interview process are Technical and Behavioral.
How to prepare for Lionbridge Technologies Senior Database Developer 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 Lionbridge Technologies. The most common topics and skills that interviewers at Lionbridge Technologies expect are ETL Tool, Pentaho, Power Bi, QlikView and SQL Development.
What are the top questions asked in Lionbridge Technologies Senior Database Developer interview?

Some of the top questions asked at the Lionbridge Technologies Senior Database Developer interview -

  1. Why it is not recommended to give store procedure name with sp_ pre...read more
  2. Daily task , How you manage sprint task and user issue...read more
  3. What are different types of Trig...read more

Recently Viewed

COMPANY BENEFITS

ICICI Bank

Kakinada

6 benefits

COMPANY BENEFITS

ICICI Bank

Junagadh

1 benefit

INTERVIEWS

Lionbridge Technologies

No Interviews

SALARIES

Tech Mahindra

INTERVIEWS

Lionbridge Technologies

No Interviews

SALARIES

iEnergizer

SALARIES

HGS

INTERVIEWS

Lionbridge Technologies

No Interviews

INTERVIEWS

Lionbridge Technologies

No Interviews

SALARIES

Accenture

Tell us how to improve this page.

Lionbridge Technologies Senior Database Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.7
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
TTEC India Interview Questions
3.7
 • 136 Interviews
Aptara Interview Questions
3.3
 • 62 Interviews
View all
Associate Project Manager
712 salaries
unlock blur

₹3.8 L/yr - ₹9.2 L/yr

Senior Project Coordinator
239 salaries
unlock blur

₹3 L/yr - ₹6.5 L/yr

Project Manager
184 salaries
unlock blur

₹4.1 L/yr - ₹14 L/yr

Project Coordinator
98 salaries
unlock blur

₹2.2 L/yr - ₹5.2 L/yr

Software Engineer
90 salaries
unlock blur

₹3 L/yr - ₹10 L/yr

Explore more salaries
Compare Lionbridge Technologies with

Appen

4.1
Compare

TTEC India

3.7
Compare

Cognizant

3.7
Compare

Wipro

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