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 answer...
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]
--------------------------------------------------------------
Watch video Oracle PL SQL interview question | Oracle View related question | add,drop columns in base table online, duration hours minute second in high quality that is uploaded to the channel Siva Academy 06 January 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 26,575 times and liked it 411 visitors.
