Question { 5128 }

Fetch an entire row from the employees table for a specific
employee ID:

Answer

select * from employees where employee_id='1381';

Question { 6474 }

I am creating an index on Emp table Empno column,if u using
this indexed column in ur SELECT stmt. where clause,then how
do u know that yr index will be working or nor?
Thanks Advance...

Answer

You execute your query like
explain plan for select sal from emp where empno='1224';
after that check this below one.
select * from table(dbms_xplan.display);
here u can find it'll be excuted by using index or TABLE ACCESS FULL

Question { 7140 }

column A column b | output
10 7 | 10
5 8 | 8
7 -9 | 7
3 5 | 5
0 6 | 6

Write a sql query to print such output.

Answer

select A,B,greatest(A,B) output from

Is This Answer Correct ?

2 Yes

0 No