IQVIA Database Designer Interview Questions and Answers

Q1. Steel and super structure (pile,girder,ms excell,steel reconslation,auto cad,planning ,) Core design type pile quiestion and prestressing process and calculation etc
Add your answer

Q1. Roles and responsibilities in present company Salary negotiations
Add your answer

General aptitude along with reasoning

Q1. Basic question on your projet in the previous organisations
Add your answer
Q2. Behavioral questions
Add your answer

Q1. General HR discussion and negotiating salary
Add your answer

Q1. Is sql necessary for your project ?
Ans. 
SQL is necessary for most projects involving databases to manage and query data efficiently.
• SQL is essential for creating, updating, and querying databases in most projects.

• Without SQL, it would be challenging to interact with databases and retrieve specific data.

• Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.

• SQL can help optimize database performance and ensure data integrity.
Answered by AI
Add your answer
Q2. What is Hql ?
Ans. 
HQL stands for Hibernate Query Language, a query language similar to SQL but used for Hibernate ORM framework.
• HQL is used to perform database operations in Hibernate ORM framework.

• It is similar to SQL but operates on Hibernate objects instead of database tables.

• HQL queries are written in Hibernate-specific syntax.

• Example: 'FROM Employee e WHERE e.department = :dept'

• HQL queries are translated into SQL queries by Hiberna
Answered by AI
Add your answer
Q3. What are views ?
Ans. 
Views in Java are user interface components that display data from a model in a specific format.
• Views are used to represent the user interface in Java applications.

• They display data from a model in a visually appealing format.

• Examples include buttons, text fields, labels, and checkboxes.
Answered by AI
Add your answer
Q4. What are cross joins ?
Ans. 
Cross joins are a type of join operation in SQL that combines each row from one table with each row from another table.
• Cross joins do not have a join condition specified, resulting in a Cartesian product of the two tables.

• They can be used when you want to combine every row from one table with every row from another table.

• Cross joins can lead to a large result set if the tables being joined have many rows.
Answered by AI
Add your answer
Q5. Difference between delete and truncate
Ans. 
Delete removes rows one by one, while truncate removes all rows at once.
• Delete is a DML command, while truncate is a DDL command.

• Delete can be rolled back, while truncate cannot be rolled back.

• Delete fires triggers, while truncate does not fire triggers.

• Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
Answered by AI
Add your answer

They send an mail which have the link about assessment test

In hall all are discussed and written an interview test

Q1. Self details, antidiabetis drugs,project ,ect
Add your answer

Quantity, reasonning, English question and have coding

Q1. Explain yourself
Ans. 
I am a dedicated and experienced consultant with a strong background in problem-solving and client management.
• Over 5 years of experience in consulting roles

• Skilled in analyzing data and providing strategic recommendations

• Excellent communication and interpersonal skills

• Proven track record of successfully managing client relationships

• Strong ability to work under pressure and meet deadlines
Answered by AI
Add your answer

Normal question of reasoning and maths

Sorting arraylist , sorted map