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)

1
When you use WHERE clause and when you use HAVING clause?
2
How will you delete duplicating rows from a base table?
3
What is difference between SQL and SQL*PLUS?
4
What is difference between UNIQUE and PRIMARY KEY constraints?
5
What are different Oracle database objects?