Structured Query Reporter (SQR) Interview Questions and Answers

1 :: Tell me What is search Record?
How to create SQC?
How to connect other application in component interface?

Search record is a record that has at least one search key. Sqc is nothing but sqr program , but the saving convention is sqc. By using Keys, methods, and properties we can connect other application in ci.

0/5 Rating (0 vote)

Is This Answer Correct?    2 Yes 0 No

2 :: Explain the difference between Load Look up and Array?

Load Lookup is essentailly an array which acts in the form of a table. Load Lookup is used to reduce the complexity of joins - it populates the values of a certain field depending on the ke field specified from a certain table. Then the users can query from the preloaded lookup table instead of joining tables.

While arrays are used to store and retrieve data using the get and put commands

Apart from above mentioned advantages,Load Lookup increases the performance as it loads an array into memory with key and return value.

0/5 Rating (0 vote)

Is This Answer Correct?    1 Yes 0 No

3 :: What is Performance tuning of SQR?

Use Dynamic SQL, Load Lookup.

0/5 Rating (0 vote)

Is This Answer Correct?    2 Yes 0 No

4 :: Can you explain Outer join, inner join in sql?

A JOIN is a means for combining fields from two tables by using values common to each.
An outer join does not require each record in the two joined tables to have a matching record. The joined table retains each record?even if no other matching record exists. Outer joins subdivide further into left outer joins, right outer joins, and full outer joins, depending on which table(s) one retains the rows from (left, right, or both).

(In this case left and right refer to the two sides of the JOIN keyword.)

No implicit join-notation for outer joins exists in standard SQL.

Left outer join
The result of a left outer join (or simply left join) for table A and B always contains all records of the "left" table (A), even if the join-condition does not find any matching record in the "right" table (B). This means that if the ON clause matches 0 (zero) records in B, the join will still return a row in the result?but with NULL in each column from B. This means that a left outer join returns all the values from the left table, plus matched values from the right table (or NULL in case of no matching join predicate). If the left table returns one row and the right table returns more than one matching row for it, the values in the left table will be repeated for each distinct row on the right table.

For example, this allows us to find an employee's department, but still shows the employee(s) even when they have not been assigned to a department (contrary to the inner-join example above, where unassigned employees are excluded from the result).

Example of a left outer join:

SELECT *
FROM employee LEFT OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID

Right outer joins
A right outer join (or right join) closely resembles a left outer join, except with the treatment of the tables reversed. Every row from the "right" table (B) will appear in the joined table at least once. If no matching row from the "left" table (A) exists, NULL will appear in columns from A for those records that have no match in B.

A right outer join returns all the values from the right table and matched values from the left table (NULL in case of no matching join predicate).

For example, this allows us to find each employee and his or her department, but still show departments that have no employees.

Example right outer join:

SELECT *
FROM employee RIGHT OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID


Inner Join
An inner join is the most common join operation used in applications and can be regarded as the default join-type. Inner join creates a new result table by combining column values of two tables (A and B) based upon the join-predicate. The query compares each row of A with each row of B to find all pairs of rows which satisfy the join-predicate. When the join-predicate is satisfied, column values for each matched pair of rows of A and B are combined into a result row. The result of the join can be defined as the outcome of first taking the Cartesian product (or cross-join) of all records in the tables (combining every record in table A with every record in table B) - then return all records which satisfy the join predicate. Actual SQL implementations normally use other approaches like a Hash join or a Sort-merge join where possible, since computing the Cartesian product is very inefficient.

SQL specifies two different syntactical ways to express joins: "explicit join notation" and "implicit join notation".

The "explicit join notation" uses the JOIN keyword to specify the table to join, and the ON keyword to specify the predicates for the join, as in the following example:

SELECT *
FROM employee
INNER JOIN department
ON employee.DepartmentID = department.DepartmentID

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

5 :: How to generate tow output files from one SQR?

Using create report you can create multiple reports in one single SQR report to create multiple files from one sqr,we have to first initialise them with different names and while writing call the appropriate files and load them.by this way the file gets generated in the specified path

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No