SQL Interview Questions with Answers
1. What is a primary key and why is it important in a database?
- A primary key is a unique identifier for each record in a database table. It is important because it ensures that each record can be uniquely identified and helps maintain data integrity by preventing duplicate or null values.
2. Can you explain the difference between INNER JOIN and OUTER JOIN in SQL?
- INNER JOIN returns only the rows that have matching values in both tables, while OUTER JOIN returns all rows from one table and the matched rows from the other table (or null values if there is no match).
3. How do you optimize a SQL query for better performance?
- To optimize a SQL query, you can use indexes, avoid using SELECT *, limit the number of columns selected, use appropriate data types, and avoid using functions in WHERE clauses.
4. What is normalization and why is it important in database design?
- Normalization is the process of organizing data in a database to reduce redundancy and dependency. It is important because it helps improve data integrity, reduce storage space, and make data maintenance easier.
5. How do you handle missing data in SQL queries?
- You can handle missing data in SQL queries by using functions like COALESCE or IFNULL to replace null values with a default value, or by using the IS NULL or IS NOT NULL operators to filter out records with missing data.
6. Can you explain the difference between GROUP BY and HAVING clauses in SQL?
- GROUP BY is used to group rows that have the same values into summary rows, while HAVING is used to filter groups based on specified conditions after the GROUP BY clause has been applied.
7. How do you identify and remove duplicate records from a database table?
- You can identify duplicate records by using the DISTINCT keyword or by using the GROUP BY clause with COUNT() function. To remove duplicate records, you can use the DELETE statement with a subquery that identifies the duplicates.
8. How do you write a subquery in SQL?
- A subquery is a query nested within another query. You can write a subquery by enclosing the inner query within parentheses and using it as a part of the outer query's WHERE, FROM, or SELECT clause.
9. What is the difference between a view and a table in SQL?
- A table stores actual data in a database, while a view is a virtual table that displays data from one or more tables based on a predefined query. Views do not store data themselves but provide a way to present data in a specific format.
10. How do you use indexes to improve query performance in SQL?
- Indexes are used to speed up data retrieval in SQL queries by creating an ordered list of values for one or more columns in a table. You can create indexes on columns frequently used in WHERE, JOIN, or ORDER BY clauses to improve query performance.
Hope it helps :)
1. What is a primary key and why is it important in a database?
- A primary key is a unique identifier for each record in a database table. It is important because it ensures that each record can be uniquely identified and helps maintain data integrity by preventing duplicate or null values.
2. Can you explain the difference between INNER JOIN and OUTER JOIN in SQL?
- INNER JOIN returns only the rows that have matching values in both tables, while OUTER JOIN returns all rows from one table and the matched rows from the other table (or null values if there is no match).
3. How do you optimize a SQL query for better performance?
- To optimize a SQL query, you can use indexes, avoid using SELECT *, limit the number of columns selected, use appropriate data types, and avoid using functions in WHERE clauses.
4. What is normalization and why is it important in database design?
- Normalization is the process of organizing data in a database to reduce redundancy and dependency. It is important because it helps improve data integrity, reduce storage space, and make data maintenance easier.
5. How do you handle missing data in SQL queries?
- You can handle missing data in SQL queries by using functions like COALESCE or IFNULL to replace null values with a default value, or by using the IS NULL or IS NOT NULL operators to filter out records with missing data.
6. Can you explain the difference between GROUP BY and HAVING clauses in SQL?
- GROUP BY is used to group rows that have the same values into summary rows, while HAVING is used to filter groups based on specified conditions after the GROUP BY clause has been applied.
7. How do you identify and remove duplicate records from a database table?
- You can identify duplicate records by using the DISTINCT keyword or by using the GROUP BY clause with COUNT() function. To remove duplicate records, you can use the DELETE statement with a subquery that identifies the duplicates.
8. How do you write a subquery in SQL?
- A subquery is a query nested within another query. You can write a subquery by enclosing the inner query within parentheses and using it as a part of the outer query's WHERE, FROM, or SELECT clause.
9. What is the difference between a view and a table in SQL?
- A table stores actual data in a database, while a view is a virtual table that displays data from one or more tables based on a predefined query. Views do not store data themselves but provide a way to present data in a specific format.
10. How do you use indexes to improve query performance in SQL?
- Indexes are used to speed up data retrieval in SQL queries by creating an ordered list of values for one or more columns in a table. You can create indexes on columns frequently used in WHERE, JOIN, or ORDER BY clauses to improve query performance.
Hope it helps :)
👍3❤1
1. How would you handle imbalanced datasets when building a predictive model, and what techniques would you use to ensure model performance?
Answer: When dealing with imbalanced datasets, techniques like oversampling the minority class, undersampling the majority class, or using advanced methods like SMOTE can be employed. Additionally, adjusting class weights in the model or using ensemble techniques like RandomForest can address imbalanced data challenges.
2. Explain the K-means clustering algorithm and its applications. How would you determine the optimal number of clusters?
Answer: The K-means clustering algorithm partitions data into 'K' clusters based on similarity. The optimal 'K' can be determined using methods like the Elbow Method or Silhouette Score. Applications include customer segmentation, anomaly detection, and image compression.
3.Describe a scenario where you successfully applied time series forecasting to solve a business problem. What methods did you use?
Answer: In time series forecasting, one would start with data exploration, identify seasonality and trends, and use techniques like ARIMA, Exponential Smoothing, or LSTM for modeling. Evaluation metrics like MAE, RMSE, or MAPE help assess forecasting accuracy.
4. Discuss the challenges and considerations involved in deploying machine learning models to a production environment.
Answer: Model deployment involves converting a trained model into a format suitable for production, using frameworks like Flask or Docker. Deployment considerations include scalability, monitoring, and version control. Tools like Kubernetes can aid in managing deployed models.
5. Explain the concept of ensemble learning, and how might ensemble methods improve the robustness of a predictive model?
Answer: Ensemble learning combines multiple models to enhance predictive performance. Examples include Random Forests and Gradient Boosting. Ensemble methods reduce overfitting, increase model robustness, and capture diverse patterns in the data.
Answer: When dealing with imbalanced datasets, techniques like oversampling the minority class, undersampling the majority class, or using advanced methods like SMOTE can be employed. Additionally, adjusting class weights in the model or using ensemble techniques like RandomForest can address imbalanced data challenges.
2. Explain the K-means clustering algorithm and its applications. How would you determine the optimal number of clusters?
Answer: The K-means clustering algorithm partitions data into 'K' clusters based on similarity. The optimal 'K' can be determined using methods like the Elbow Method or Silhouette Score. Applications include customer segmentation, anomaly detection, and image compression.
3.Describe a scenario where you successfully applied time series forecasting to solve a business problem. What methods did you use?
Answer: In time series forecasting, one would start with data exploration, identify seasonality and trends, and use techniques like ARIMA, Exponential Smoothing, or LSTM for modeling. Evaluation metrics like MAE, RMSE, or MAPE help assess forecasting accuracy.
4. Discuss the challenges and considerations involved in deploying machine learning models to a production environment.
Answer: Model deployment involves converting a trained model into a format suitable for production, using frameworks like Flask or Docker. Deployment considerations include scalability, monitoring, and version control. Tools like Kubernetes can aid in managing deployed models.
5. Explain the concept of ensemble learning, and how might ensemble methods improve the robustness of a predictive model?
Answer: Ensemble learning combines multiple models to enhance predictive performance. Examples include Random Forests and Gradient Boosting. Ensemble methods reduce overfitting, increase model robustness, and capture diverse patterns in the data.
👍1
Data Analytics Interview Questions
Q1: Describe a situation where you had to clean a messy dataset. What steps did you take?
Ans: I encountered a dataset with missing values, duplicates, and inconsistent formats. I used Python's Pandas library to identify and handle missing values, standardized data formats using regular expressions, and removed duplicates. I also validated the cleaned data against known benchmarks to ensure accuracy.
Q2: How do you handle outliers in a dataset?
Ans: I start by visualizing the data using box plots or scatter plots to identify potential outliers. Then, depending on the nature of the data and the problem context, I might cap the outliers, transform the data, or even remove them if they're due to errors.
Q3: How would you use data to suggest optimal pricing strategies to Airbnb hosts?
Ans: I'd analyze factors like location, property type, amenities, local events, and historical booking rates. Using regression analysis, I'd model the relationship between these factors and pricing to suggest an optimal price range. Additionally, analyzing competitor pricing in the area can provide insights into market rates.
Q4: Describe a situation where you used data to improve the user experience on the Airbnb platform.
Ans: While analyzing user feedback and platform interaction data, I noticed that users often had difficulty navigating the booking process. Based on this, I suggested streamlining the booking steps and providing clearer instructions. A/B testing confirmed that these changes led to a higher conversion rate and improved user feedback.
Q1: Describe a situation where you had to clean a messy dataset. What steps did you take?
Ans: I encountered a dataset with missing values, duplicates, and inconsistent formats. I used Python's Pandas library to identify and handle missing values, standardized data formats using regular expressions, and removed duplicates. I also validated the cleaned data against known benchmarks to ensure accuracy.
Q2: How do you handle outliers in a dataset?
Ans: I start by visualizing the data using box plots or scatter plots to identify potential outliers. Then, depending on the nature of the data and the problem context, I might cap the outliers, transform the data, or even remove them if they're due to errors.
Q3: How would you use data to suggest optimal pricing strategies to Airbnb hosts?
Ans: I'd analyze factors like location, property type, amenities, local events, and historical booking rates. Using regression analysis, I'd model the relationship between these factors and pricing to suggest an optimal price range. Additionally, analyzing competitor pricing in the area can provide insights into market rates.
Q4: Describe a situation where you used data to improve the user experience on the Airbnb platform.
Ans: While analyzing user feedback and platform interaction data, I noticed that users often had difficulty navigating the booking process. Based on this, I suggested streamlining the booking steps and providing clearer instructions. A/B testing confirmed that these changes led to a higher conversion rate and improved user feedback.
👍5❤1
Essential SQL Topics for Data Analysts
SQL for Data Analysts Free Resources -> https://news.1rj.ru/str/sqlanalyst
- Basic Queries: SELECT, FROM, WHERE clauses.
- Sorting and Filtering: ORDER BY, GROUP BY, HAVING.
- Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN.
- Aggregation Functions: COUNT, SUM, AVG, MIN, MAX.
- Subqueries: Embedding queries within queries.
- Data Modification: INSERT, UPDATE, DELETE.
- Indexes: Optimizing query performance.
- Normalization: Ensuring efficient database design.
- Views: Creating virtual tables for simplified queries.
- Understanding Database Relationships: One-to-One, One-to-Many, Many-to-Many.
Window functions are also important for data analysts. They allow for advanced data analysis and manipulation within specified subsets of data. Commonly used window functions include:
- ROW_NUMBER(): Assigns a unique number to each row based on a specified order.
- RANK() and DENSE_RANK(): Rank data based on a specified order, handling ties differently.
- LAG() and LEAD(): Access data from preceding or following rows within a partition.
- SUM(), AVG(), MIN(), MAX(): Aggregations over a defined window of rows.
Here is an amazing resources to learn & practice SQL: https://bit.ly/3FxxKPz
Share with credits: https://news.1rj.ru/str/sqlspecialist
Hope it helps :)
SQL for Data Analysts Free Resources -> https://news.1rj.ru/str/sqlanalyst
- Basic Queries: SELECT, FROM, WHERE clauses.
- Sorting and Filtering: ORDER BY, GROUP BY, HAVING.
- Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN.
- Aggregation Functions: COUNT, SUM, AVG, MIN, MAX.
- Subqueries: Embedding queries within queries.
- Data Modification: INSERT, UPDATE, DELETE.
- Indexes: Optimizing query performance.
- Normalization: Ensuring efficient database design.
- Views: Creating virtual tables for simplified queries.
- Understanding Database Relationships: One-to-One, One-to-Many, Many-to-Many.
Window functions are also important for data analysts. They allow for advanced data analysis and manipulation within specified subsets of data. Commonly used window functions include:
- ROW_NUMBER(): Assigns a unique number to each row based on a specified order.
- RANK() and DENSE_RANK(): Rank data based on a specified order, handling ties differently.
- LAG() and LEAD(): Access data from preceding or following rows within a partition.
- SUM(), AVG(), MIN(), MAX(): Aggregations over a defined window of rows.
Here is an amazing resources to learn & practice SQL: https://bit.ly/3FxxKPz
Share with credits: https://news.1rj.ru/str/sqlspecialist
Hope it helps :)
👍2
Most Important Python Topics for Data Analyst Interview:
#Basics of Python:
1. Data Types
2. Lists
3. Dictionaries
4. Control Structures:
- if-elif-else
- Loops
5. Functions
6. Practice basic FAQs questions, below mentioned are few examples:
- How to reverse a string in Python?
- How to find the largest/smallest number in a list?
- How to remove duplicates from a list?
- How to count the occurrences of each element in a list?
- How to check if a string is a palindrome?
#Pandas:
1. Pandas Data Structures (Series, DataFrame)
2. Creating and Manipulating DataFrames
3. Filtering and Selecting Data
4. Grouping and Aggregating Data
5. Handling Missing Values
6. Merging and Joining DataFrames
7. Adding and Removing Columns
8. Exploratory Data Analysis (EDA):
- Denoscriptive Statistics
- Data Visualization with Pandas (Line Plots, Bar Plots, Histograms)
- Correlation and Covariance
- Handling Duplicates
- Data Transformation
#Numpy:
1. NumPy Arrays
2. Array Operations:
- Creating Arrays
- Slicing and Indexing
- Arithmetic Operations
Integration with Other Libraries:
1. Basic Data Visualization with Pandas (Line Plots, Bar Plots)
Key Concepts to Revise:
1. Data Manipulation with Pandas and NumPy
2. Data Cleaning Techniques
3. File Handling (reading and writing CSV files, JSON files)
4. Handling Missing and Duplicate Values
5. Data Transformation (scaling, normalization)
6. Data Aggregation and Group Operations
7. Combining and Merging Datasets
Hope this helps you 😊
#Basics of Python:
1. Data Types
2. Lists
3. Dictionaries
4. Control Structures:
- if-elif-else
- Loops
5. Functions
6. Practice basic FAQs questions, below mentioned are few examples:
- How to reverse a string in Python?
- How to find the largest/smallest number in a list?
- How to remove duplicates from a list?
- How to count the occurrences of each element in a list?
- How to check if a string is a palindrome?
#Pandas:
1. Pandas Data Structures (Series, DataFrame)
2. Creating and Manipulating DataFrames
3. Filtering and Selecting Data
4. Grouping and Aggregating Data
5. Handling Missing Values
6. Merging and Joining DataFrames
7. Adding and Removing Columns
8. Exploratory Data Analysis (EDA):
- Denoscriptive Statistics
- Data Visualization with Pandas (Line Plots, Bar Plots, Histograms)
- Correlation and Covariance
- Handling Duplicates
- Data Transformation
#Numpy:
1. NumPy Arrays
2. Array Operations:
- Creating Arrays
- Slicing and Indexing
- Arithmetic Operations
Integration with Other Libraries:
1. Basic Data Visualization with Pandas (Line Plots, Bar Plots)
Key Concepts to Revise:
1. Data Manipulation with Pandas and NumPy
2. Data Cleaning Techniques
3. File Handling (reading and writing CSV files, JSON files)
4. Handling Missing and Duplicate Values
5. Data Transformation (scaling, normalization)
6. Data Aggregation and Group Operations
7. Combining and Merging Datasets
Hope this helps you 😊
👍1
Important questions for data analyst interview👇👇
1. Can you walk me through a project where you had to analyze a large dataset and draw meaningful insights from it?
2. How do you ensure the accuracy and reliability of your analysis results?
3. What programming languages and tools are you proficient in for data analysis?
4. How do you approach data cleaning and preprocessing before conducting analysis?
5. Can you give an example of a time when you had to communicate complex data analysis results to non-technical stakeholders?
6. How do you stay current with industry trends and best practices in data analysis?
7. Have you ever worked with machine learning algorithms or predictive modeling? If so, can you provide an example of a project where you applied these techniques?
8. How do you handle missing or incomplete data in your analysis process?
9. Can you discuss a challenging problem you encountered during a data analysis project and how you overcame it?
10. How do you prioritize and manage multiple projects or tasks simultaneously as a data analyst?
1. Can you walk me through a project where you had to analyze a large dataset and draw meaningful insights from it?
2. How do you ensure the accuracy and reliability of your analysis results?
3. What programming languages and tools are you proficient in for data analysis?
4. How do you approach data cleaning and preprocessing before conducting analysis?
5. Can you give an example of a time when you had to communicate complex data analysis results to non-technical stakeholders?
6. How do you stay current with industry trends and best practices in data analysis?
7. Have you ever worked with machine learning algorithms or predictive modeling? If so, can you provide an example of a project where you applied these techniques?
8. How do you handle missing or incomplete data in your analysis process?
9. Can you discuss a challenging problem you encountered during a data analysis project and how you overcame it?
10. How do you prioritize and manage multiple projects or tasks simultaneously as a data analyst?
👍2❤1
Data Analyst Interview Questions 👇
1.How to create filters in Power BI?
Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.
Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)
2.How to sort data in Power BI?
Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.
3.How to convert pdf to excel?
Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.
4. How to enable macros in excel?
Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.
1.How to create filters in Power BI?
Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.
Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)
2.How to sort data in Power BI?
Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.
3.How to convert pdf to excel?
Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.
4. How to enable macros in excel?
Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.
👍2❤1
Here's a list of commonly asked data analyst interview questions:
1. Tell me about yourself : This is often the opener, allowing you to summarize your background, skills, and experiences.
2. What is the difference between data analytics and data science?: Be ready to explain these terms and how they differ.
3. Describe a typical data analysis process you follow: Walk through steps like data collection, cleaning, analysis, and interpretation.
4. What programming languages are you proficient in?: Typically SQL, Python, R are common; mention any others you're familiar with.
5. How do you handle missing or incomplete data?: Discuss methods like imputation or excluding records based on criteria.
6. Explain a time when you used data to solve a problem: Provide a detailed example showcasing your analytical skills.
7. What data visualization tools have you used?: Tableau, Power BI, or others; discuss your experience.
8. How do you ensure the quality and accuracy of your analytical work?: Mention techniques like validation, peer reviews, or data audits.
9. What is your approach to presenting complex data findings to non-technical stakeholders?: Highlight your communication skills and ability to simplify complex information.
10. Describe a challenging data project you've worked on: Explain the project, challenges faced, and how you overcame them.
11. How do you stay updated with the latest trends in data analytics?: Talk about blogs, courses, or communities you follow.
12. What statistical techniques are you familiar with?: Regression, clustering, hypothesis testing, etc.; explain when you've used them.
13. How would you assess the effectiveness of a new data model?: Discuss metrics like accuracy, precision, recall, etc.
14. Give an example of a time when you dealt with a large dataset: Explain how you managed and processed the data efficiently.
15. Why do you want to work for this company?: Tailor your response to highlight why their industry or culture appeals to you
1. Tell me about yourself : This is often the opener, allowing you to summarize your background, skills, and experiences.
2. What is the difference between data analytics and data science?: Be ready to explain these terms and how they differ.
3. Describe a typical data analysis process you follow: Walk through steps like data collection, cleaning, analysis, and interpretation.
4. What programming languages are you proficient in?: Typically SQL, Python, R are common; mention any others you're familiar with.
5. How do you handle missing or incomplete data?: Discuss methods like imputation or excluding records based on criteria.
6. Explain a time when you used data to solve a problem: Provide a detailed example showcasing your analytical skills.
7. What data visualization tools have you used?: Tableau, Power BI, or others; discuss your experience.
8. How do you ensure the quality and accuracy of your analytical work?: Mention techniques like validation, peer reviews, or data audits.
9. What is your approach to presenting complex data findings to non-technical stakeholders?: Highlight your communication skills and ability to simplify complex information.
10. Describe a challenging data project you've worked on: Explain the project, challenges faced, and how you overcame them.
11. How do you stay updated with the latest trends in data analytics?: Talk about blogs, courses, or communities you follow.
12. What statistical techniques are you familiar with?: Regression, clustering, hypothesis testing, etc.; explain when you've used them.
13. How would you assess the effectiveness of a new data model?: Discuss metrics like accuracy, precision, recall, etc.
14. Give an example of a time when you dealt with a large dataset: Explain how you managed and processed the data efficiently.
15. Why do you want to work for this company?: Tailor your response to highlight why their industry or culture appeals to you
👍1
1.Define RDBMS.
Answer: Relational Database Management System(RDBMS) is based on a relational model of data that is stored in databases in separate tables and they are related to the use of a common column. Data can be accessed easily from the relational database using Structured Query Language (SQL).
2.Define DML Compiler.
Answer: DML compiler translates DML statements in a query language into a low-level instruction and the generated instruction can be understood by Query Evaluation Engine.
3.Explain the terms ‘Record’, ‘Field’ and ‘Table’ in terms of database.
Answer:
Record: Record is a collection of values or fields of a specific entity. For Example, An employee, Salary account, etc.
Field: A field refers to an area within a record that is reserved for specific data. For Example, Employee ID.
Table: Table is the collection of records of specific types. For Example, the Employee table is a collection of records related to all the employees.
4.Define the relationship between ‘View’ and ‘Data Independence’.
Answer: View is a virtual table that does not have its data on its own rather the data is defined from one or more underlying base tables.
Views account for logical data independence as the growth and restructuring of base tables are not reflected in views.
Answer: Relational Database Management System(RDBMS) is based on a relational model of data that is stored in databases in separate tables and they are related to the use of a common column. Data can be accessed easily from the relational database using Structured Query Language (SQL).
2.Define DML Compiler.
Answer: DML compiler translates DML statements in a query language into a low-level instruction and the generated instruction can be understood by Query Evaluation Engine.
3.Explain the terms ‘Record’, ‘Field’ and ‘Table’ in terms of database.
Answer:
Record: Record is a collection of values or fields of a specific entity. For Example, An employee, Salary account, etc.
Field: A field refers to an area within a record that is reserved for specific data. For Example, Employee ID.
Table: Table is the collection of records of specific types. For Example, the Employee table is a collection of records related to all the employees.
4.Define the relationship between ‘View’ and ‘Data Independence’.
Answer: View is a virtual table that does not have its data on its own rather the data is defined from one or more underlying base tables.
Views account for logical data independence as the growth and restructuring of base tables are not reflected in views.
👍1