What are analytical functions, what is the difference between rank and dens_rank, different types of joins, what is the difference between view and materialized view, different types of refresh methods in Mview, types of partitions, what is trigger, what is mutating table

Question

Accepted Answer

Analytical functions are used to perform calculations across a set of rows. Rank assigns a unique rank to each row, while dens_rank assigns consecutive ranks.

Analytical functions are used to perform calculations across a set of rows in a table.
Rank function assigns a unique rank to each row based on the specified order.
Dens_rank function assigns consecutive ranks to rows, leaving no gaps between ranks.
Types of joins include inner join, outer join, left join, right join, etc.
A view is a virtual table based on the result set of a SQL statement, while a materialized view stores the result set physically.
Refresh methods for materialized views include complete, fast, force, and on demand refresh.
Types of partitions in databases include range, list, hash, composite, etc.
A trigger is a database object that is automatically executed in response to certain events on a particular table or view.
A mutating table error occurs when a trigger tries to reference the table that is already being modified.

What are analytical functions, what is the difference between rank and dens_rank, different types of joins, what is the difference between view and materialized view, different types of refresh methods in Mview, types of partitions, what is trigger, what is mutating table

Top LTIMindtree Software Engineering Specialist interview questions & answers

Popular interview questions of Software Engineering Specialist

Top HR questions asked in LTIMindtree Software Engineering Specialist