BuziBr AI ns

SDLC, SQL & HTML Test

1. Write SQL statement to convert a Text String of ChequeDate (Ref. Fig. A) and Add with it 15 Years to get the
Maturity Date?
2. Write SQL statement to list the missing ChequeNo from Table RefFund (Ref. Fig. A).
3. Write SQL statement to know Payments collected for the year 2012 (Ref. Fig. A.).
4. Write SQL Statement go get flat wise total Refund Amount from Table RefFund (Ref. Fig. A).
5. Write SQL statement to calculate GST on Payments from Fig. A.
6. Differentiate between RAD and AGILE Software Development Methodologies.
7. What is Feasibility Analysis and state the importance of it in Software Development?
8. Write HTML Code to display Bottom border for the text while printing page.
9. How to insert “Page Break” using HTML to print content to next page?
10. Write HTML code to display Fig. A. As it is in Web Browser.

Fig. A (Question No. 1 to 5)

RefFund
CustomerID CustomerName Particulars Payments ChequeNo ChequeDate
11351 Ramesh Sharma Flat A1201 7,50,000 15768 15/10/2012
11390 Jogeshwar Rao Flat B1105 2,00,000 15769 15/10/2012
11351 Ramesh Sharma Flat A1201 1,00,000 15770 09/11/2012
11352 Sidharth Ranka Flat E1204 8,00,000 15772 09/11/2012
11351 Bajrangi Lal Flat D1003 9,00,000 15773 18/12/2012
11390 Jogeshwar Rao Flat B1105 3,00,000 15774 19/01/2014
11351 Bajrangi Lal Flat D1003 7,10,000 15775 11/01/2014
11255 Sandhya Flat A1101 8,10,000 15776 10/01/2012
11352 Sidharth Ranka Flat E1204 4,10,000 15777 10/02/2012
11352 Sidharth Ranka Flat E1204 4,10,000 15777 10/02/2012
11257 Jeevanth Flat E1204 4,00,000 15778 15/10/2012

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
1)
1) Assuming that you are using SQL Server, you can use the DATEADD function to add 15
years to the ChequeDate and get the Maturity Date. Here's an example SQL statement to
achieve this:

2) SELECT CustomerID, CustomerName, Particulars, Payments, ChequeNo, ChequeDate, DATEADD( YEAR , 15 ,

ChequeDate) AS MaturityDate FROM RefFund

3) This will give you a result set that includes the columns CustomerID, CustomerName, Partic-
ulars, Payments, ChequeNo, ChequeDate, and MaturityDate. The MaturityDate column will
be calculated by adding 15 years to the ChequeDate using the DATEADD function.

4) Note that the output format of MaturityDate may depend on your database settings. If you
need a specific date format, you can use the CONVERT function to format the date as
needed.

SELECT CustomerID, CustomerName, Particulars, Payments, ChequeNo, ChequeDate,

DATEADD(YEAR, 15, ChequeDate) AS MaturityDate
FROM RefFund

2)

To list the missing ChequeNo from the RefFund table, you can use the following SQL statement:

SELECT DISTINCT [Link] + 1 AS MissingChequeNo FROM RefFund RF1 WHERE NOT EXISTS ( SELECT
[Link] FROM RefFund RF2 WHERE [Link] = [Link] + 1 ) AND [Link] < ( SELECT
MAX (ChequeNo) FROM RefFund);

This query will find the missing ChequeNo by looking for ChequeNo values that are not present in
the RefFund table. It uses a subquery to check for the existence of the next ChequeNo value for
each ChequeNo in the table, and returns the next ChequeNo value if it is missing. The DISTINCT
keyword ensures that only unique values are returned.

Note that this query assumes that the ChequeNo values in the table are sequential with no gaps
in between. If there are gaps in the sequence, this query may not return accurate results.

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
SELECT DISTINCT [Link] + 1 AS MissingChequeNo
FROM RefFund RF1
WHERE NOT EXISTS (
SELECT [Link]
FROM RefFund RF2
WHERE [Link] = [Link] + 1
)
AND [Link] < (SELECT MAX(ChequeNo) FROM RefFund);

3)
To know the payments collected for the year 2012, we need to filter the data based on the year
mentioned in the ChequeDate column. The following SQL statement can be used:

SELECT SUM (Payments) AS TotalPayments FROM RefFund WHERE YEAR (ChequeDate) = 2012

This query will calculate the total payments collected in the year 2012 by summing up the Pay-
ments column for all the rows where the ChequeDate column has a year value of 2012. The result
will be returned in a single row with the column name "TotalPayments".
SELECT SUM(Payments) AS TotalPayments
FROM RefFund
WHERE YEAR(ChequeDate) = 2012

