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

Опубликовано: 06 Январь 2021
на канале: Siva Academy

26,575

411

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]
--------------------------------------------------------------

Смотрите видео Oracle PL SQL interview question | Oracle View related question | add,drop columns in base table онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Siva Academy 06 Январь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 26,575 раз и оно понравилось 411 людям.

566