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
Top trending discussions
I applied via Walk-in and was interviewed in Aug 2023. There were 4 interview rounds.
I applied via Referral and was interviewed before Jun 2023. There were 3 interview rounds.
posted on 3 Nov 2024
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
It was normal english versant test
Molecular dynamics is a simulation method used to study the movements and interactions of atoms and molecules over time.
It involves solving Newton's equations of motion for a system of interacting particles.
It can provide insights into the behavior of biological molecules, materials, and chemical reactions.
Examples include studying protein folding, drug binding to receptors, and material properties at the atomic level.
I applied via Walk-in and was interviewed in Aug 2023. There were 2 interview rounds.
Easy to crack and some are aptitude and some are clinical research questions
The phases of CDM are data collection, data cleaning, data analysis, and data interpretation.
Data collection involves gathering relevant data from various sources.
Data cleaning involves removing errors, inconsistencies, and outliers from the collected data.
Data analysis involves applying statistical methods and techniques to analyze the cleaned data.
Data interpretation involves drawing meaningful conclusions and insigh
I applied via Campus Placement and was interviewed in Jul 2023. There were 3 interview rounds.
I applied via Company Website and was interviewed in Apr 2022. There were 3 interview rounds.
N-alkylation is a process of adding an alkyl group to a primary or secondary amine.
N-alkylation can be achieved through various methods such as reductive amination, Gabriel synthesis, and Hoffmann degradation.
Primary amines can be selectively N-alkylated using alkyl halides and a base, while secondary amines require a more reactive alkylating agent such as an epoxide or an alkyl halide.
N-alkylation is an important reac...
Some of the top questions asked at the IQVIA Associate interview -
based on 1 interview
Interview experience
based on 11 reviews
Rating in categories
Consultant
1.1k
salaries
| ₹8.4 L/yr - ₹30 L/yr |
Associate Consultant
1.1k
salaries
| ₹4.8 L/yr - ₹19.1 L/yr |
Drug Safety Associate
756
salaries
| ₹2 L/yr - ₹8.5 L/yr |
Clinical Data Specialist
753
salaries
| ₹3.5 L/yr - ₹11.5 L/yr |
Software Developer
714
salaries
| ₹4.9 L/yr - ₹18.8 L/yr |
Cognizant
Accenture
TCS
Infosys