4)
To get flat wise total refund amount from the RefFund table, we need to group the records by Flat
and then calculate the sum of refund amount for each group. Here's the SQL statement to achieve
this:

SELECT Particulars, SUM(Payments) AS TotalRefundAmount FROM RefFund GROUP BY Particulars;

This statement will give you a result set with two columns - Particulars and TotalRefundAmount.
The Particulars column will contain the flat numbers, and the TotalRefundAmount column will con-
tain the total refund amount for each flat.

SELECT Particulars, SUM(Payments) AS TotalRefundAmount

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
FROM RefFund
GROUP BY Particulars;

5)

To calculate the GST on payments from Fig. A, we first need to identify the GST rate applicable on
these payments. Assuming a GST rate of 18%, the SQL statement to calculate GST on payments
can be as follows:

SELECT CustomerID, CustomerName, Particulars, Payments* 0.18 AS GST FROM RefFund;

This will give us a result set with columns for CustomerID, CustomerName, Particulars, and GST.
The GST column is calculated by multiplying the Payments column by the GST rate of 18%.

Note that this calculation assumes that the payments in the Payments column are inclusive of
GST. If the payments are exclusive of GST, the calculation would be slightly different, and the GST
would be calculated as Payments*0.18/(1+0.18).

SELECT CustomerID, CustomerName, Particulars, Payments*0.18 AS GST

FROM RefFund;

6)

6. Differentiate between RAD and AGILE Software Development Methodologies.

RAD (Rapid Application Development) and Agile are both software development methodologies that focus on it-
erative and incremental development, and both are used to deliver software products in a more efficient and
flexible way. However, there are some differences between the two methodologies.

Philosophy and Approach:

RAD is a linear sequential approach to software development, where the entire process is divided into defined
stages with each stage being completed sequentially. On the other hand, Agile is an iterative and incremental
approach where the entire process is divided into small iterations or sprints, each of which delivers a working
piece of software.

Requirements Gathering:

RAD methodology focuses on gathering and defining all requirements at the beginning of the project, and only
then proceeding to the development phase. In contrast, Agile methodology emphasizes on prioritizing require-
ments and delivering them in small chunks or sprints, with the flexibility to change and add requirements as
needed during each iteration.

Time and Cost:

RAD methodology aims to deliver projects within a short time frame by emphasizing on fast development and
faster feedback, whereas Agile methodology prioritizes delivering a quality product within the estimated time
frame and budget by delivering in small iterations and making changes and improvements as necessary.

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
Teamwork and Communication:

RAD methodology is typically used in projects where there is a strong project manager overseeing the process,
while Agile methodology emphasizes on self-organizing teams that work collaboratively and communicate fre-
quently to deliver software in a flexible and adaptive way.

Testing:

RAD methodology typically involves testing at the end of each development stage, while Agile methodology in-
volves testing at the end of each sprint, with an emphasis on automated testing throughout the process.

In summary, both RAD and Agile methodologies aim to deliver software in an efficient and flexible way, but dif-
fer in their approach to requirements gathering, time and cost management, teamwork and communication,
and testing.

7. What is Feasibility Analysis and state the importance of it in Software Development?

Feasibility analysis is an evaluation process that assesses the technical, economic, and operational feasibility of
a software project. It is a critical step in the software development life cycle (SDLC) that helps to determine
whether a proposed software project is viable and should be pursued further.

The technical feasibility of a software project is evaluated to determine whether the project can be developed
using the available technology, whether the required skills and resources are available, and whether any tech-
nical risks are involved. The economic feasibility of a project involves an analysis of the costs and benefits of the
project, including the costs of development, maintenance, and operation, as well as the expected benefits and
return on investment. Finally, the operational feasibility of a software project is evaluated to determine whether
the project can be integrated into the existing organizational infrastructure and whether it is compatible with
the organizational goals and strategies.

The importance of feasibility analysis in software development cannot be overstated. It helps to identify poten-
tial problems and risks that could affect the success of the project, and provides a basis for decision-making re-
garding whether to proceed with the project or not. It also helps to identify the most appropriate development
methodology to use, as well as the most appropriate technology, tools, and resources required to deliver a suc-
cessful software product. Feasibility analysis helps to ensure that the software development project is aligned
with the organizational goals and strategies, and that it is economically and technically feasible.

In conclusion, feasibility analysis is a crucial step in the software development process that helps to determine
whether a proposed software project is viable and should be pursued further. It helps to identify potential prob-
lems and risks, and provides a basis for decision-making regarding the project's feasibility and viability.

8. Write HTML Code to display Bottom border for the text while printing page.

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
Unfortunately, it is not possible to add a bottom border for text while printing a page using HTML alone. The
presentation of printed documents is not controlled by HTML, but by the printer and the software used to print
the document. However, it is possible to achieve this effect using CSS by creating a print style sheet and adding
a border-bottom property to the text. Here is an example:

