| Other Oracle General Interview Questions |
|| Asked @
|What is a Schema ?
|5. Display full details from the ORDER_LINE table where the
item number is (first condition) between 1 and 200 (no > or
< operators) OR the item number is greater than 1000 AND
(second condition) the item cost is not in the list 1000,
2000, 3000 OR the order number is not equal to 1000.
|What is currency type in database ?
|A VIEWS takes memory in the database.
If yes, how can u proove it?
is there any way to display the size of views?
Name dept month sal
1 A JAN 800
2 B APR 1000
3 A JAN 300
4 A JAN 600
5 C JUN 400
1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH?
2) WRITE QUERY GET MAX SAL DEPT NO?
|Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
|sql query to get zero records from a table
|What is a cluster Key ?
|What is a Temporary Segment ?
|does the query needs a hint to access a materialized view?
|what is the difference between UNION AND UNIONALL
|Which database is better for os platform dependency?
|For more Oracle General Interview Questions Click Here |