What is data definition language?
No Answer is Posted For this Question
Be the First to Post Answer
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
How packaged procedures and functions are called from the following?
Why do we use procedures in sql?
What is Collation Sensitivity ? What are the various type ?
Does normalization improve performance?
Explain constraints in sql?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?
What is a primary key? Explain
When are we going to use truncate and delete?
What is procedure explain with program?