Section-F: Subject Related Questions (Qs. 10-24)

Let a database has two tables, Customers and Orders. The following figure shows the partial data of these two tables. Based on this partial data, explain Inner, Left, Right and Full join. Show the result set of each join operation.

Section-F: Subject Related Questions (Qs. 10-24)

What is SaaS and multi-tenant architecture? How are they related? What are the advantages and disadvantages of multi-tenancy? For a multi-vendor e-commerce application, you can choose a database architecture where you can put all the vendors in a single database or each vendor in a separate database. Which architecture will you follow and why?

Section-F: Subject Related Questions (Qs. 10-24)

What do you understand about software quality assurance (SQA)? While purchasing a software system for your company, as a SQA team leader what aspects will you look into for a quality software.

Section-F: Subject Related Questions (Qs. 10-24)

Write a program in any language to find the sum of rows and columns of a m x n matrix, where m and n is taken input from the user. Give the output in the following format:

Sample Input matrix:

$\begin{array}{cccc}1& 3& 4& 2\\ 2& 4& 5& 3\\ 3& 2& 2& 1\end{array}$

Sample Output:

$$\begin{gathered} \begin{array}{ccccc}1& 3& 4& 2& 10\\ 2& 4& 5& 3& 14\\ 3& 2& 2& 5& 12\end{array} \\ \begin{array}{ccc}6& 9& 11\end{array} \end{gathered}$$

Section-F: Subject Related Questions (Qs. 10-24)

Write a program in any language to find the prime numbers between 1.. n, where n is taken as user input.

Sample input:

Enter value of n: 20

Sample Output:

Prime Numbers: 2, 3, 5, 7, 11, 13, 17, 19,

Section-F: Subject Related Questions (Qs. 10-24)

Let you procure a microfinance application and host it in your office's data centre. What kind of cyber-security threats should you be aware of and what steps would you take to mitigate the threats?