Wipro
Itaan Pharma Interview Questions and Answers
Q1. Difference between function overloading and function Overwriting
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
Q2. What is encapsulation
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
Q3. What is normalization
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
Q4. What is ACID properties
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
Q5. What is function overloading
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.
Q6. Define DDL, DCL, DML
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
Reviews
Interviews
Salaries
Users/Month