dharmendra


{ City } chennai
< Country > india
* Profession * oracle apps techno-functional
User No # 43440
Total Questions Posted # 0
Total Answers Posted # 8

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 66
Users Marked my Answers as Wrong # 9
Questions / { dharmendra }
Questions Answers Category Views Company eMail




Answers / { dharmendra }

Question { Oracle, 13164 }

Given two tables Student(SID, Name, Course) and Level(SID,
level) write the SQL statement to get the name and SID of
the student who are taking course = 3 and at freshman level.


Answer

select s.name,
c.SID
from Student s, level c
where s.sid = c.sid
and s.course = 3
and l.level = 'freshman';

Is This Answer Correct ?    0 Yes 0 No

Question { HCL, 30183 }

How you will transfer payables to general ledger?


Answer

"Payable Transfer to General Ledger" will Transfer All
Accounting entries to General Ledger.

Is This Answer Correct ?    6 Yes 1 No


Question { iGate, 25452 }

how to get second highest salary in SQL(as/4000


Answer

select max(salary) from table
where salary < (select max(salary) from table);

Is This Answer Correct ?    2 Yes 2 No

Question { Wipro, 6587 }

26. Display the earliest shipping date in the format:
DD/MON/YYYY


Answer

select to_char(sysdate,'DD/MON/YYYY') from dual;

Is This Answer Correct ?    4 Yes 2 No

Question { 74007 }

SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;


Answer

0 only

Is This Answer Correct ?    39 Yes 3 No

Question { Cognizant, 11952 }

there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?


Answer

Concept of cross join
the result will be 10 bcos 5*2 = 10

Is This Answer Correct ?    9 Yes 0 No

Question { Cap Gemini, 10609 }

How can you display the current date & current time ?


Answer

select sysdate from dual;

Is This Answer Correct ?    5 Yes 0 No

Question { Satyam, 10957 }

TABLE A TABLE B
EMPNO ENAME EMPNO ENAME
1 A 1 A
2 B 2 B
3 C 3 C
4 D 4 D
5 E 5 E
6 F
7 G
HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?


Answer

select * from b where b.empno not in(select a.empno from a);

Is This Answer Correct ?    1 Yes 1 No