INTERVIEW QUESTIONS-CARITOR

1)AGILE AND SCRUM METHADOLOGY (what is the COUNT OF DAYS ONE REQUIREMENT WILL BE TESTED)

Ans)AGILE-3 WEEKS PER REQUIREMENT

SCRUM-DAILY MEETINGS

2)DIFF UNIX COMMAND AND APPEND

Ans)Find differences in two files and put the result in third file using

 (>>) OR TO A NEW FILE MEANS(>) USE OPERATORS RESPY.

EX: File1 File2>File3.sh

File1>>File3.sh

3)FIND DUPLICATES IN A TABLE  

Ans:(USE HAVING COUNT(COL_NAME)>1

4)FIND 20^TH ROW IN A TABLE

Ans)select * from

(

Select a.*,rownum r from tab_name a

)

Where r=20

5)INLINE FUNCTION

Ans)Same as above .It is used mostly in analytical functions to retrieve values like finding 20^th row In a table.

6)DENSE RANK FUNCTION

Ans)dense_rank()over(partition by col_name order by col_name)

Used mostly in finding the ranks in salary pay of employees.

7)SECOND AND 10^TH HIGHEST SAL OF AN EMPLOYEE

Ans)select * from

(

Select A.*,DENSE_RANK() OVER (PARTITION BY DEPT ORDER BY SAL DESC) RANK FROM EMP A

)

WHERE RANK =2(OR)10

8)Using CASE STMT

MOVE CHENNAI AS CHE FROM TAB A TO TAB ‘B’ and all other locations as is:

CASE

WHEN LOC=’CHENNAI’ THEN LOC=’CHE’

ELSE

LOCATION-àSIGNIFIES ALL OTHER LOCATIONS SHOULD GO AS IN THE TAB ‘A’

END