Filter interviews by
Calculation and Logics
Alter command on table affects views created on the table.
Views are virtual tables created from one or more tables.
Alter command on a table can change the structure of the table, which can affect the views created on it.
If the columns used in the view are altered or dropped, the view will become invalid.
If the data in the table is changed, the data in the view will also change accordingly.
Data transformations in SSIS include Lookup which retrieves data from a source based on a matching condition.
Lookup is used to retrieve data from a source based on a matching condition
It can be used to perform joins between two data sources
Lookup can be used to update or insert data into a destination based on a match
Other data transformations in SSIS include sorting, aggregating, and merging data
Drop deletes the table structure and data, truncate deletes only data, and delete deletes specific rows.
Drop: removes the table and all its data permanently
Truncate: removes all data from the table but keeps the structure
Delete: removes specific rows from the table based on a condition
Drop and truncate cannot be rolled back, but delete can be
Drop and truncate reset the identity of the table, but delete does not
Truncate resets identity value, delete does not.
Truncate resets the identity value to the original seed value
Delete does not change the identity value
Example: Truncate table resets identity value to 1
Example: Delete from table does not change identity value
Joins are used to combine data from two or more tables based on a related column. Types include inner, outer, left, right, and cross join.
Inner join returns only the matching rows from both tables.
Outer join returns all rows from both tables, with null values for non-matching rows.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and m...
Query to join employees who are all managers using id in the table.
Use self join to join the table on manager id and employee id
Filter the result to only include employees who are also managers
Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.id = e2.manager_id WHERE e2.manager_id IS NOT NULL
Ensure that the table has a manager_id column
I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.
ADR stands for Alternative Dispute Resolution. It is a process of resolving disputes outside of the court system.
ADR includes methods such as mediation, arbitration, and negotiation.
It is often used as a quicker and less expensive alternative to traditional litigation.
ADR can be voluntary or mandatory, depending on the situation.
Examples of ADR include settling a divorce through mediation, resolving a business dispute ...
Valid case criteria
The case must have a clear and specific problem or issue
The case must have relevant and reliable data or information
The case must have a logical and coherent structure
The case must have realistic and feasible solutions
The case must have potential for learning and application
The case must have ethical and legal considerations
The case must have appropriate scope and complexity
Causality refers to the relationship between an event (the cause) and a second event (the effect), where the second event is a result of the first.
Causality is the principle that everything has a cause and effect.
It is the relationship between an action and its consequences.
For example, smoking causes lung cancer.
Causality is important in scientific research to establish cause-and-effect relationships.
It is also import...
I applied via Campus Placement and was interviewed before Feb 2020. There were 5 interview rounds.
IQVIA interview questions for designations
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
Annotations are used in Springboot to simplify configuration and reduce boilerplate code.
Annotations are used to define the behavior of Spring components
They can be used to define the scope of a bean, inject dependencies, and handle exceptions
Some commonly used annotations include @Component, @Autowired, and @ExceptionHandler
Java 8 introduced several new features including lambda expressions, streams, and default methods.
Lambda expressions allow for functional programming and simplify code.
Streams provide a way to process collections of data in a functional style.
Default methods allow for adding new methods to interfaces without breaking existing implementations.
Other features include the Optional class, Date and Time API, and Nashorn Java
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2021. There were 2 interview rounds.
Focus on industry-specific nuances
I applied via Naukri.com and was interviewed in Jun 2019. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before May 2021. There were 2 interview rounds.
Coding questions will be given
I appeared for an interview before May 2021.
Quant, reasoning, English
Some of the top questions asked at the IQVIA Associate interview -
based on 1 interview
Interview experience
based on 11 reviews
Rating in categories
Associate Consultant
1.1k
salaries
| ₹5 L/yr - ₹19.5 L/yr |
Consultant
1.1k
salaries
| ₹8.5 L/yr - ₹30 L/yr |
Clinical Data Specialist
765
salaries
| ₹3.5 L/yr - ₹11.1 L/yr |
Drug Safety Associate
744
salaries
| ₹2.2 L/yr - ₹8.5 L/yr |
Software Developer
726
salaries
| ₹5.5 L/yr - ₹19 L/yr |
Cognizant
Accenture
TCS
Infosys