Add office photos
Filter interviews by
Lionbridge Technologies Senior Database Developer Interview Questions, Process, and Tips for Experienced
Lionbridge Technologies Senior Database Developer Interview Experiences for Experienced
1 interview found
Anonymous
I was interviewed in Feb 2024.
(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';
- 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.
- 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 ...
- 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...
(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
Skills evaluated in this interview
Interview questions from similar companies
(2 Questions)
- Q1. Why do you want to switch
- Ans.
I want to switch to explore new technologies and challenges in a different industry.
Interested in learning new skills and technologies
Seeking new challenges and opportunities for growth
Want to explore different industry perspectives
- Q2. Salry expectations
(2 Questions)
- Q1. Question on oop concepts
- Q2. Coding questions
I applied via Naukri.com and was interviewed in Feb 2024. There were 3 interview rounds.
One coding question with 40-45 mcq
(2 Questions)
- Q1. 2 coding questions from array
- Q2. In given array find the sum a*a+b*b=c*c
- Ans.
Use a nested loop to iterate through the array and check for the sum of squares of two elements equal to the square of a third element.
Iterate through the array using a nested loop to compare all possible combinations of elements.
Calculate the sum of squares of two elements and check if it equals the square of a third element.
Return the elements if a match is found, otherwise continue iterating.
(1 Question)
- Q1. Core java questions, springboot, one string coding question
Skills evaluated in this interview
Contiguous array in java
(2 Questions)
- Q1. Microservices architecture
- Q2. Saga design pattern
Sushant Pathak
(2 Questions)
- Q1. What is java and its features ?
- Ans.
Java is a high-level programming language known for its platform independence and object-oriented features.
Java is platform-independent, meaning it can run on any device with a Java Virtual Machine (JVM)
It is object-oriented, allowing for the creation of reusable code and modular programs
Java is known for its robust standard library, providing a wide range of pre-built functionality
It supports multithreading, allowing ...
- Q2. What is java 8 and features
- Ans.
Java 8 is a major release of the Java programming language with new features like lambda expressions, streams, and default methods.
Lambda expressions allow you to treat functionality as a method argument.
Streams provide a new abstraction to work with sequences of elements.
Default methods allow interfaces to have method implementations.
Date and Time API provides a new way to work with dates and times.
Optional class help
Skills evaluated in this interview
(1 Question)
- Q1. Basic Java concepts - Oops, collection
Senior Software Developer Interview Questions & Answers
LG Electronics
Mathi Prasad
posted on 19 Feb 2024
I was interviewed in Jan 2024.
(1 Question)
- Q1. Stl, types of pointer, bitwise, heap sort
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Mar 2023. There were 2 interview rounds.
Just apptitude questions and simple grammar
(2 Questions)
- Q1. General Introduction And asked about the previous profile Data entry process
- Q2. About yourself Data Entry work
Interview Preparation Tips
(2 Questions)
- Q1. Fetch all the duplicate values from an array
- Ans.
To fetch all duplicate values from an array of strings
Iterate through the array and store each element in a HashSet
If an element is already in the HashSet, it is a duplicate value
Add the duplicate values to a separate list and return it
- Q2. Java 8 streams api
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Aug 2023. There were 3 interview rounds.
(1 Question)
- Q1. Javascript basics, class and functional components, basic es6
(1 Question)
- Q1. Promises, context api, redux and rest API
Interview Preparation Tips
Lionbridge Technologies Interview FAQs
Some of the top questions asked at the Lionbridge Technologies Senior Database Developer interview for experienced candidates -
Tell us how to improve this page.
Lionbridge Technologies Interviews By Designations
- Lionbridge Technologies Associate Project Manager Interview Questions
- Lionbridge Technologies Project Coordinator Interview Questions
- Lionbridge Technologies Senior Content Writer Interview Questions
- Lionbridge Technologies Software Developer Interview Questions
- Lionbridge Technologies Application Support Engineer Interview Questions
- Lionbridge Technologies Consultant Interview Questions
- Lionbridge Technologies Data Analyst Interview Questions
- Lionbridge Technologies Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Software Developer Interview Questions
- Database Developer Interview Questions
- Database Admin Interview Questions
- SQL Database Administrator Interview Questions
- Java Developer Interview Questions
- Database Administrator DBA Interview Questions
- ETL Tester Interview Questions
- Show more
Interview Questions from Similar Companies
|
Associate Project Manager
711
salaries
|  ₹3.8 L/yr - ₹9 L/yr |
|
Senior Project Coordinator
226
salaries
| ₹3 L/yr - ₹6.5 L/yr |
|
Project Manager
185
salaries
| ₹4.1 L/yr - ₹13 L/yr |
|
Project Coordinator
103
salaries
| ₹2.2 L/yr - ₹5.2 L/yr |
|
Software Engineer
91
salaries
| ₹3 L/yr - ₹10 L/yr |
Appen
TTEC India
Cognizant
Wipro
Calculate your in-hand salary
- Home >
- Interviews >
- Lionbridge Technologies Interview Questions >
- Lionbridge Technologies Senior Database Developer Interview Questions for Experienced
