| Other SQL PLSQL Interview Questions |
|| Asked @
|Write the order of precedence for validation of a column in
a table ?
|If 100 tables are there in user_tables.I want to find in which
table zero records are there with table name.Is it possible?
|write a query to find out the no. of employees whose age is
less than 25 and max of salary for the employees belonging
to a particular department is less than 20000
|Write a procedure to return the month and the number of
developers joined in each month (cursor )
|i have a table t1 a math 20
b phy 30
a math 40
b phy 23
c che 21
c che 56
write a quire to find out the max markr of each subject
|Types of joins ?
|use of IN/ANY/ALL
|What are the steps you take to tune(performance tuning) the code in plsql?
|List the differences between plsql - function & procedures
|What are the pre requisites?
|what is sql profiler
|How do you optimize SQL queries ?
|For more SQL PLSQL Interview Questions Click Here |