Oracle Database Discussions

Gurus,

I have recently attend an interview. I have some queries to ask .. Please provide me the answers or any links

OS is Windows
Oracle version : 9i

1) I have marks table .. Structure is


marks
=====
student id
subject
marks
term

Data is

1, physics,70,1
1, physics,80,2
1, chemistry,60,1
2, chemistry,70,1
2, chemistry,70,2
2, physics,60,1

Write a query to retrieve only the latest term marks (subject wise)

2) What are oracle queues

3) How many types of optimizers we have

4) Two queuries have been executed, when i did explain plan .. first query cost returned 60, second query cost returned 20, but both the queries have returned similar rows, which query has to be considered and why

5) I have logged in as a scott user, now i want to see only the data related to scott user ...how can I achieve this ?

6) What's virtual database

7) Can I give commit in database trigger

8) I have a block

Begin
Update emp
set sal = 1000
where name = 'KING';

Exception
when no_data_ found then

when too_many_rows then

when others then

End

In the emp table I dont have name as King, which exception is raised ?

Regards

Edited by: Sarma12 on Jun 7, 2009 1:04 AM

Edited by: Sarma12 on Jun 7, 2009 2:16 AM