Oracle Interview questions

Total available count: 35
Subject - Databases
Subsubject - Oracle

How you will avoid your query from using indexes?

SELECT * FROM slightbook Where slightbook_no+' '=12345;

i.e you have to concatenate the column name with space within codes in the where condition.

SELECT /*+ FULL(a) */ slightbookname, slightbook_no from slightbook where slightbook_no=1234;

i.e using HINTS 

Next 5 interview question(s)

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?
What are different Oracle database objects?