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

--------------------------------------------------------------

--------------------------------------------------------------

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

--------------------------------------------------------------

[madhavisagam]

Hi have listened all of ur 68 present iam attending the interviews....out of 20 questions in the interview we can cover nearly 15 to 16 questions if we watch full 68 videos iam very thankful to you i have offers with tcs, cognizant, Capgemini and i accepted my joining date is on 6th of this videos really helped cant express in

[gauravdutta]

You are doing a noble job sir !!
There are a lot of YouTubes with millions of subscribers but you are actually providing some real help to the technical people 🙏🏻

[nirmalasai]

Sir we are blessed to watching u r vedios ❤️ really it's like spoon feeding for us 🥰

[devanaidu]

Hi Sir,

Excellent video very nice explanation Sir..thank you sir keep sharing your knowledge with us👍😊

[manojkumarrajaka]

First like first cmt.. I didn't watch the video still.. But I hit like and shared.. Love u bro.. 😍😍

[Sreeramulugslgsl]

Hi, Which one is faster view or temporary table?

[bhushanpalse]

Which are different types of methods in Materialized View?

What is Acid?

[ravibathula]

it is very new lot of things are new to me sir start videos on unix also

[dhavalpandya]

Hello sir,
And if we add a new column to the existing table then Querying from view will not give any error.

[abbeydudeuk]

is there any equivalent to with schema binding (SQL server concept) in oracle?

[jayantaghosh]

Hi Sir, you're doing a very good job we are really greatful.
Sir, Can you please make some videos on oracle hints(performance tuning) these questions are getting frequently asked in interviews.

[VishalGupta-khgc]

Sir suppose 2nd last table is temp table of a final table.from that temp table we can create final table and we have 2nd option is to insert a data from temp table .so which is better option?and why Sir

[Variable.Constant.]

Dear Siva, Question, If anyway we want this newly added column in the view, how we will do that..

I think we need to drop and recreate? Do you echo my views?

[kirankumarreddy]

Bro, can you please do a video on debugging techniques in Plsql ?

[manjutharak]

Bro waiting for Oracle Hints also i ask 3months back oracle jobs also 😒

[manojkumarrajaka]

Bro..hw u got the ideas.. Wanna see u in video.. Please do a video like that bro.. Plz

[abheshkumar]

Pls make a video what is before trigger and after trigger
And what a difference

[abhisheknegi]

Please make video for performance tuning also

[kamalb]

Hi sir,
Please can you create a video for gather statistics

[sarvanikaluguri]

Sir, please tell about alter view<view name> compile ; how it sync view with latest changes ? Like datalength, datatype modifications ...