<!DOCTYPE html>

<html>

<head>

<title>Print Style Sheet</title>

<style>

/* Style for the text */

p{

font-size: 16px;

font-weight: bold;

/* Style for the bottom border */

@media print {

p{

border-bottom: 1px solid black;

</style>

</head>

<body>

<p>This is some text with a bottom border when printed.</p>

</body>

</html>

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
In this example, a print style sheet is created using CSS media queries. The p element is styled with a font size
and weight, and a border-bottom property is added to the p element when printing the page. The border-bottom
property creates a one-pixel solid black line under the text when printed.

9. How to insert “Page Break” using HTML to print content to next page?
In HTML, you can insert a page break using the CSS page-break-before or page-break-after property. These prop-
erties indicate where a page break should occur when printing or displaying content.

Here is an example of how to insert a page break before an HTML element using the page-break-before property:

<!DOCTYPE html>

<html>

<head>

<title>Page Break Example</title>

<style>

.page-break {

page-break-before: always;

</style>

</head>

<body>

<h1>Page 1</h1>

<p>Some content here.</p>

<div class="page-break"></div>

<h1>Page 2</h1>

<p>Some more content here.</p>

</body>

</html>

In this example, a div element is used to indicate where the page break should occur. The .page-break class is
defined in the CSS with the page-break-before: always property. This tells the browser to insert a page break be-
fore the element with the .page-break class when printing or displaying the content.

Note that the page-break-before property may not work as expected on all browsers, so it is a good idea to test
your page break behavior across different browsers to ensure compatibility.

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns

10)
Unfortunately, it is not possible to display Fig. A as it is in a web browser as it is not
provided. However, based on the information provided, the following HTML code can
be used to display the data in a tabular format:

<table>
<thead>
<tr>
<th>RefFund</th>
<th>CustomerID</th>
<th>CustomerName</th>
<th>Particulars</th>
<th>Payments</th>
<th>ChequeNo</th>
<th>ChequeDate</th>
</tr>
</thead>
<tbody>
<tr>
<td></td>
<td>11351</td>
<td>Ramesh Sharma</td>
<td>Flat A1201</td>
<td>7,50,000</td>
<td>15768</td>
<td>15/10/2012</td>
</tr>
<tr>
<td></td>
<td>11390</td>
<td>Jogeshwar Rao</td>
<td>Flat B1105</td>
<td>2,00,000</td>
<td>15769</td>
<td>15/10/2012</td>
</tr>
<tr>
<td></td>
<td>11351</td>
<td>Ramesh Sharma</td>
<td>Flat A1201</td>
<td>1,00,000</td>
<td>15770</td>
<td>09/11/2012</td>
</tr>
<tr>
<td></td>

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
<td>11352</td>
<td>Sidharth Ranka</td>
<td>Flat E1204</td>
<td>8,00,000</td>
<td>15772</td>
<td>09/11/2012</td>
</tr>
<tr>
<td></td>
<td>11351</td>
<td>Bajrangi Lal</td>
<td>Flat D1003</td>
<td>9,00,000</td>
<td>15773</td>
<td>18/12/2012</td>
</tr>
<tr>
<td></td>
<td>11390</td>
<td>Jogeshwar Rao</td>
<td>Flat B1105</td>
<td>3,00,000</td>
<td>15774</td>
<td>19/01/2014</td>
</tr>
<tr>
<td></td>
<td>11351</td>
<td>Bajrangi Lal</td>
<td>Flat D1003</td>
<td>7,10,000</td>
<td>15775</td>
<td>11/01/2014</td>
</tr>
<tr>
<td></td>
<td>11255</td>
<td>Sandhya</td>
<td>Flat A1101</td>
<td>8,10,000</td>
<td>15776</td>
<td>10/01/2012</td>
</tr

QUESTION FOR PERSONAL INTERVIEW

Why BuziBrAIns should hire you? Please mention the position and minimum 5 qualities in WORDS you have for the same.
You can hire me because I strongly believe I have the distinct qualities of

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”

 BuziBr AI ns
[Link] to detail: Being able to notice even the smallest details can help identify potential is-
sues and improve the quality of the product.
[Link] skills: Being able to analyze data and identify patterns can help identify the root
cause of issues and come up with effective solutions.
[Link] skills: Being able to communicate effectively with other team members, includ-
ing developers and project managers, can help ensure that everyone is on the same page and
that issues are addressed in a timely manner.
[Link]: Being able to think outside the box can help identify new testing approaches and im-
prove the overall quality of the product.
[Link]: Being able to quickly adapt to new technologies, processes, and tools can help
stay up-to-date with the latest testing practices and methodologies.

All The Best!!!

Email : aims@[Link] Web : [Link]

“ Information Is Key To Success”