Softdel Interview Questions and Answers for Experienced

Q1. What is normalization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization helps in minimizing data redundancy by dividing the database into multiple tables.

• It ensures data integrity by avoiding update anomalies.

• Normalization is achieved through a series of rules called normal forms, such as 1NF, 2NF, 3NF, etc.

• Example: In a database, instead of storing customer details i...read more
Answered by AI
Add your answer
Q2. What is reflection
Ans. 
Reflection is the ability of a program to examine and modify its own structure and behavior at runtime.
• Allows accessing metadata of types and members at runtime

• Enables dynamic instantiation of objects

• Facilitates invoking methods dynamically
Answered by AI
Add your answer

Q1. Ques -> Can you define difference b/w Azure data lake and Delta lake.
Ans. 
Azure Data Lake is a cloud-based storage and analytics service, while Delta Lake is an open-source storage layer that adds reliability to data lakes.
• Azure Data Lake is a service provided by Microsoft Azure for storing and analyzing large amounts of data.

• Delta Lake is an open-source storage layer that adds ACID transactions and schema enforcement to data lakes.

• Azure Data Lake is a cloud-based solution, while Delta Lake ...read more
Answered by AI
Add your answer
Q2. How to implemented Primary key and foreign key in delta tables.
Ans. 
Primary keys and foreign keys can be implemented in delta tables using constraints and references.
• Primary keys can be implemented using the PRIMARY KEY constraint, which ensures that each record in the table has a unique identifier.

• Foreign keys can be implemented using the FOREIGN KEY constraint, which establishes a link between two tables based on a common column.

• The referenced table must have a primary key defined, a...read more
Answered by AI
Add your answer
Q3. How to handle exception in python?
Ans. 
Exception handling in Python allows for the graceful handling of errors and prevents program crashes.
• Use try-except blocks to catch and handle exceptions.

• Multiple except blocks can be used to handle different types of exceptions.

• The finally block is executed regardless of whether an exception occurred or not.

• Exceptions can be raised using the 'raise' keyword.

• Custom exceptions can be defined by creating a new class that
Answered by AI
Add your answer
Q4. What is star schema and snowflake schema
Ans. 
Star schema is a data modeling technique where a central fact table is connected to multiple dimension tables. Snowflake schema is an extension of star schema with normalized dimension tables.
• Star schema is a simple and denormalized structure

• It consists of a central fact table connected to multiple dimension tables

• Dimension tables contain descriptive attributes

• Star schema is easy to understand and query, but can lead t...read more
Answered by AI
Add your answer
Q5. Which are the most frequently change
Ans. 
The most frequently changing data
• Customer preferences

• Market trends

• Weather data

• Stock prices

• Social media trends
Answered by AI
Add your answer

General Aptitude Questions

Q1. Queries on SQL, Basic Statistic Question related to normal curve, Basic Python question(from python interview question list of any website)
Add your answer
Q2. Shape of normal Distribution
Ans. 
The shape of a normal distribution is bell-shaped and symmetrical.
• A normal distribution has a peak at the mean and tails that extend to infinity in both directions.

• The distribution is symmetrical, meaning that the left and right halves mirror each other.

• The standard deviation determines the spread or width of the distribution.

• Many natural phenomena and measurements in various fields follow a normal distribution.

• Example...read more
Answered by AI
Add your answer
Q3. Valuess of mean median and mode
Ans. 
Mean, median, and mode are measures of central tendency in statistics.
• Mean is the average of a set of numbers, calculated by summing all the values and dividing by the total count.

• Median is the middle value in a sorted list of numbers. If there is an even number of values, it is the average of the two middle values.

• Mode is the value that appears most frequently in a set of numbers. It can be a single value or multiple
Answered by AI
Add your answer

Q1. General HR questions
Add your answer

Q1. General discussion round with ceo and about projects
Add your answer

De/algo leetcode medium level

Q1. What is OOPS concept
Ans. 
OOPS (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
• OOPS focuses on creating objects that interact with each other to solve problems

• Key principles include encapsulation, inheritance, polymorphism, and abstraction

• Encapsulation involves bundling data and methods that operate on the data into a single unit

• Inheritance allows one class to inherit prop...read more
Answered by AI
Add your answer
Q2. What is Encapsulation
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for better control over the data by preventing direct access from outside the class.

• Getters and setters are commonly used to access and modify the encapsulated data.

• Example: In a Car class, variables l...read more
Answered by AI
Add your answer
Q3. Define Four pillars
Ans. 
The four pillars of object-oriented programming in Java are abstraction, encapsulation, inheritance, and polymorphism.
• Abstraction: Hides complex implementation details and only shows the necessary features to the outside world.

• Encapsulation: Bundles data and methods that operate on the data into a single unit, preventing direct access from outside the class.

• Inheritance: Allows a class to inherit properties and behavior...read more
Answered by AI
Add your answer

Questions on java with basic coding

Q1. Question java , mysql, DS
Add your answer

Q1. Advanced Questions on java , mysql
Add your answer

Q1. Common question on managing with team
Add your answer

Q1. Mention GA KPIs you’ll check to increase CVR
Add your answer
Q2. What steps you’ll take to resolve a decline page visits trend
Add your answer