Oracle PL SQL interview question | Oracle View related question | add,drop columns in base table

Oracle PL SQL interview question | Oracle View related question | add,drop columns in base table After creating a view like "create or replace view emp_view as select * from emp" Question 1: If we add a NEW column to the base table, will that column get added to view? Question 2: If we drop an existing column from the base table, what will happen to view? Question 3: How to check the list of objects used in a view? -------------------------------------------------------------- This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.    / sivaacademy   Home page: https://sivakacademy.blogspot.com/ Telegram Channel : https://t.me/SivaAcademy -------------------------------------------------------------- Home page: https://sivakacademy.blogspot.com/ List of all oracle SQL/PLSQL Interview questions https://sivakacademy.blogspot.com/p/s... List of all PLSQL Scenario based Interview Questions https://sivakacademy.blogspot.com/p/p... List of all Subscriber questions and answers https://sivakacademy.blogspot.com/p/a... -------------------------------------------------------------- Oracle Interview questions playlist    • oracle interview questions and answers for...   Oracle 18C New features playlist    • Oracle 18C New Feature   Oracle 12C New features playlist    • Oracle 12C New Feature Series   Oracle PLSQL records and collections playlist    • oracle plsql records and collections   -------------------------------------------------------------- My video courses at UDEMY https://www.udemy.com/user/2c29d781-3... -------------------------------------------------------------- About Myself: ---------------------- I am Siva, [LEARN | CODE | TRAIN | SHARE]. Being in IT industry for more than 12+ years. In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX. I am passionate about "DATA", coding & training. In my spare time, I teach database technologies , ETL etc. I am very glad that you are reading my Profile, and I value your time as well as mine. Looking forward to see you in my videos For any questions, please drop me a mail at [email protected] --------------------------------------------------------------