Oracle Interview questions

Total available count: 35
Subject - Databases
Subsubject - Oracle

Difference between an implicit & an explicit cursor.?

PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including queries that return only one row. However, queries that return more than one row you should declare an explicit cursor or use a cursor FOR loop. 

Explicit cursor is a cursor in which the cursor name is explicitly assigned to a SELECT statement via the CURSOR...IS statement. An implicit cursor is used for all SQL statements Declare, Open, Fetch and Close. Explicit cursors are used to process multirow SELECT statements An implicit cursor is used to process INSERT, UPDATE, DELETE, and single row SELECT. .INTO statements. 

Next 5 interview question(s)

How you will avoid your query from using indexes?
When you use WHERE clause and when you use HAVING clause?
How will you delete duplicating rows from a base table?
What is difference between SQL and SQL*PLUS?
What is difference between UNIQUE and PRIMARY KEY constraints?