Packages, cursors, pipeline functions, indexes, SQL tunning
Pl Sql Developer Junior Interview Questions
297 pl sql developer junior interview questions shared by candidates
PLSQL collection and how to update column using bulk update?
Joins, Acid properties, constraints, diff types, aggregate functions, how to improve performance, cursor types of cursor, triggers type of triggers, views and materialized views diff also, operators bulk collect and for all statement,indexing, n its types, clustered and non-clustered index diff,correlated query,partitions, diff b/w truncate and drop, dml ddl n dcl commands, normalization, hierarchical representation from any table write a query, mutating error, instead of trigger indirect use, one question from package
It was most difficult interview, asking everything related to databas.
How to enter variable in SQL routines
what difference between delet and truncate ?
about performance tunning and triggers
Q. What is the view and materialized view?
sql loader. How to truncate partition. error in extenal table. some scenario based external table and partition. and some query
Find the department ID that has the highest average maximum salary
Viewing 151 - 160 interview questions