Mamsys Consultancy Services Software Developer Interview Questions and Answers

To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

• Use the ORDER BY clause to sort the table in descending order.

• Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

• Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

Ant build file can be configured using XML syntax with various tags and attributes.

• Create a build.xml file with targets and tasks

• Use tag to define project properties

• Use tag to define tasks and dependencies

• Use tag to define properties

• Use tag to define custom tasks

• Use tag to print messages

• Use tag to compile Java code

• Use tag to create JAR files

• Use tag to copy files

• Use tag to delete files

• Use tag to create directo...read more