Filter interviews by
I applied via LinkedIn and was interviewed in May 2021. There was 1 interview round.
Top trending discussions
I applied via Walk-in and was interviewed in Aug 2023. There were 4 interview rounds.
Calculation and Logics
I applied via Campus Placement and was interviewed before Feb 2020. There were 5 interview rounds.
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...
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
posted on 15 Feb 2022
I applied via LinkedIn and was interviewed in Aug 2021. There were 2 interview rounds.
posted on 28 Oct 2024
I applied via Referral and was interviewed in Mar 2023. There were 2 interview rounds.
I was interviewed before Apr 2022.
Drug Safety Associate
349
salaries
| ₹0 L/yr - ₹0 L/yr |
Drug Safety Associate 1
237
salaries
| ₹0 L/yr - ₹0 L/yr |
Drug Safety Associate 2
224
salaries
| ₹0 L/yr - ₹0 L/yr |
Regulatory Affairs Associate
192
salaries
| ₹0 L/yr - ₹0 L/yr |
Drug Safety Specialist
164
salaries
| ₹0 L/yr - ₹0 L/yr |
IQVIA
ICON Plc
Fortrea Development India Private Limited
Syneos Health