DBA / Database

What are indexes in a database?

Explain the difference between WHERE and HAVING

Is it possible to throw exceptions inside a trigger? What will happen to the database and the RS Bank interface?

What are triggers? What types of triggers are there?

What is a temporary table in SQL/PLSQL? Do you use temporary tables?

Will using an indexed column speed up GROUP BY and ORDER BY operations?

Что такое TCL? Какие команды входят в TCL?

What is the difference between COUNT(*) and COUNT(1) — which one is better to use?

What is the difference between TRUNCATE and DELETE?

Explain the concept of normalization and its benefits.

BEGIN LOOP UPDATE table SET status = 'PROCESSED' WHERE category = 'OLD' AND ROWNUM <= 50000; EXIT WHEN SQL%NOTFOUND; COMMIT; END LOOP;

How to handle exceptions inside a trigger? Is it better to report the error or to silence it?

What are BULK COLLECT and FORALL? What are their differences and advantages?

What is Mutating table error?

What happens inside Oracle when executing a SELECT query (after pressing F8)?