Add office photos
Engaged Employer

Wipro

3.7
based on 50.5k Reviews
Filter interviews by

Itaan Pharma Interview Questions and Answers

Updated 5 Feb 2024
Popular Designations

Q1. Difference between function overloading and function Overwriting

Ans.

Function overloading is having multiple functions with the same name but different parameters. Function overwriting is replacing a function with a new one.

  • Function overloading is used to provide multiple ways to call a function with different parameters.

  • Function overwriting is used to replace a function with a new implementation.

  • Function overloading is resolved at compile-time based on the number and types of arguments passed.

  • Function overwriting is resolved at runtime based ...read more

Add your answer

Q2. What is encapsulation

Ans.

Encapsulation is the process of hiding implementation details and exposing only necessary information.

  • Encapsulation is a fundamental concept in object-oriented programming.

  • It helps in achieving data abstraction and information hiding.

  • It allows for better control over the data and prevents unauthorized access.

  • Encapsulation is achieved through the use of access modifiers such as public, private, and protected.

  • For example, a class may have private variables that can only be acce...read more

Add your answer

Q3. What is normalization

Ans.

Normalization is the process of organizing data in a database to reduce redundancy and dependency.

  • Normalization helps in improving data consistency and accuracy

  • It involves breaking down a table into smaller tables and defining relationships between them

  • Normalization is achieved through a series of normal forms, such as first normal form (1NF), second normal form (2NF), and so on

  • Normalization can prevent data anomalies, such as update, insertion, and deletion anomalies

Add your answer

Q4. What is ACID properties

Ans.

ACID properties are a set of properties that ensure database transactions are processed reliably.

  • ACID stands for Atomicity, Consistency, Isolation, and Durability

  • Atomicity ensures that a transaction is treated as a single, indivisible unit of work

  • Consistency ensures that a transaction brings the database from one valid state to another

  • Isolation ensures that concurrent transactions do not interfere with each other

  • Durability ensures that once a transaction is committed, it will...read more

Add your answer
Discover Itaan Pharma interview dos and don'ts from real experiences

Q5. What is function overloading

Ans.

Function overloading is the ability to have multiple functions with the same name but different parameters.

  • Function overloading allows a function to perform different tasks based on the number and types of parameters passed to it.

  • It helps in writing cleaner and more readable code.

  • Example: void print(int x), void print(float x), void print(char x) are all overloaded functions with the same name but different parameter types.

Add your answer

Q6. Define DDL, DCL, DML

Ans.

DDL, DCL, and DML are three types of SQL commands used to manipulate databases.

  • DDL (Data Definition Language) is used to define the structure of the database schema, such as creating tables, altering tables, and dropping tables.

  • DCL (Data Control Language) is used to control access to the database, such as granting or revoking permissions.

  • DML (Data Manipulation Language) is used to manipulate data within the database, such as inserting, updating, and deleting records.

  • Examples ...read more

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ā¤ļø in India. Trademarks belong to their respective owners. All rights reserved Ā© 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter