·
Roles and Responsibilities of current project
·
Rate yourself out of 10 in sql and plsql
·
What are materialized views
·
Different methods of refreshing Materialized
views and normal view , difference between both
·
What are indexes? How it improves the
performance
·
A table which gets updated frequently , should
we create index on the frequently
updated columns
·
Can we write commit inside trigger.
·
Can we alter the execution sequence of triggers?
·
What is mutating trigger
·
How to avoid mutating trigger
·
Select all the employees whose have worked for more than one year in the current organization
·
Schema A and schema B, table employees exist in
both the schemas. Procedure PRC1 is in schema A. on executing prc1, from schema
B, employee table from which schema gets effected.
·
Grants required executing DML on a table in different
schema.
·
Whether oracle generates insert scripts when
uploading data through sqlldr.
·
Select employees from a table earning maximum
salary department wise.
·
Difference between truncate and delete. Which is
faster in performance?
·
Table has records. Can we alter a table to add column with not null
constraint.
·
Difference between function and procedure
·
What is NOCOPY hint? Explain
·
Select all the names which contain kumar in their
name irrespective of case;
·
upper(ename) like’ %KUMAR%’;
