Oracle PL SQL interview question | Oracle constraint related interview question

Oracle PL SQL interview question | Oracle constraint related interview question
---------------------------------------------------------------------------------------------------------------------------

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

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

[Adbhutashole]

Now days things are changed totally ...net is available everywhere and by the help of such an excellent Guru (teacher) anyone can complete the whole training in a month ..he already have completed the 101% interview complex questions in his videos.People are so lucky now...

But few years ago, it will takes whole days to short out a single problem.it was takes 3 days to learn the logic of the Cursor ...

[Ganeshay-]

What is "index clustering factor" ? select one or more relevant answer
it shows the rate of index fragmentation,
it's a metric relevant to the keys spread in index,
it relates to the data organization in table,
it is the number of keys used in indexed table cluster

[ganeshkhopde]

Hi Siva thanks for the tutorials on plsql interview questions.

[pravalsoni]

Thank you so much sir because of your videos i recently cracked an interview.. Thanks a ton
Awaiting for a detailed video series on Explain plan like how to read the explain plan and take necessary measures.

[abhishekrahagude]

Waiting for a long time...for this vedio...
Please create vedio on Varchar vs Nvarchar vs Nvarchar2 vs varchar2...with examples... please.

[BewithuNnk]

Hi siva garu, Your videos are very useful and gained technical knowledge. Please explain what is table level, coloum and row level constraints? Which constraints is not a table level

[avuthusiva]

If we index created on column nonunique index
Again we created primary key on same column,
That index type still showing as nonunique.
But it not satisfying the primary key functionality

[pankajkharade]

THANS SIR, KNOWLEDGE THAT YOU ARE SHARING IS MOST VALUABLE

[rsquare]

One interview question why do we use primary key if we have unique not null constraint And what is the difference between primary key and unique not null.

[khasimkhan]

I was interviewed in one of the MNC they have asked me in which situation u will use join or set operations

[padmapriya]

Hello sir,

Hope u r doing good. Please do some programming video with some requirements.

[prashanth]

Hi SIVA could you please explain Unix commands with examples in detail.

[kumarsisir]

Difference raise application error vs pragma exception_in

[magicalland]

Hi sir, please upload architecture related videos